NTSB investigations: Piper PA-24, 1999
7 cases on aircraft the registry lists as Piper PA-24. 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
| 1962 | 1 |
|---|---|
| 1964 | 34 |
| 1965 | 36 |
| 1966 | 48 |
| 1967 | 31 |
| 1968 | 25 |
| 1969 | 25 |
| 1970 | 13 |
| 1971 | 17 |
| 1972 | 15 |
| 1973 | 13 |
| 1974 | 15 |
| 1975 | 11 |
| 1976 | 6 |
| 1977 | 13 |
| 1978 | 7 |
| 1979 | 4 |
| 1980 | 5 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 6 |
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 2 |
| 1991 | 7 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 3 |
| 2006 | 1 |
| 2007 | 2 |
| 2009 | 2 |
| 2012 | 1 |
| 2015 | 2 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 3 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 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 year(c.\"eventDate\") = 1999
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102402'))
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") = 1999
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102402'))
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 LAX99FA316Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · June Lake, CAThe pilot's continued VFR flight into known instrument meteorological conditions, including icing, which resulted in an in-flight collision with mountainous terrain.NTSB CHI99LA315Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Eden Prairie, MNthe failure of the pilot to follow the landing checklist and his failure to extend the landing gear.NTSB CHI99LA246Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Boscobel, WIthe pilot's improper approach to landing. Factors included the carburetor icing, the delayed use of carburetor heat, the unsuitable terrain for landing, and the ditch.NTSB MIA99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Fort Myers, FLThe pilot's failure to verify that the retractable landing gear were down and locked for landing.NTSB SEA99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Hillsboro, ORA loose alternator drive belt, and the flight crew's decision to continue flight with a known electrical system deficiency, resulting in disabling of the aircraft electrical system and landing with the gear not down-and-locked.NTSB ATL99FA081Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Vicksburg, MSThe pilot's failure to obtain and maintain flying speed that resulted in an inadvertent stall, and the collision with trees. A factor is the dark night.NTSB MIA99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Fernandina Bch, FLThe failure of the pilot to use the printed checklist which resulted in the gear-up landing. A factor associated with the accident was the intermittent failure of the gear warning horn.