NTSB investigations
27 cases where the defining event was Altitude deviation.
Cases per year
| 2018 | 2 |
|---|---|
| 2019 | 4 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 6 |
| 2025 | 3 |
| 2026 | 2 |
Where
Open the mapLatest cases
Query 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.
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, AustraliaNTSB DCA24WA072IncidentClass 5 · ForeignBoeing 777 · Muscat, OmanNTSB DCA24WA066IncidentClass 5 · ForeignAirbus A320 · Geneva, SwitzerlandNTSB GAA24WA027Incident · No injuriesClass 5 · ForeignFokker F28 · Adelaide Aerodrome, AustraliaNTSB DCA23WA437IncidentClass 5 · ForeignEmbraer 190 · Alice Springs, AustraliaNTSB WPR23FA257Accident · 6 fatalClass 3 · FieldFinal reportCessna 550 · Murrieta, CAThe flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…NTSB ENG24WA001IncidentClass 5 · ForeignDe Havilland DHC8 · Timaru, New ZealandNTSB DCA23LA172Incident · No injuriesClass 4 · LimitedFinal reportBoeing 777 · Kahului, HIThe flight crew’s failure to manage the airplane’s vertical flightpath, airspeed, and pitch attitude following a miscommunication about the captain’s desired flap setting during the initial climb.NTSB DCA23WA045IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaNTSB DCA23WA033IncidentClass 5 · ForeignSaab 340 · Sydney, AustraliaNTSB DCA23WA032IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaNTSB DCA22WA039IncidentClass 5 · ForeignBoeing 737 · Kuusamo, FinlandNTSB DCA20WA152IncidentClass 5 · ForeignBoeing 737 · Paris, FranceNTSB OPS19WA018Incident · No injuriesForeign investigationAirbus A321 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A-321-231, which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB DCA19WA144Incident · No injuriesForeign investigationBoeing 737 · Las Palmas, SpainThe CIAIAC of Spain has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…NTSB WPR19FA080Accident · 2 fatalClass 2 · FieldFinal reportCessna 172 · Desert Hot Springs, CAThe pilot's inadequate and/or improper preparation for the flight in which he selected an altitude too low to assure terrain clearance and resulted in an impact with terrain in turbulent downdraft conditions.NTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.NTSB ERA18LA087Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander Callair A 9 · Bunn, NCThe glider instructor's delayed remedial action when the glider became out of position during aerotow, which resulted in excessive side-loading of the release hook and a delay in the glider's release from tow, which resulted in the towplane’s descent and…