NTSB investigations, 1973, PA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1963 | 2 |
|---|---|
| 1964 | 157 |
| 1965 | 149 |
| 1966 | 172 |
| 1967 | 192 |
| 1968 | 154 |
| 1969 | 132 |
| 1970 | 136 |
| 1971 | 153 |
| 1972 | 104 |
| 1973 | 118 |
| 1974 | 143 |
| 1975 | 131 |
| 1976 | 123 |
| 1977 | 116 |
| 1978 | 124 |
| 1979 | 109 |
| 1980 | 89 |
| 1981 | 92 |
| 1982 | 96 |
| 1983 | 81 |
| 1984 | 84 |
| 1985 | 75 |
| 1986 | 64 |
| 1987 | 64 |
| 1988 | 65 |
| 1989 | 45 |
| 1990 | 65 |
| 1991 | 47 |
| 1992 | 47 |
| 1993 | 48 |
| 1994 | 41 |
| 1995 | 55 |
| 1996 | 38 |
| 1997 | 56 |
| 1998 | 40 |
| 1999 | 41 |
| 2000 | 47 |
| 2001 | 34 |
| 2002 | 35 |
| 2003 | 29 |
| 2004 | 37 |
| 2005 | 33 |
| 2006 | 36 |
| 2007 | 35 |
| 2008 | 33 |
| 2009 | 30 |
| 2010 | 19 |
| 2011 | 27 |
| 2012 | 39 |
| 2013 | 27 |
| 2014 | 24 |
| 2015 | 35 |
| 2016 | 32 |
| 2017 | 33 |
| 2018 | 28 |
| 2019 | 30 |
| 2020 | 19 |
| 2021 | 28 |
| 2022 | 35 |
| 2023 | 11 |
| 2024 | 19 |
| 2025 | 17 |
| 2026 | 12 |
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\") = 1973
AND c.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
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") = 1973 AND c."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 NYC74FHA22Accident · Minor injuriesClosedPiper PA-23 · Reading, PANTSB NYC74AN059Accident · 3 fatalClosedBeech G35 · Langhorn, PANTSB NYC74AN058Accident · 2 fatalClosedCessna 177RG · Dravosburg, PANTSB NYC74FGM12Accident · No injuriesClosedErco 415-C · West Middlesex, PANTSB NYC74AN051Accident · 2 fatalClosedBeech E18S · Corapolis, PANTSB NYC74FHA20Accident · No injuriesClosedMooney M20C · Collegeville, PANTSB NYC74DHA19Accident · No injuriesClosedPiper PA-24 · Schwenksville, PANTSB NYC74FHA17Accident · Minor injuriesClosedCessna 172 · Moscow, PANTSB NYC74AN049Accident · 1 fatalClosedPiper PA-28 · Lake Scranton, PANTSB NYC74AN048Accident · 3 fatalClosedPiper PA-28 · Donnally Mills, PANTSB NYC74FHA18Accident · No injuriesClosedMooney M20A · Lake Sheridan, PANTSB NYC74AN047Accident · 3 fatalClosedPiper PA-24 · Dupont, PANTSB NYC74AN046Accident · 1 fatalClosedBell 206A · Webster, PANTSB NYC74IN037Incident · No injuriesClosedBoeing 737 · Keating, PANTSB NYC74FGM11Accident · No injuriesClosedPiper PA-28 · Clarion, PANTSB NYC74AN035Accident · 2 fatalClosedBell 47G-5 · Waynesburg, PANTSB NYC74FHA14Accident · No injuriesClosedErco 415-D · Tunkhannock, PANTSB NYC74FGM10Accident · No injuriesClosedAero Comdr 200D · West Mifflin, PANTSB NYC74DGT13Accident · No injuriesClosedAeronca 15AC · Columbia C Rds, PANTSB NYC74DHD10Accident · Minor injuriesClosedCessna 172 · New London, PANTSB NYC74FGT12Accident · Minor injuriesClosedPiper PA-28 · York, PANTSB NYC74DHA15Accident · No injuriesClosedCessna 310 · Fleetville, PANTSB NYC74DGM09Accident · No injuriesClosedPiper PA-28 · Jeanette, PANTSB NYC74AN032Accident · 1 fatalClosedSikorsky S-55B · Nemacolin, PANTSB NYC74FHA11Accident · Serious injuriesClosedPiper PA-28R · Lehighton, PANTSB NYC74DHA12Accident · No injuriesClosedBlanik L-13 · Erwinna, PANTSB NYC74FEM08Accident · Serious injuriesClosedMooney M20 · Dubois, PANTSB NYC74DGT11Accident · No injuriesClosedErco 415-D · Hershey, PANTSB NYC74FHD09Accident · No injuriesClosedCessna 310I · Ambler, PANTSB NYC74FGT09Accident · No injuriesClosedBell 206B · Milesburg, PANTSB NYC74DGT10Accident · No injuriesClosedStinson 108-2 · East Waterford, PANTSB NYC74DGM07Accident · No injuriesClosedAeronca 7DC · Carrolltown, PANTSB NYC74AN031Accident · 2 fatalClosedPiper PA-24 · Montoursville, PANTSB NYC74DGM06Accident · No injuriesClosedPiper PA-28 · Smicksburg, PANTSB NYC74FGT08Accident · No injuriesClosedPiper PA-28R · Deer Lake, PANTSB NYC74FGT07Accident · No injuriesClosedPiper PA-40 · Lamar, PANTSB NYC74FHA09Accident · Minor injuriesClosedPiper PA-22 · Prospectville, PANTSB NYC74DGM05Accident · Serious injuriesClosedJeanies Teenie · Indiana, PANTSB NYC74FGT05Accident · Minor injuriesClosedAeronca 7AC · Gettysburg, PANTSB NYC74FHD14Accident · No injuriesClosedBeech P35 · Parker Ford, PANTSB NYC74FGM04Accident · No injuriesClosedPiper J3C-65 · Pittsfield, PANTSB NYC74FHA08Accident · 1 fatalClosedPat-Bar Spcl · Bally, PANTSB NYC74FGT04Accident · No injuriesClosedPitts Spcl · Marietta, PANTSB NYC74DGM03Accident · No injuriesClosedTaylorcraft BF1265 · Meadville, PANTSB NYC74DHA07Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PANTSB NYC74DHD11Accident · Minor injuriesClosedAmer Avco AA1-B · Bristol, PANTSB NYC74AN016Accident · 1 fatalClosedAeronca 11AC · Prospect, PANTSB NYC74FHA06Accident · No injuriesClosedBell 47D1 · Stockertown, PANTSB NYC74AN015Accident · Serious injuriesClosedBeech S35 · State College, PANTSB NYC74DGT06Accident · No injuriesClosedPiper PA-28 · Annville, PA