NTSB investigations: Piper PA-32-300, 1971
23 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\") = 1971
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") = 1971
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 ANC72AA032Accident · Minor injuriesClosedPiper PA-32 · Galena, AKNTSB MKC72AK036Accident · No injuriesClosedPiper PA-32 · Topeka, KSNTSB MIA72DKJ38Accident · No injuriesClosedPiper PA-32 · Atlantic Ocean (Atlantic Ocean)NTSB FTW72AF030Accident · 7 fatalClosedPiper PA-32 · Wells, TXNTSB MKC72DCD47Accident · No injuriesClosedPiper PA-32 · Dubuque, IANTSB MKC72DCD45Accident · No injuriesClosedPiper PA-32 · Ida Grove, IANTSB LAX72AL032Accident · No injuriesClosedPiper PA-32 · Ventura, CANTSB NYC72FID16Accident · No injuriesClosedPiper PA-32 · Lynchburg, VANTSB SEA72FYG18Accident · Serious injuriesClosedPiper PA-32 · College Pl, WANTSB MKC72DCD38Accident · No injuriesClosedPiper PA-32 · Marshalltown, IANTSB CHI72DEA16Accident · No injuriesClosedPiper PA-32 · Anderson, INNTSB LAX72FUG25Accident · No injuriesClosedPiper PA-32 · Rialto, CANTSB NYC72AN052Accident · No injuriesClosedPiper PA-32 · Fitchburg, MANTSB CHI72AC022Accident · 2 fatalClosedPiper PA-32 · Minford, OHNTSB LAX72FUJ40Accident · Minor injuriesClosedPiper PA-32 · Nogales, AZNTSB MKC72AK012Accident · 1 fatalClosedPiper PA-32 · Andover, SDNTSB MKC72DCQ12Accident · No injuriesClosedPiper PA-32 · Emporia, KSNTSB SEA71AS047Accident · 5 fatalClosedPiper PA-32 · Meacham, ORNTSB FTW71DQD23Accident · No injuriesClosedPiper PA-32 · Dell City, TXNTSB MKC71FCJ63Accident · No injuriesClosedPiper PA-32 · Bloomfield, NENTSB DEN71FXT23Accident · No injuriesClosedPiper PA-32 · Provo, UTNTSB MKC71FCD56Accident · No injuriesClosedPiper PA-32 · Grimes, IANTSB SEA71AS032Accident · No injuriesClosedPiper PA-32 · Orofino, ID