NTSB defining event · CICTT: Navigation Error
CICTT occurrence categories (PDF)CICTT phases of flight (PDF)
- Defining event in
- 27 cases
- In the sequence of
- 104 cases
- Fatal cases
- 4
- NTSB code
- 282
NTSB has coded findings and defining events since 2008. Earlier cases used its older occurrence and cause codes, so they aren’t counted here.
When and where
In green, cases where it was the defining event; in gray, cases where it came elsewhere in the sequence. The map shows the cases where it was the defining event. Events are coded with the final report, so the latest years are incomplete.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 2 |
| 2010 | 9 |
| 2011 | 5 |
| 2012 | 6 |
| 2013 | 7 |
| 2014 | 8 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 6 |
| 2018 | 4 |
| 2019 | 5 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 9 |
| 2023 | 7 |
| 2024 | 7 |
| 2025 | 3 |
| 2026 | 2 |
Where
Open the mapQuery with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT e.case_mkey) AS cases,
count(DISTINCT e.case_mkey) FILTER (WHERE e.\"isDefiningEvent\") AS defining
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = e.case_mkey
WHERE e.\"tier2Number\" = '282' AND e.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")
GROUP BY 1
ORDER BY 1"Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT year(c."eventDate") AS year, count(DISTINCT e.case_mkey) AS cases, count(DISTINCT e.case_mkey) FILTER (WHERE e."isDefiningEvent") AS defining FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = e.case_mkey WHERE e."tier2Number" = '282' AND e.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent") GROUP BY 1 ORDER BY 1
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
In these cases
Aircraft matched to the registry by N-number and date.
Query with SQL
duckdb -csv -c "WITH defining AS (SELECT * FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"tier2Number\" = '282' AND \"isDefiningEvent\")
SELECT * FROM (
SELECT 'Phase of flight' AS kind, e.\"tier1Number\" AS code, max(e.\"eventTier1Name\") AS name, count(DISTINCT e.case_mkey) AS cases
FROM defining e
GROUP BY ALL
UNION ALL
SELECT 'Finding in the probable cause', left(f.\"findingCode\", 8), max(f.\"tier4Name\"), count(DISTINCT f.case_mkey)
FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f ON f.case_mkey = e.case_mkey AND f.aircrafts_position = e.aircrafts_position AND f.\"inProbableCause\"
WHERE f.\"findingCode\" GLOB '[0-9][0-9]*'
GROUP BY ALL
UNION ALL
SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT e.case_mkey)
FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = e.case_mkey AND a.position = e.aircrafts_position
LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
WHERE a.aircraft_model_code IS NOT NULL
GROUP BY ALL
)
QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
ORDER BY kind, cases DESC"Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
WITH defining AS (SELECT * FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "tier2Number" = '282' AND "isDefiningEvent")
SELECT * FROM (
SELECT 'Phase of flight' AS kind, e."tier1Number" AS code, max(e."eventTier1Name") AS name, count(DISTINCT e.case_mkey) AS cases
FROM defining e
GROUP BY ALL
UNION ALL
SELECT 'Finding in the probable cause', left(f."findingCode", 8), max(f."tier4Name"), count(DISTINCT f.case_mkey)
FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f ON f.case_mkey = e.case_mkey AND f.aircrafts_position = e.aircrafts_position AND f."inProbableCause"
WHERE f."findingCode" GLOB '[0-9][0-9]*'
GROUP BY ALL
UNION ALL
SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT e.case_mkey)
FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = e.case_mkey AND a.position = e.aircrafts_position
LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
WHERE a.aircraft_model_code IS NOT NULL
GROUP BY ALL
)
QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
ORDER BY kind, cases DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
Newest cases · 27
NTSB ERA26FA214Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-25-235 · Saratoga Springs, NYOn May 26, 2026, about 1347 eastern daylight time, a Piper PA-25-235 airplane, N8656L, was substantially damaged when it was involved in an accident near Saratoga Springs, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB DCA26FA194Accident · Minor injuriesClass 3 · FieldPreliminary reportBoeing 767-424ER · Newark, NJOn May 3, 2026, about 13:50 eastern daylight time (EDT), United Airlines flight 169, Boeing B767-424ER, N77066, struck a light pole on the New Jersey turnpike while on final approach to runway 29 at Newark Liberty International Airport (EWR), Newark, New…NTSB DCA26WA042Incident · No injuriesClass 5 · ForeignBoeing 737 · Malaga, SpainNTSB DCA25WA327IncidentClass 5 · ForeignBoeing 767 · Sydney, AustraliaNTSB DCA25WA318IncidentClass 5 · ForeignBoeing 787 · Frankfurt, GermanyNTSB DCA24WA334IncidentClass 5 · ForeignBoeing 757-224 · Brussels, BelgiumNTSB DCA24WA184IncidentClass 5 · ForeignEmbraer ERJ190 · Brisbane Airport, AustraliaNTSB ENG24WA038Incident · No injuriesClass 3 · ForeignDornier 328 · Zurich, SwitzerlandNTSB DCA24WA292IncidentClass 5 · ForeignDornier 328 · Zurich, SwitzerlandNTSB GAA25WA085Incident · No injuriesClass 5 · ForeignSikorsky S92A · Offshore Vessel, Australia
See all 27 casesQuery with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '282') ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '282') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.