NTSB investigations: Piper PA-16, 1965
18 cases on aircraft the registry lists as Piper PA-16. 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 | 18 |
| 1966 | 12 |
| 1967 | 11 |
| 1968 | 12 |
| 1969 | 9 |
| 1970 | 13 |
| 1971 | 10 |
| 1972 | 3 |
| 1973 | 6 |
| 1974 | 6 |
| 1975 | 6 |
| 1976 | 5 |
| 1977 | 5 |
| 1978 | 4 |
| 1979 | 4 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 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 ('7101602'))
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 ('7101602'))
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 LAX66D0190Accident · No injuriesClosedPiper PA-16 · Compton, CANTSB NYC66D0419Accident · Minor injuriesClosedPiper PA-16 · Spencer, WVNTSB OAK66D0173Accident · No injuriesClosedPiper PA-16 · Palo Alto, CANTSB CHI66F0399Accident · Minor injuriesClosedPiper PA-16 · Ladoga, INNTSB CHI66F0380Accident · No injuriesClosedPiper PA-16 · Blissfield, MINTSB DEN66F0115Accident · No injuriesClosedPiper PA-16 · Carlsbad, NMNTSB SEA66F0125Accident · No injuriesClosedPiper PA-16 · Salem, ORNTSB MKC66F0147Accident · No injuriesClosedPiper PA-16 · Max, NDNTSB MKC66D0135Accident · Minor injuriesClosedPiper PA-16 · Jadwin, MONTSB CHI66A0002Accident · 1 fatalClosedPiper PA-16 · Lake Delton, WINTSB SEA65F0070Accident · Serious injuriesClosedPiper PA16 · Owyheereservo, ORNTSB FTW65F0028Accident · No injuriesClosedPiper PA-16 · Monroe, LANTSB MKC66F0035Accident · No injuriesClosedPiper PA-16 · Edina, MONTSB ANC65D0001Accident · No injuriesClosedPiper PA-16 · Nenana, AKNTSB MKC65F0054Accident · No injuriesClosedPiper PA-16 · Centerville, IANTSB NYC65F0019Accident · No injuriesClosedPiper PA-16 · Deer Park, NYNTSB DEN65D0018Accident · No injuriesClosedPiper PA16 · Yuma, AZNTSB UNK65X1210Accident · No injuriesClosedPiper PA16 · Woodstown, NJ