NTSB investigations: Piper PA-23-250, 1992
9 cases on aircraft the registry lists as Piper PA-23-250. 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 | 28 |
|---|---|
| 1965 | 40 |
| 1966 | 33 |
| 1967 | 41 |
| 1968 | 25 |
| 1969 | 34 |
| 1970 | 33 |
| 1971 | 27 |
| 1972 | 30 |
| 1973 | 32 |
| 1974 | 32 |
| 1975 | 20 |
| 1976 | 27 |
| 1977 | 24 |
| 1978 | 22 |
| 1979 | 29 |
| 1980 | 26 |
| 1981 | 13 |
| 1982 | 22 |
| 1983 | 17 |
| 1984 | 13 |
| 1985 | 20 |
| 1986 | 15 |
| 1987 | 15 |
| 1988 | 18 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 15 |
| 1992 | 9 |
| 1993 | 12 |
| 1994 | 15 |
| 1995 | 17 |
| 1996 | 12 |
| 1997 | 8 |
| 1998 | 8 |
| 1999 | 6 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 12 |
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 6 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 6 |
| 2020 | 5 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 2 |
| 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\") = 1992
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308'))
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") = 1992
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308'))
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 ATL93FA041Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Atlanta, GAThe pilot's failure to maintain clearance from approach lights while conducting a night landing. A factor was a dark night.NTSB MIA92WA192Accident · No injuriesForeign investigationPiper PA-23-250 · Mores Island, BahamasNTSB MIA92LA143Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · St. ThomasIn-flight fire for undetermined reasons, and in-flight collision with the water.NTSB MIA92WA140Accident · Minor injuriesForeign investigationPiper PA-23-250 · Rock Sound, BahamasNTSB CHI92IA141Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Valentine, NEThe failure of the pilot in command to extend the landing gear and the inattentive FAA inspector (check airman). Associated factors are the inoperative landing gear warning system, the inadequate preflight inspection by the pilot and FAA inspector, and the…NTSB MIA92WA116Accident · 1 fatalForeign investigationPiper PA-23-250 · Marsh Harbour, BahamasNTSB NYC92FA079Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Hamburg, PAThe pilot's improper in-flight decision, his failure to follow proper IFR procedures, and an improperly planned approach, which resulted in an inflight collision with rising terrain during the execution of the missed approach procedure. Factors related to the…NTSB FTW92LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Denver, COThe loss of hydraulic fluid due to a ruptured hydraulic line in the landing gear system.NTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.