Fatal NTSB investigations: Piper PA-28R-200, GA
6 cases on aircraft the registry lists as Piper PA-28R-200. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1972 | 1 |
|---|---|
| 1987 | 1 |
| 1992 | 1 |
| 2007 | 1 |
| 2018 | 1 |
| 2019 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102811'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102811'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA20FA021Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Atlanta, GAThe pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.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 NYC08FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Augusta, GAA loss of engine power due to the fatigue fracture of the number 2 cylinder attach studs, and the subsequent separation of the number 2 cylinder.NTSB ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.NTSB ATL87FA230Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Offerman, GADuring a local flt the acft was observed flying at a level attitude approx 10 ft above a corn field at high speed. The right wing of the acft struck tree branches approx 60 ft AGL during a pull up. A 6 ft section of the right wing separated. The acft climbed,…NTSB MIA72AM105Accident · 2 fatalClosedPiper PA-28R · Lafayette, GA