NTSB investigations
63 cases where NTSB found Aircraft oper/perf/capability, general.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010600')) 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", '010600')) 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 CEN09CA496Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 240A · Albuquerque, NMA run-on landing of the balloon causing the basket to tip over, resulting in a passenger's injury.NTSB CEN09LA502Accident · Serious injuriesLimited investigationFinal reportCessna 337F · Frankfort, MIThe pilot intentionally attempting to take off with an inoperative engine, which lead to the airplane's inability to maintain airspeed in the initial climb, resulting in a stall and impact with trees.NTSB ANC09LA072Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 · Iliamna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.NTSB CEN09CA452Accident · Minor injuriesData collectionFinal reportWeatherly 620B · New England, NDThe loss of engine power for undetermined reasons while maneuvering at low altitude.NTSB ANC09CA056Accident · No injuriesData collectionFinal reportMaule M-5-235C · Wasilla, AKThe pilot's selection of an unsuitable takeoff area with an unfavorable wind.NTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.NTSB ANC09CA028Accident · No injuriesData collectionFinal reportPiper PA-12 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.NTSB ANC09LA022Accident · No injuriesLimited investigationFinal reportDehavilland DHC-2 / U-6A · Kenai, AKThe flight instructor’s decision to attempt a touch-and-go landing toward rising terrain and with a tailwind, resulting in an in-flight collision with terrain during takeoff.NTSB DEN08CA161AccidentData collectionFinal reportQuicksilver MX II Sprint · Killeen, TXThe operator's failure to maintain clearance from objects during the landing roll. Contributing to the accident was the operator's decision to operate a vehicle for which he/she was not certified.NTSB ANC08CA132Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for landing.NTSB DEN08LA137Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2A · Brackettville, TXThe failure of the pilot of N777UN to exit the thermal upon losing visual contact with the other gliders, resulting in a midair collision.NTSB DEN08FA101Accident · 4 fatalField investigationFinal reportBell 407 · Huntsville, TXThe pilot's failure to identify and arrest the helicopter's descent, which resulted in its impact with terrain. Contributing to the accident was the limited outside visual reference due to the dark night conditions.NTSB NYC08CA084Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Brooksville, FLA deer darting into the path of the airplane during the landing roll.