NTSB investigations: Piper PA-23-160, 1968
17 cases on aircraft the registry lists as Piper PA-23-160. 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 | 18 |
|---|---|
| 1965 | 20 |
| 1966 | 21 |
| 1967 | 22 |
| 1968 | 17 |
| 1969 | 17 |
| 1970 | 10 |
| 1971 | 10 |
| 1972 | 7 |
| 1973 | 5 |
| 1974 | 8 |
| 1975 | 7 |
| 1976 | 8 |
| 1977 | 6 |
| 1978 | 8 |
| 1979 | 9 |
| 1980 | 4 |
| 1981 | 5 |
| 1982 | 2 |
| 1983 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 4 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 1 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 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\") = 1968
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102304'))
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") = 1968
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102304'))
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 MKC69F0326Accident · No injuriesClosedPiper PA-23 · Creston, IANTSB NYC69A0063Accident · No injuriesClosedPiper PA-23 · Jfk Airport, NYNTSB MIA69A0027Accident · 1 fatalClosedPiper PA-23 · Chatsworth, GANTSB NYC69F0302Accident · No injuriesClosedPiper PA-23 · Agawam, MANTSB MIA69F0174Accident · Serious injuriesClosedPiper PA-23 · Montgomery, ALNTSB CHI69F0221Accident · No injuriesClosedPiper PA-23 · Wheeling, ILNTSB CHI69F0063Accident · No injuriesClosedPiper PA-23 · Indianapolis, INNTSB CHI68A0095Accident · 4 fatalClosedPiper PA-23 · Pellston, MINTSB DIA68D0232Accident · No injuriesClosedPiper PA-23 · Chantilly, VANTSB MKC68F0559Accident · Serious injuriesClosedPiper PA-23 · Thornton, IANTSB LAX68F0401Accident · No injuriesClosedPiper PA-23 · Long Beach, CANTSB OAK68D0352Accident · No injuriesClosedPiper PA-23 · San Carlos, CANTSB NYC68D0379Accident · Minor injuriesClosedPiper PA-23 · Canandaigua, NYNTSB NYC68D0381Accident · No injuriesClosedPiper PA-23 · Agawam, MANTSB CHI68F0601Accident · No injuriesClosedPiper PA-23 · Northbrook, ILNTSB DEN68F0199Accident · No injuriesClosedCessna 150F · Las Cruces, NMNTSB CHI68F0576Accident · No injuriesClosedPiper PA-23 · Columbus, OH