NTSB investigations

8 cases where the defining event was Navigation error.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20092026

NTSB investigations per year, 2009–2026: 8 cases
2009	1
2017	2
2018	3
2020	1
2022	1

Where

Open the map

Latest cases

Query with SQL

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" = '280') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = '280')
  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" = '280')
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.

NTSB ERA23LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Elizabethtown, KYThe pilot's decision to continue the taxi without visual reference to the surface, due to his vision being impaired by darkness and glare, which resulted in the airplane’s departure from the paved surface and impact with a ditch. Contributing was the flight…Oct 15, 2022 · N63663 · Substantial damage NTSB DCA20WA117Incident · No injuriesForeign investigationBoeing 787 · Dubai, United Arab EmiratesThe GCAA of United Arab Emirates has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on June 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA of United Arab Emirates's investigation under the…Jun 8, 2020 · A6-BMD · No damage NTSB CEN19CA017Accident · No injuriesData collectionFinal reportPiper PA28R · Hobbs, NMThe pilot's incorrect altimeter setting during the night visual approach, which resulted in a controlled flight into terrain.Oct 28, 2018 · N6899C · Substantial damage NTSB DCA18WA136Incident · No injuriesForeign investigationBoeing 737 · Ballina/Byron Gateway Aerodome, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on February 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…Feb 18, 2018 · unknown · No damage NTSB DCA18WA134Incident · No injuriesForeign investigationBoeing 717 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 717 airplane that occurred on February 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…Feb 5, 2018 · unknown · No damage NTSB OPS18IA003IncidentClass 3 · IncidentFinal reportBombardier CL600 2D24 · Medford, ORThe incident was caused by the air traffic controller assigning an altitude below the published procedure altitude for the approach segment to be flown prior to the aircraft being established on a published portion of the approach. Contributing to the…Dec 25, 2017 · N162PQ · No damage NTSB DCA17WA170Incident · No injuriesForeign investigationAirbus A320 214 · Cali, ColombiaThe Grupo de Investigacion de Accidentes of Colombia has notified the NTSB of an incident involving a AIRBUS A320 214 airplane that occurred on July 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's…Jul 3, 2017 · N742AV · No damage NTSB ANC09LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Anchorage, AKThe pilot's unfamiliarity with the airport environment, which resulted in his taxiing the airplane onto a no-taxi section of roadway and into a road sign. Contributing to the accident was the pilot's failure to avail himself of additional information that…Jul 18, 2009 · N7136Q · Substantial damage