NTSB investigations: Piper PA-32-300, 1970
24 cases on aircraft the registry lists as Piper PA-32-300. 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
| 1967 | 13 |
|---|---|
| 1968 | 13 |
| 1969 | 15 |
| 1970 | 24 |
| 1971 | 23 |
| 1972 | 22 |
| 1973 | 22 |
| 1974 | 29 |
| 1975 | 31 |
| 1976 | 29 |
| 1977 | 23 |
| 1978 | 34 |
| 1979 | 23 |
| 1980 | 28 |
| 1981 | 17 |
| 1982 | 20 |
| 1983 | 15 |
| 1984 | 11 |
| 1985 | 23 |
| 1986 | 10 |
| 1987 | 12 |
| 1988 | 19 |
| 1989 | 25 |
| 1990 | 8 |
| 1991 | 12 |
| 1992 | 13 |
| 1993 | 17 |
| 1994 | 11 |
| 1995 | 10 |
| 1996 | 10 |
| 1997 | 13 |
| 1998 | 11 |
| 1999 | 10 |
| 2000 | 12 |
| 2001 | 12 |
| 2002 | 11 |
| 2003 | 10 |
| 2004 | 5 |
| 2005 | 9 |
| 2006 | 9 |
| 2007 | 5 |
| 2008 | 6 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 7 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 11 |
| 2019 | 4 |
| 2020 | 7 |
| 2021 | 2 |
| 2022 | 12 |
| 2023 | 8 |
| 2024 | 9 |
| 2025 | 3 |
| 2026 | 3 |
Where
Latest 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\") = 1970
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103212'))
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") = 1970
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103212'))
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 ANC71AA033Accident · No injuriesClosedPiper PA-32 · Chignik, AKNTSB FTW71DRG54Accident · No injuriesClosedPiper PA-32 · Mountain Home, TXNTSB IAD71DHD31Accident · No injuriesClosedPiper J5A · Smyrna, DENTSB CHI71FBM10Accident · Minor injuriesClosedPiper PA-32 · South Bend, INNTSB CHI71DBA20Accident · No injuriesClosedPiper PA-32 · Indianapolis, INNTSB OAK71FVW17Accident · No injuriesClosedPiper PA-32 · Pahrump, NVNTSB MKC71AK025Accident · 2 fatalClosedPiper PA-32 · Shakopee, MNNTSB OAK71AP021Accident · No injuriesClosedPiper PA-32 · San Francisco, CANTSB FTW71DRG33Accident · No injuriesClosedPiper PA-32 · Pericos, MexicoNTSB CHI71FBJ27Accident · No injuriesClosedPiper PA-32 · Lansing, MINTSB LAX71FUA12Accident · No injuriesClosedPiper PA-32 · Sj Capstrno, CANTSB LAX71DVA26Accident · No injuriesClosedPiper PA-32 · Caborca, MexicoNTSB SEA70DDG15Accident · No injuriesClosedPiper PA-32 · Three Forks, MTNTSB CHI70IC089Incident · No injuriesClosedPiper PA-32 · Columbus, OHNTSB ANC70AA093Accident · No injuriesClosedPiper PA-32 · Peterson Pt, AKNTSB SEA70DVQ09Accident · No injuriesClosedPiper PA-32 · Mckenzie Br., ORNTSB OAK70DVG23Accident · No injuriesClosedPiper PA-32 · Calistoga, CANTSB DEN70FXT08Accident · No injuriesClosedPiper PA-32 · Woods Cross, UTNTSB OAK70DVA11Accident · No injuriesClosedPiper PA-32 · Turlock, CANTSB LAX70AL061Accident · 6 fatalClosedPiper PA-32 · Colrado Cty, AZNTSB DEN70DXD17Accident · No injuriesClosedPiper PA-32 · Akron, CONTSB LAX70AL058Accident · 5 fatalClosedPiper PA-32 · Pima, AZNTSB LAX70DUJ08Accident · No injuriesClosedPiper PA-32 · Pima, AZNTSB MKC70FCJ04Accident · No injuriesClosedPiper PA-32 · Oneill, NE