NTSB investigations: Piper PA-23-250, 1974
32 cases on aircraft the registry lists as Piper PA-23-250. 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 | 28 |
|---|---|
| 1965 | 40 |
| 1966 | 33 |
| 1967 | 41 |
| 1968 | 25 |
| 1969 | 34 |
| 1970 | 33 |
| 1971 | 27 |
| 1972 | 30 |
| 1973 | 32 |
| 1974 | 32 |
| 1975 | 20 |
| 1976 | 27 |
| 1977 | 24 |
| 1978 | 22 |
| 1979 | 29 |
| 1980 | 26 |
| 1981 | 13 |
| 1982 | 22 |
| 1983 | 17 |
| 1984 | 13 |
| 1985 | 20 |
| 1986 | 15 |
| 1987 | 15 |
| 1988 | 18 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 15 |
| 1992 | 9 |
| 1993 | 12 |
| 1994 | 15 |
| 1995 | 17 |
| 1996 | 12 |
| 1997 | 8 |
| 1998 | 8 |
| 1999 | 6 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 12 |
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 6 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 6 |
| 2020 | 5 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 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\") = 1974
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308'))
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") = 1974
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308'))
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 FTW75AF039Accident · 2 fatalClosedPiper PA-23 · Denton, TXNTSB ANC75AA043Accident · 1 fatalClosedPiper PA-23 · Whittier, AKNTSB NYC75AN062Accident · No injuriesClosedPiper PA-23 · Philadelphia, PANTSB LAX75AL027Accident · 3 fatalClosedPiper PA-23 · Van Nuys, CANTSB LAX75AL019Accident · 4 fatalClosedPiper PA-23 · Long Beach, CANTSB NYC75AN049Accident · No injuriesClosedPiper PA-23 · Clarion, PANTSB IAD75AI023Accident · 3 fatalClosedPiper PA-23 · Bryson City, NCNTSB MKC75FER24Accident · No injuriesClosedPiper PA-23 · Hibbing, MNNTSB MIA75FKJ13Accident · No injuriesClosedPiper PA-23 · Birmingham, ALNTSB LAX75OL002Accident · No injuriesClosedPiper PA-23 · Tsuniah Lake, CanadaNTSB MKC75AK012Accident · 8 fatalClosedPiper PA-23 · Fergus Falls, MNNTSB OAK75DXQ07Accident · No injuriesClosedPiper PA-23 · Pyramid, NVNTSB FTW75FQG12Accident · No injuriesClosedPiper PA-23 · Dalhart, TXNTSB NYC75FNC06Accident · No injuriesClosedPiper PA-23 · Pittsfield, MENTSB NYC75AN001Accident · 5 fatalClosedPiper PA-23 · Acme, PANTSB ANC74AA084Accident · 1 fatalClosedPiper PA-23 · Kiana, AKNTSB NYC74IN107Incident · No injuriesClosedPiper PA-23 · Batavia, NYNTSB FTW74AF089Accident · 6 fatalClosedPiper PA-23E · Cresson, TXNTSB CHI74AC095Accident · 1 fatalClosedPiper PA-23 · Lafayette, INNTSB IAD74AI062Accident · No injuriesClosedPiper PA-23 · Cove Point, MDNTSB DEN74FQA45Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMNTSB NYC74DFA30Accident · Serious injuriesClosedPiper PA-23 · North Elba, NYNTSB NYC74FGM25Accident · No injuriesClosedPiper PA-23 · Connelsville, PANTSB NYC74AN084Accident · 4 fatalClosedPiper PA-23 · Nantucket, MANTSB SEA74FYA26Accident · Serious injuriesClosedPiper PA-23 · Burley, IDNTSB FTW74FPA18Accident · Minor injuriesClosedPiper PA-23 · Farmersville, TXNTSB NYC74FGM20Accident · No injuriesClosedPiper PA-23 · Meadville, PANTSB SEA74AS037Accident · 1 fatalClosedPiper PA-23 · Boise, IDNTSB OAK74AP042Accident · No injuriesClosedPiper PA-23 · Sutter Crk, CANTSB SEA74FYG23Accident · Serious injuriesClosedPiper PA-23 · Ritzville, WANTSB DEN74FTE57Accident · Serious injuriesClosedPiper PA-23 · Steamboat Sp, CONTSB CHI74AC057Accident · Minor injuriesClosedPiper PA-23 · Kokomo, IN