NTSB investigations: Piper PA-23, 1967
21 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\") = 1967
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") = 1967
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 NYC68D0326Accident · Minor injuriesClosedPiper PA-23 · Sea Side Heght, NJNTSB OAK68A0048Accident · 1 fatalClosedPiper PA-23 · Reno, NVNTSB UNK68X0104Accident · Serious injuriesClosedPiper PA-23 · Shingle Pt, CanadaNTSB LAX68F0152Accident · Minor injuriesClosedPiper PA-23 · Tehachapi, CANTSB LAX68A0019Accident · 2 fatalClosedPiper PA-23 · Yucaipa, CANTSB NYC68F0094Accident · Serious injuriesClosedPiper PA-23 · Middletown, NJNTSB SEA67D0345Accident · No injuriesClosedPiper PA-23 · Salem, ORNTSB OAK68D0009Accident · No injuriesClosedPiper PA-23 · Oakland, CANTSB SEA68F0049Accident · Serious injuriesClosedPiper PA-23 · Hoquiam, WANTSB LAX67D0369Accident · No injuriesClosedPiper PA-23 · San Diego, CANTSB CHI67F0602Accident · No injuriesClosedPiper PA-23 · Gahanna, OHNTSB LAX67D0343Accident · No injuriesClosedPiper PA-23 · Oceanside, CANTSB SEA67D0301Accident · No injuriesClosedPiper PA-23 · Alderwood Mr, WANTSB FTW67F0507Accident · No injuriesClosedPiper PA-23 · Okla.City, OKNTSB CHI67F0606Accident · Serious injuriesClosedPiper PA-23 · Alsip, ILNTSB CHI68F0475Accident · No injuriesClosedPiper PA-23 · Cobden, ILNTSB FTW67D0629Accident · No injuriesClosedPiper PA-23 · Pitiquito, MexicoNTSB OAK67A0062Accident · 2 fatalClosedPiper PA-23 · Oakland, CANTSB MIA67F0467Accident · No injuriesClosedPiper PA-23 · Cayce, SCNTSB MIA67A0083Accident · 1 fatalClosedPiper PA-23 · Flagler Beach, FLNTSB LAX67D0259Accident · No injuriesClosedPiper PA-23 · Ontario, CA