Fatal NTSB investigations, GA
5 cases where the sequence of events included Aircraft maintenance event.
Cases per year
| 2011 | 2 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2018 | 1 |
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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '040' 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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '040' 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 ERA18FA137Accident · 1 fatalField investigationFinal reportPiper PA28R · Gainesville, GAA partial loss of engine power due to inadequate thru-bolt and stud preload tension by undetermined maintenance personnel, which resulted in fretting between the engine crankcase halves, and the subsequent separation of the No. 2 cylinder due to the fatigue…NTSB ERA14FA168Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Brunswick, GAAn inflight failure of the airplane's only operating vacuum pump, which resulted in the loss of attitude information provided by vacuum-driven flight instruments. Also causal was the pilots' failure to maintain control of the airplane while operating in…NTSB ERA12LA141Accident · 1 fatalLimited investigationFinal reportBowers Fly Baby 1-A · Jefferson, GAThe pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…NTSB ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.NTSB ERA11FA406Accident · 1 fatalField investigationFinal reportMooney M20K · Augusta, GAThe pilot’s decision to fly the airplane after maintenance personnel advised him that the airplane should not be flown because the pilot provided an incorrect propeller for installation and the subsequent failure of the propeller attachment bolts and the…