NTSB investigations, 1980, PA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1980
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") = 1980 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 NYC81FA017Accident · 1 fatalClosedPiper PA-32 · Philadelphia, PANTSB NYC81FGM09Accident · No injuriesClosedHiller Acft FH1100 · Somerset, PANTSB NYC81FA012Accident · 3 fatalClosedPiper PA-20 · East Berlin, PANTSB NYC81FGM07Accident · No injuriesClosedPiper PA-38 · Grove City, PANTSB NYC81FA010Accident · 1 fatalClosedBeech H18 · Troxelville, PANTSB NYC81FGM06Accident · Serious injuriesClosedCherokee RM-A-1 · Eighty Four, PANTSB NYC81FGM05Accident · No injuriesClosedCessna 172H · Clarion, PANTSB NYC81FHD08Accident · Minor injuriesClosedEnstrom F-28A · Lima, PANTSB NYC81DHA03Accident · No injuriesClosedCessna 172 · Ambler, PANTSB NYC81FGT01Accident · Minor injuriesClosedCessna 150 · Pine Grove Mls, PANTSB NYC81FGM04Accident · Serious injuriesClosedAerosport Quail · Rostraver, PANTSB NYC81FHD06Accident · Serious injuriesClosedCessna 150K · Coatsville, PANTSB NYC81FGM03Accident · No injuriesClosedLuscombe 8A · Belle Vernon, PANTSB NYC81FGM02Accident · No injuriesClosedCessna 152 · Indiana, PANTSB NYC81FHA02Accident · No injuriesClosedDornier D0-28 · Scranton, PANTSB NYC80FGM01Accident · Minor injuriesClosedCessna 177 · Jeannette, PANTSB NYC80FGM33Accident · Minor injuriesClosedCessna T210F · Economy Boro, PANTSB NYC80FA091Accident · No injuriesClosedBell 47G-4A · Holbrook, PANTSB NYC80DHA32Accident · No injuriesClosedBellanca 17-30 · Pottstown, PANTSB NYC80FA089Accident · 3 fatalClosedPiper PA-22 · Hyner, PANTSB NYC80IA086Incident · No injuriesClosedNord 262 · Philadelphia, PANTSB NYC80FA088Accident · No injuriesClosedPiper PA-28 · Montgomeryvill, PANTSB NYC80FGM32Accident · No injuriesClosedSchleicher ASW-19 · Tyronne, PANTSB NYC80FGM31Accident · No injuriesClosedPiper PA-28R · Monroeville, PANTSB NYC80FGT21Accident · 1 fatalClosedBensen B-8M · Columbia, PANTSB NYC80DHA31Accident · No injuriesClosedCessna A185E · Pottstown, PANTSB NYC80FGM28Accident · Minor injuriesClosedFunk B75L · Slippery Rock, PANTSB NYC80;GM29Accident · No injuriesClosedBLN Works FF-7 · Indiana, PANTSB NYC80FGT20Accident · Serious injuriesClosedSchreder HP-11A · Julian, PANTSB NYC80FHA30Accident · Serious injuriesClosedBoeing B75N1 · Erwinna, PANTSB NYC80FGT19Accident · No injuriesClosedHughes 269C · Renova, PANTSB NYC80FGM27Accident · Minor injuriesClosedPiper PA-31 · Windber, PANTSB NYC80FHA28Accident · Minor injuriesClosedCessna 172 · Perkasia, PANTSB NYC80FHD24Accident · Serious injuriesClosedCessna 177B · Ambler, PANTSB NYC80FGM26Accident · No injuriesClosedCessna 152 · Connellsville, PANTSB NYC80FHA26Accident · No injuriesClosedCessna 150L · Collegeville, PANTSB NYC80DA062Accident · No injuriesClosedCessna 172 · Mifflintown, PANTSB DCA80AA022Accident · 3 fatalClosedPiper PA-31 · Philadelphia, PANTSB NYC80IA057Incident · No injuriesClosedBritish AC 1-11 · Pittsburgh, PANTSB NYC80FGT16Accident · No injuriesClosedBell 47G · Gettysburg, PANTSB NYC80DHA24Accident · Minor injuriesClosedSchleicher ASW-19 · Franklin Forks, PANTSB NYC80FGM25Accident · No injuriesClosedCessna 210 · Waynesburg, PANTSB NYC80FA051Accident · 3 fatalClosedPiper PA-28 · Clearfield, PANTSB NYC80FGT15Accident · No injuriesClosedMooney M20C · Mt Union, PANTSB NYC80FHA20Accident · No injuriesClosedPiper PA-22 · Hallstead, PANTSB NYC80FHA19Accident · Serious injuriesClosedMitchell U-2 · Doylestown, PANTSB NYC80FHA18Accident · 2 fatalClosedThorp T-18 · Quakertown, PANTSB NYC80FGT14Accident · No injuriesClosedDehavilland DHC-2 · Chambersburg, PANTSB NYC80DHA17Accident · No injuriesClosedPiper PA-28 · Clifford, PANTSB NYC80FA046Accident · 1 fatalClosedLuscombe 8A · Fairview, PA