NTSB investigations: Piper PA-28-140, 1973, IL
12 cases on aircraft the registry lists as Piper PA-28-140. 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 | 5 |
| 1966 | 6 |
| 1967 | 11 |
| 1968 | 9 |
| 1969 | 15 |
| 1970 | 12 |
| 1971 | 17 |
| 1972 | 9 |
| 1973 | 12 |
| 1974 | 9 |
| 1975 | 11 |
| 1976 | 3 |
| 1977 | 6 |
| 1978 | 6 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 3 |
| 1994 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2011 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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 year(c.\"eventDate\") = 1973
AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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 year(c."eventDate") = 1973
AND c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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 CHI74FEE36Accident · No injuriesClosedPiper PA-28 · Chicago, ILNTSB CHI74DEV25Accident · No injuriesClosedPiper PA-28 · Rowe, ILNTSB CHI74FEE24Accident · No injuriesClosedPiper PA-28 · Plainfield, ILNTSB CHI74DEV19Accident · Minor injuriesClosedPiper PA-28 · Bloomington, ILNTSB CHI74FEV16Accident · Serious injuriesClosedPiper PA-28 · Mt Sterling, ILNTSB CHI74FEE12Accident · No injuriesClosedPiper PA-28 · Elburn, ILNTSB CHI74FEE04Accident · No injuriesClosedPiper PA-28 · Lansing, ILNTSB CHI73FEE62Accident · Minor injuriesClosedPiper PA-28 · Naperville, ILNTSB CHI73FEV26Accident · Minor injuriesClosedPiper PA-28 · Springfield, ILNTSB CHI73DEE41Accident · No injuriesClosedPiper PA-28 · Joliet, ILNTSB CHI73FEE40Accident · No injuriesClosedPiper PA-28 · Elgin, ILNTSB CHI73DEE39Accident · No injuriesClosedPiper PA-28 · Lansing, IL