NTSB investigations: Piper PA-23-160, 1966
21 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\") = 1966
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") = 1966
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 FTW67F0393Accident · No injuriesClosedPiper PA-23 · Austin, TXNTSB NYC67F0441Accident · No injuriesClosedPiper PA-23 · Waterford, CTNTSB CHI67F0406Accident · No injuriesClosedPiper PA-23 · Middlebury, INNTSB CHI67D0390Accident · No injuriesClosedPiper PA-23 · Gladwin, MINTSB NYC67A0070Accident · No injuriesClosedPiper PA-23 · Trenton, NJNTSB SEA67A0023Accident · 3 fatalClosedPiper PA-23 · Stanley, IDNTSB CHI67F0267Accident · No injuriesClosedBeech E18S · Fremont, OHNTSB OAK67D0260Accident · No injuriesClosedPiper PA-23 · San Carlos, CANTSB MIA67A0020Accident · No injuriesClosedPiper PA-23 · Odessa, FLNTSB NYC67A0021Accident · No injuriesClosedPiper PA-23 · Red Bank, NJNTSB MIA67F0189Accident · No injuriesClosedPiper PA-28 · Jacksonville, FLNTSB OAK67A0005Accident · 1 fatalClosedPiper PA-23 · San Jose, CANTSB MIA67F0082Accident · No injuriesClosedPiper PA-23 · St Augustine, FLNTSB CHI67F0049Accident · No injuriesClosedPiper PA-23 · Orleans, INNTSB FTW67F0017Accident · No injuriesClosedPiper PA23 · Lafayette, LANTSB FTW66F0647Accident · No injuriesClosedPiper PA-23 · Houston, TXNTSB MKC66A0055Accident · 1 fatalClosedPiper PA-23 · Winchester, ARNTSB MKC66F0538Accident · No injuriesClosedPiper PA-23 · Iowa City, IANTSB CHI66F0644Accident · No injuriesClosedPiper PA-23 · Elgin, ILNTSB NYC66F0484Accident · No injuriesClosedPiper PA-23 · Somerville, NJNTSB MKC66F0392Accident · No injuriesClosedPiper PA-23 · Garner, IA