Fatal NTSB investigations: Piper PA-28-180, IL
7 cases on aircraft the registry lists as Piper PA-28-180. 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
| 1967 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 1 |
| 1982 | 1 |
| 1989 | 1 |
| 1991 | 2 |
Where
Latest 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\" = 'IL' 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 ('7102808'))
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" = 'IL' 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 ('7102808'))
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 CHI91FA216Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Seneca, ILProper glidepath not maintained, and inadequate altitude and visual lookout by the pilot in command.NTSB CHI91FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Quincy, ILThe failure by the pilot of the other airplane to maintain clearance. Factors in the accident were the pilot's attempt to fly formation, his inadequate group briefing, and the lack of experience on the part of the pilot of the other airplane.NTSB CHI89GA048Accident · 2 fatalFinal reportPiper PA-28-180 · Chicago, ILInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: high obstructions and retaining wall in the emergency landing area.NTSB CHI82FA266Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Hartsburg, ILAt 1223 CDT the plt contacted peoria approach control & requested radar vectors to the Mt. Hawley arpt located just northof the peoria arpt. At 1227 CDT he stated the weather was getting bad & he would like to fly to the logan county arpt. One witness stated…NTSB CHI73AC084Accident · 2 fatalClosedPiper PA-28 · Aledo, ILNTSB NYC73AN081Accident · 4 fatalClosedPiper PA-28 · Grand Tower, ILNTSB CHI67A0097Accident · 2 fatalClosedPiper PA-28 · Chicago, IL