NTSB investigations
1,515 cases where the sequence of events included Abnormal runway contact.
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\" = '090' 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" = '090' 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 NYC08CA179Accident · Minor injuriesData collectionFinal reportCessna T182T · Newport, RIThe pilot's failure to maintain adequate airspeed during a go-around. Contributing to the accident was the pilot's improper weather evaluation and a tailwind.NTSB ANC08LA058Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Tetlin, AKThe instructor pilot's inadequate supervision of the student, resulting in a loss of control while landing.NTSB MIA08CA092Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper recovery from a bounced landing.NTSB CHI08LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Monroe, WIThe pilot's decision to land on the wrong runway for the existing wind conditions and his improper recovery from a bounced landing.NTSB CHI08CA091Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe pilot's misjudgment of the landing flare and her inadequate recovery from the bounced landing.NTSB NYC08TA130Accident · No injuriesFinal reportCessna 180 · Spartanburg, SCThe pilot's encounter with wake turbulence during approach as a result of his inadequate in-flight planning.NTSB LAX08LA073Accident · No injuriesLimited investigationFinal reportCessna 402C · Mercury, NVA loss of power to both engines resulting from a fitting failure and leak at the right fuel selector valve that allowed fuel from the right tank to be lost overboard, and that then introduced air into the left engine's fuel lines during an attempted…NTSB MIA08CA073Accident · No injuriesData collectionFinal reportCessna 182 · Fort Lauderdale, FLThe pilot's failure to maintain directional control during recovery from a bounced landing.NTSB DFW08CA075Accident · No injuriesData collectionFinal reportRobinson R-22 · Meraux, LAThe pilot's failure to ensure calculate weight and balance prior to flight. A contributing factor was the prevailing gusty winds.NTSB NYC08CA119Accident · No injuriesData collectionFinal reportCessna 182Q · S.Charleston, WVThe pilot's failure to obtain a proper touchdown point. Contributing to the accident was the windshear as reported by the pilot.NTSB NYC08CA118Accident · No injuriesData collectionFinal reportCessna 172SP · Lincoln Park, NJThe certificated flight instructor's delayed decision to go-around.NTSB LAX08CA057Accident · No injuriesData collectionFinal reportRobinson R44 II · Bullhead City, AZThe pilot's misjudged landing flare, inadequate bounced landing recovery, and failure to maintain directional control during a bounced landing that resulted in the tail rotor blades colliding with a hangar. Contributing to the accident was the burned out…NTSB DEN08CA051Accident · No injuriesData collectionFinal reportPiper PA-32-301XTC · Taos, NMThe pilot's excessive airspeed during the approach and loss of control during the landing. Contributing factors were the mountain turbulence and the snowbank.NTSB MIA08CA042Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Atlanta, GAThe failure of the pilot-in-command to maintain directional control of the airplane during landing.NTSB CHI08CA062Accident · Minor injuriesData collectionFinal reportMcGuire RAF2000 · Valparaiso, INThe pilot's inadequate compensation for wind conditions during the landing roll. A factor was the gusting crosswind.