NTSB investigations
3,372 cases where the sequence of events included Off-field or emergency landing.
Cases, newest first
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DFW08LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Quinton, OKAn undetermined mechanical malfuction associated with the tail rotor drive system which led to a loss of control.NTSB SEA08LA104Accident · No injuriesLimited investigationFinal reportRobinson R44 · Pahrump, NVThe loss of the engine to transmission drive train continuity while on approach for undetermined reasons. Contributing to the accident were lack of suitable terrain for a run-on landing, and cars on the race track.NTSB DFW08TA092Accident · No injuriesFinal reportRobinson R44 · Topeka, KSA malfunctioning magneto, resulting in a high engine rpm and low rotor warning indications. A contributing factor was the impact with a light pole, during the precautionary landing.NTSB LAX08LA089Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Redding, CAA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel tank selector.NTSB DEN08LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Elizabeth, COthe loss of engine power due to the fatigue failure of the camshaft gear. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX08LA088Accident · Minor injuriesLimited investigationFinal reportBeech F33A · San Diego, CAA loss of engine power due to fuel starvation as a result of the pilot's improper use of the mixture control.NTSB NYC08LA137Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Middlesboro, KYThe mechanic's improper maintenance installation of the No. 1 cylinder rocker arms which led to oil starvation and a loss of engine power.NTSB NYC08CA132Accident · No injuriesData collectionFinal reportRotorway 162F · Cartersville, GAThe owner/builder's improper installation of the foot pedal scissor beam, which resulted in its failure during hover flight.NTSB SEA08LA084Accident · Serious injuriesLimited investigationFinal reportRaytheon B36TC · Mammoth, CAA loss of engine power for undetermined reasons. Contributing to the accident was dense snow covering the level terrain.NTSB LAX08LA066Accident · Serious injuriesLimited investigationFinal reportBartle Lancair IV-P · Murrieta/Temecu, CAA total loss of engine power while on approach due to the electrical overload of a fuse caused by the builder's inadequate design and installation of the electrical ignition system.NTSB NYC08LA106Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Pahokee, FLThe pilot's decision to depart with a known deficiency with the engine, which resulted in a loss of engine power. Contributing to the accident was the loss of engine power due to the failure of the engine-driven fuel pump.NTSB DFW08LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Spring, TXFailure of the pilot to ensure that the fuel system was purged of water prior to flight. Contributing to the severity of injuries was the lack of shoulder restraints.NTSB LAX08LA056Accident · No injuriesLimited investigationFinal reportSmith Zodiac 601XL · Murrieta, CAA loss of engine power due to fuel starvation, which was induced by the electrical system lacking sufficient power to run all of the electrical devices on the airplane and the electrical fuel pump.NTSB DFW08LA058Accident · No injuriesLimited investigationFinal reportPiper PA32-301FT · Wiggins, MSThe failure of the fuel servo gasket and subsequent partial loss of engine power. Contributing to the accident was the none-suitable terrain for the forced landing.NTSB NYC08LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-R200 · York, SCLoss of engine power due to improper welding of the crankcase, which resulted in fatigue failure of the through-studs and a subsequent separation of the number two cylinder. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB DEN08LA054Accident · No injuriesLimited investigationFinal reportMacAdams Titan Tornado 912 · Rock Springs, WYThe loss of engine power for undetermined reasons. Contributing to the accident was the snow covered ravine.NTSB MIA08LA043Accident · No injuriesLimited investigationFinal reportCessna U206F · Kissimmee, FLThe probable cause of this accident is undetermined.NTSB MIA08LA041Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Norwood, MAThe loss of engine power for undetermined reasons. *This report was modified on May 20, 2008.*NTSB ANC08LA032Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Aniak, AKA partial loss of engine power for an undetermined reason. Contributing to the accident were the pilot's inadvertent encounter with IMC conditions, and a whiteout during his attempted go-around from an emergency landing approach.NTSB NYC08CA083Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Fenner, NYThe pilot's delayed decision to perform a precautionary landing. Contributing to the accident was the reduced visibility in snow and the soft terrain.NTSB SEA08LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Centerville, WAA loss of engine power due to carburetor icing conditions and the failure of the pilot to use the correct amount of carburetor heat for the existing conditions.NTSB NYC08LA077Accident · No injuriesLimited investigationFinal reportBell 407 · DeLand, FLA total loss of engine power due to the fatigue failure of a third stage turbine wheel blade.