NTSB investigations: Piper PA-23, 1971
20 cases on aircraft the registry lists as Piper PA-23. 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 | 24 |
|---|---|
| 1965 | 24 |
| 1966 | 24 |
| 1967 | 21 |
| 1968 | 16 |
| 1969 | 14 |
| 1970 | 15 |
| 1971 | 20 |
| 1972 | 16 |
| 1973 | 16 |
| 1974 | 19 |
| 1975 | 8 |
| 1976 | 12 |
| 1977 | 5 |
| 1978 | 5 |
| 1979 | 11 |
| 1980 | 7 |
| 1981 | 8 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 5 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 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\") = 1971
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102302'))
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") = 1971
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102302'))
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 MIA72FKT33Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLNTSB SEA72AS020Accident · 4 fatalClosedPiper PA-23 · Grants Pass, ORNTSB MIA72RKT28Accident · Minor injuriesClosedPiper PA-23 · Nassau, Burkina FasoNTSB CHI72FEG22Accident · No injuriesClosedPiper PA-23 · Miamisburg, OHNTSB NYC72FFJ19Accident · Minor injuriesClosedPiper PA-23 · Rochester, NYNTSB MIA72FLD12Accident · No injuriesClosedPiper PA-23 · Lakeland, FLNTSB MIA72AM012Accident · 2 fatalClosedPiper PA-23 · Hillsboro, TNNTSB NYC72FIG09Accident · No injuriesClosedPiper PA-23 · Westminster, MDNTSB NYC72AN002Accident · 2 fatalClosedPiper PA-23 · Utica, NYNTSB CHI71FEK42Accident · No injuriesClosedPiper PA-23 · Mt.Vernon, OHNTSB CHI71FEM93Accident · 1 fatalClosedPiper PA-23 · Grand Rapids, MINTSB SEA71DYA33Accident · No injuriesClosedPiper PA-23 · Blackfoot, IDNTSB NYC71FNA49Accident · No injuriesClosedPiper PA-23 · Stow, MANTSB FTW71AF069Accident · 2 fatalClosedPiper PA-23 · Norman, OKNTSB SEA71DXM27Accident · Minor injuriesClosedPiper PA-23 · Carey, IDNTSB MIA71DKA10Accident · No injuriesClosedPiper PA-23 · San Juan, PRNTSB MKC71DCQ32Accident · No injuriesClosedPiper PA-23 · Healy, KSNTSB CHI71FGD42Accident · Serious injuriesClosedPiper PA-23 · Sheffield, OHNTSB MIA71AM064Accident · 2 fatalClosedPiper PA-23 · Daytona Beach, FLNTSB SEA71DXM21Accident · Minor injuriesClosedPiper PA-23 · Glenns Ferry, ID