Examples

PreFlight — Deterministic Upstream Data Ingestion Gate

Purpose

  • Demonstrates deterministic verdict outcomes produced by PreFlight v1.01
  • Illustrates observable enforcement states at the ingestion boundary
  • Artifacts reflect execution evidence only

PASS

Condition:

  • Structure is deterministically traversable
  • No mechanically provable ingestion risk detected

Verdict: PASS — Downstream execution permitted

PRE-FLIGHT EXECUTION SUMMARY — PASS

Dataset: Border_Crossing_Entry_Data.csv
Dataset Size: 44.86 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ PASS
Row Iteration Viability ............ PASS
Numeric Type Corruption ............ PASS
Multiple Valid Representations ..... PASS
High Null Density Columns .......... PASS
Malformed or Truncated Rows ........ PASS
Text Encoding Corruption ........... PASS

Final Verdict: PASS
Rows Evaluated: 405972
Deterministic Reduction: ACTIVE
PRE-FLIGHT EXECUTION SUMMARY — PASS

Dataset: Medallion_Drivers_-_Active_20260122.csv
Dataset Size: 14.73 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ PASS
Row Iteration Viability ............ PASS
Numeric Type Corruption ............ PASS
Multiple Valid Representations ..... PASS
High Null Density Columns .......... PASS
Malformed or Truncated Rows ........ PASS
Text Encoding Corruption ........... PASS

Final Verdict: PASS
Rows Evaluated: 178117
Deterministic Reduction: ACTIVE
PRE-FLIGHT EXECUTION SUMMARY — PASS

Dataset: fd_incidents_2025_datasd.csv
Dataset Size: 25.03 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ PASS
Row Iteration Viability ............ PASS
Numeric Type Corruption ............ PASS
Multiple Valid Representations ..... PASS
High Null Density Columns .......... PASS
Malformed or Truncated Rows ........ PASS
Text Encoding Corruption ........... PASS

Final Verdict: PASS
Rows Evaluated: 184925
Deterministic Reduction: ACTIVE

WARN

Condition:

  • Structural exposure detected without provable corruption

Verdict: WARN — Downstream execution permitted with exposure

PRE-FLIGHT EXECUTION SUMMARY — WARN

Dataset: Special_Studies_20260120.csv
Dataset Size: 44.6 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ PASS
Row Iteration Viability ............ PASS
Numeric Type Corruption ............ PASS
Multiple Valid Representations ..... WARN
High Null Density Columns .......... PASS
Malformed or Truncated Rows ........ PASS
Text Encoding Corruption ........... PASS

Final Verdict: WARN
Triggering Test: Multiple Valid Representations
Rows Evaluated: 998418
Deterministic Reduction: ACTIVE
PRE-FLIGHT EXECUTION SUMMARY — WARN

Dataset: Consumer_Airfare_Report__Table_6_-_Contiguous_State_City-Pair_Markets_That_Average_At_Least_10_Passengers_Per_Day_20260120.csv
Dataset Size: 168.2 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ PASS
Row Iteration Viability ............ PASS
Numeric Type Corruption ............ PASS
Multiple Valid Representations ..... WARN
High Null Density Columns .......... WARN
Malformed or Truncated Rows ........ PASS
Text Encoding Corruption ........... PASS

Final Verdict: WARN
Triggering Tests: Multiple Valid Representations, High Null Density Columns
Rows Evaluated: 649604
Deterministic Reduction: ACTIVE
PRE-FLIGHT EXECUTION SUMMARY — WARN

Dataset: Conditions_Contributing_to_COVID-19_Deaths,_by_State_and_Age,_Provisional_2020-2023_20260120.csv
Dataset Size: 124.3 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ PASS
Row Iteration Viability ............ PASS
Numeric Type Corruption ............ PASS
Multiple Valid Representations ..... WARN
High Null Density Columns .......... PASS
Malformed or Truncated Rows ........ PASS
Text Encoding Corruption ........... PASS

Final Verdict: WARN
Triggering Test: Multiple Valid Representations
Rows Evaluated: 621000
Deterministic Reduction: ACTIVE

BLOCK

Condition:

  • Mechanical evidence establishes deterministic ingestion failure

Verdict: BLOCK — Downstream execution not recommended

PRE-FLIGHT EXECUTION SUMMARY — BLOCK

Dataset: Sacramento_Call_for_Service_Data_2025_-5375565618606923720.csv
Dataset Size: 105.39 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ PASS
Row Iteration Viability ............ PASS
Numeric Type Corruption ............ BLOCK
Multiple Valid Representations ..... WARN
High Null Density Columns .......... PASS
Malformed or Truncated Rows ........ PASS
Text Encoding Corruption ........... PASS

Final Verdict: BLOCK
Triggering Tests: Numeric Type Corruption; Multiple Valid Representations
Deterministic Reduction: BLOCK triggered by numeric coercion failure during deterministic reduction.
PRE-FLIGHT EXECUTION SUMMARY — BLOCK

Dataset: DOT__Recalls_Data.csv
Dataset Size: 23.01 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ PASS
Row Iteration Viability ............ PASS
Numeric Type Corruption ............ BLOCK
Multiple Valid Representations ..... WARN
High Null Density Columns .......... PASS
Malformed or Truncated Rows ........ PASS
Text Encoding Corruption ........... PASS

Final Verdict: BLOCK
Triggering Tests: Numeric Type Corruption; Multiple Valid Representations
Rows Evaluated: 29669
Deterministic Reduction: BLOCK issued due to non-coercible numeric token in an unambiguous numeric column.

ANALYSIS_INCOMPLETE

Condition:

  • Mechanical evidence insufficient to establish ingestion safety

Verdict: ANALYSIS_INCOMPLETE — Admission not proven

PRE-FLIGHT EXECUTION SUMMARY — ANALYSIS_INCOMPLETE

Dataset: ACSDP5YAIAN2021.DP02-Data.csv
Dataset Size: 70.3 KB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ ANALYSIS_INCOMPLETE
Row Iteration Viability ............ ANALYSIS_INCOMPLETE
Numeric Type Corruption ............ ANALYSIS_INCOMPLETE
Multiple Valid Representations ..... ANALYSIS_INCOMPLETE
High Null Density Columns .......... ANALYSIS_INCOMPLETE
Malformed or Truncated Rows ........ ANALYSIS_INCOMPLETE
Text Encoding Corruption ........... ANALYSIS_INCOMPLETE

Final Verdict: ANALYSIS_INCOMPLETE
Deterministic Reduction: Insufficient structural evidence for ingestion safety assessment.
PRE-FLIGHT EXECUTION SUMMARY — ANALYSIS_INCOMPLETE

Dataset: ACSST1Y2024.S0101-Data.csv
Dataset Size: 43.6 KB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ ANALYSIS_INCOMPLETE
Row Iteration Viability ............ ANALYSIS_INCOMPLETE
Numeric Type Corruption ............ ANALYSIS_INCOMPLETE
Multiple Valid Representations ..... ANALYSIS_INCOMPLETE
High Null Density Columns .......... ANALYSIS_INCOMPLETE
Malformed or Truncated Rows ........ ANALYSIS_INCOMPLETE
Text Encoding Corruption ........... ANALYSIS_INCOMPLETE

Final Verdict: ANALYSIS_INCOMPLETE
Deterministic Reduction: Insufficient structural evidence for ingestion safety assessment.
PRE-FLIGHT EXECUTION SUMMARY — ANALYSIS_INCOMPLETE

Dataset: EPA__annual_conc_by_monitor_2025.csv
Dataset Size: 31.02 MB
Engine: PreFlight v1.01

Tests:
Schema Structural Integrity ........ ANALYSIS_INCOMPLETE
Row Iteration Viability ............ ANALYSIS_INCOMPLETE
Numeric Type Corruption ............ ANALYSIS_INCOMPLETE
Multiple Valid Representations ..... ANALYSIS_INCOMPLETE
High Null Density Columns .......... ANALYSIS_INCOMPLETE
Malformed or Truncated Rows ........ ANALYSIS_INCOMPLETE
Text Encoding Corruption ........... ANALYSIS_INCOMPLETE

Final Verdict: ANALYSIS_INCOMPLETE
Deterministic Reduction: Insufficient structural evidence for ingestion safety assessment.

Deterministic Observation

  • Identical inputs produce identical outcomes
  • Enforcement behavior is mechanical
  • No semantic interpretation
  • No configuration assumptions implied
PRE-FLIGHT ENFORCEMENT OBSERVATION — v1.01

Behavior Model:
Deterministic upstream ingestion enforcement.

Observed Outcomes:
PASS .................. Structure safely traversable
WARN .................. Structural exposure present
BLOCK ................. Deterministic ingestion failure
ANALYSIS_INCOMPLETE ... Mechanical evidence insufficient

Execution Properties:
• Fixed test order
• Mechanical verdict reduction
• No adaptive behavior
• Identical inputs produce identical outcomes
Access PreFlight Tool