Fatal NTSB investigations: Piper PA-24-400
15 cases on aircraft the registry lists as Piper PA-24-400. 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
| 1964 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 1992 | 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.\"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 ('7102408'))
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."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 ('7102408'))
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 ATL92FA152Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Dovesville, SCThe loss of engine power which resulted from an undetermined malfunction of the ignition system. A factor was fog.NTSB DEN91FA039Accident · 2 fatalField investigationFinal reportPiper PA-24-400 · Snowmass, COThe pilot's failure to maintain a proper altitude in mountainous terrain.NTSB DEN84FA108Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Saratoga, WYDuring a night x-country after a 16 hour day the airline captain flying his own acft home collided with a mountain at the 10000 ft level. The weather was VMC but the winds aloft were strong and would have blown the acft towardthe mountain had no wind…NTSB OAK77FA021Accident · 1 fatalClosedPiper PA-24 · Elko, NVNTSB NYC74AN031Accident · 2 fatalClosedPiper PA-24 · Montoursville, PANTSB MIA71AM078Accident · 1 fatalClosedPiper PA-24 · Marianna, FLNTSB NYC70AN066Accident · 2 fatalClosedPiper PA-24 · Cape May, NJNTSB OAK69A0053Accident · 1 fatalClosedPiper PA-24 · Smartville, CANTSB MKC69A0014Accident · 1 fatalClosedPiper PA-24 · Stewartville, MNNTSB NYC66A0148Accident · 2 fatalClosedPiper PA-24 · Shirley, NYNTSB NYC66A0088Accident · 1 fatalClosedPiper PA-24 · Monticello, MENTSB CHI66A0062Accident · 1 fatalClosedPiper PA-24 · Cascade, MINTSB OAK66A0018Accident · 2 fatalClosedPiper PA-24 · Murphys, CANTSB UNK65X1122Accident · 2 fatalClosedPiper PA-24 · Philip, SDNTSB UNK65X1121Accident · 1 fatalClosedPiper PA-24 · Hutchinson, KS