Fatal NTSB investigations: Piper PA-28-140, 2000
7 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 | 1 |
|---|---|
| 1965 | 5 |
| 1966 | 2 |
| 1967 | 18 |
| 1968 | 21 |
| 1969 | 25 |
| 1970 | 27 |
| 1971 | 32 |
| 1972 | 23 |
| 1973 | 25 |
| 1974 | 26 |
| 1975 | 24 |
| 1976 | 13 |
| 1977 | 20 |
| 1978 | 10 |
| 1979 | 15 |
| 1980 | 3 |
| 1981 | 9 |
| 1982 | 13 |
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 7 |
| 1986 | 9 |
| 1987 | 5 |
| 1988 | 14 |
| 1989 | 6 |
| 1990 | 10 |
| 1991 | 8 |
| 1992 | 4 |
| 1993 | 10 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 7 |
| 1997 | 1 |
| 1998 | 7 |
| 1999 | 3 |
| 2000 | 7 |
| 2001 | 2 |
| 2002 | 7 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 6 |
| 2008 | 3 |
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 2000
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 ('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") = 2000
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 ('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 NYC01WA037Accident · 1 fatalForeign investigationPiper PA-28-140 · Sherbrooke, CanadaNTSB IAD01FA013Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stuart, VAPilot's continued flight into known adverse weather conditions during cruise flight. Factors in the accident were the low ceiling, dark night, and the pilot's failure to obtain in-flight weather advisories.NTSB LAX01LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gorman, CAthe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. A contributing factor was the pilot's use of impairing medications.NTSB CHI01FA024Accident · 1 fatalField investigationFinal reportPiper PA28-140 · Sparta, MIThe pilot's failure to maintain proper runway alignment on departure and his failure to maintain clearance from the trees. The pilot's attempted flight into known adverse weather, his lack of instrument experience, the fog, and the trees were contributing…NTSB LAX00FA314Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Poway, CAThe pilot's intentional flight into known adverse weather.NTSB IAD00FA053Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bealeton, VAthe flight instructor's improper pre-flight plan and decision to land and depart an airport with insufficient runway. A factor in the accident was the short grass runway with a 100-foot obstruction at the end.NTSB CHI00FA090Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Dighton, KSthe inadvertent stall. Factors relating to this accident were the pilot's inadvertent flight into known adverse weather conditions, the icing conditions, and improper in-flight planning by the pilot.