Skip to content

NTSB investigations

10 cases where NTSB found Emergency equipment.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20102026

Where

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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01022560')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01022560'))
  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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01022560'))
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 ERA19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Palatka, FLThe pilot’s improper management of his fuel supply, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the outcome was the improper maintenance of the airplane’s ballistic recovery parachute system, which resulted in its…Mar 30, 2019 · N81KK · Substantial damage NTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.Nov 23, 2016 · N80RT · Substantial damage NTSB CEN16LA079Accident · Serious injuriesLimited investigationFinal reportPiper 28-140 · Republic, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during cruise flight.Dec 31, 2015 · N4643R · Destroyed NTSB ERA14FA260Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA1B · Chester, SCThe pilot's inadequate inflight fuel monitoring, which resulted in fuel exhaustion and the subsequent total loss of engine power. Contributing to the accident was the loose fuel cap, which allowed fuel to syphon out in flight.May 23, 2014 · N8890L · Substantial damage NTSB CEN14LA194Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Lee's Summit, MOThe pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.Apr 6, 2014 · N761BT · Substantial damage NTSB ERA14FA074Accident · 1 fatalField investigationFinal reportRaytheon G36 · Panama City, FLThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the pilot’s injuries was his failure to use the available shoulder harness.Dec 18, 2013 · N89SN · Substantial damage NTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…Aug 16, 2013 · N19UA · Substantial damage NTSB DCA12FA076Accident · 1 fatalField investigationFinal reportHawker Hawker Hunter MK.58A · Point Mugu, CAthe pilot's decision to continue the flight with a known fuel imbalance condition that resulted in a loss of lateral control when the imbalance exceeded the known capabilities of the airplane. The fuel imbalance was due to incomplete refueling and an…May 18, 2012 · N329AX · Destroyed NTSB ERA11LA427Accident · 1 fatalLimited investigationFinal reportTL Ultralight Sro Sting S3 · Sarasota, FLThe inability of the pilot-in-command (PIC) to recover from an inadvertent spin following a stall demonstration for reasons that could not be determined because aircraft and engine examinations did not reveal any anomalies that would have precluded recovery…Jul 29, 2011 · N2442 · Substantial damage NTSB ANC10MA068Accident · 5 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Aleknagik, AKThe pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…Aug 9, 2010 · N455A · Substantial damage