NTSB investigations: Piper PA-23-160, 1965
20 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\") = 1965
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") = 1965
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 NYC66F0402Accident · No injuriesClosedPiper PA-23 · Leesburg, VANTSB NYC66F0361Accident · Serious injuriesClosedPiper PA-23 · Mt.Holly, NJNTSB NYC66F0349Accident · No injuriesClosedPiper PA-23 · Old Town, MENTSB MIA66S0002Accident · Minor injuriesClosedPiper PA-23 · Punta Caucedo, DRNTSB MIA66F0363Accident · No injuriesClosedPiper PA-23 · Mobile, ALNTSB MKC66D0237Accident · No injuriesClosedPiper PA-23 · Iowa Falls, IANTSB MIA66F0204Accident · No injuriesClosedPiper PA-23 · Memphis, TNNTSB MKC66F0195Accident · No injuriesClosedPiper PA-23 · Wallace, NENTSB MIA66F0216Accident · No injuriesClosedPiper PA-23 · Mobile, ALNTSB LAX66D0118Accident · No injuriesClosedPiper PA-23 · Thousand Oaks, CANTSB FTW66F0102Accident · No injuriesClosedPiper PA-23 · Liberty, TXNTSB MKC66F0073Accident · No injuriesClosedPiper PA-23 · Des Moines, IANTSB CHI66D0050Accident · No injuriesClosedPiper PA-23 · Cleveland, OHNTSB NYC66F0021Accident · Minor injuriesClosedPiper PA-23 · Perry, NYNTSB FTW66F0027Accident · No injuriesClosedPiper PA-23 · Little Rock, ARNTSB LAX65F0072Accident · Minor injuriesClosedPiper PA-23 · Fullerton, CANTSB FTW65A0090Accident · 4 fatalClosedPiper PA-23 · Tomball, TXNTSB NYC65F0037Accident · No injuriesClosedPiper PA23 · Red Bank, NJNTSB LAX66F0066Accident · Minor injuriesClosedPiper PA-23 · Lucerne Valy, CANTSB UNK65X1237Accident · No injuriesClosedPiper PA23 · Galion, OH