NTSB investigations, 1981, 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\") = 1981
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") = 1981 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 NYC82FGT07Accident · No injuriesClosedAeronca 7AC · Wellsboro, PANTSB NYC82DA013Accident · No injuriesClosedAeronca 7AC · Wellsboro, PANTSB NYC82FGM08Accident · No injuriesClosedHummer A · Butler, PANTSB NYC82DHA05Accident · No injuriesClosedMooney M20K · Kutztown, PANTSB NYC82FGT06Accident · No injuriesClosedStinson 108 · Brogue, PANTSB NYC82FGM07Accident · No injuriesClosedCessna 340 · West Mifflin, PANTSB NYC82FGT05Accident · No injuriesClosedPiper PA-24 · Montoursville, PANTSB NYC82FA011Accident · 4 fatalClosedCessna 150G · Osgood, PANTSB NYC82FGM06Accident · No injuriesClosedCessna 140 · Newry, PANTSB NYC82FA009Accident · 4 fatalClosedPiper PA-32 · Mount Pocono, PANTSB NYC82FGM05Accident · No injuriesClosedCessna 150G · West Middlesex, PANTSB NYC82FGM04Accident · No injuriesClosedCessna 150 · Wattsburg, PANTSB NYC82FGT04Accident · 1 fatalClosedCarver HP-14B · Altoona, PANTSB NYC82DHA06Accident · Minor injuriesClosedSchweizer SGS2 · Kutztown, PANTSB NYC82FGM03Accident · No injuriesClosedBellanca 17-30A · Seven Springs, PANTSB NYC82FGT03Accident · No injuriesClosedCessna 182A · Chambersburg, PANTSB NYC81FGM02Accident · Serious injuriesClosedCessna 150J · Dubois, PANTSB NYC82FGT02Accident · No injuriesClosedCessna 150K · Pottsville, PANTSB NYC82FGT01Accident · Serious injuriesClosedAeronca 7BCM · York, PANTSB NYC81DHA24Accident · No injuriesClosedVeriviggen 1 · Reading, PANTSB NYC81FHA25Accident · Serious injuriesClosedCessna 310 · Doylestown, PANTSB NYC81FGT13Accident · No injuriesClosedAmer Avco AA-1B · Marietta, PANTSB NYC81FGM32Accident · No injuriesClosedCessna 310P · Pittsburgh, PANTSB NYC81DHD39Accident · Minor injuriesClosedPiper J-3C · Coatesville, PANTSB NYC81FGT12Accident · 1 fatalClosedChampion 7KCAB · Towanda, PANTSB NYC81FGM31Accident · No injuriesClosedCessna 150J · Belle Vernon, PANTSB NYC81FGM30Accident · Minor injuriesClosedBell 47G-2A · Hollidaysburg, PANTSB NYC81FGM29Accident · Minor injuriesClosedBell 47G-2A · Garland, PANTSB NYC81FGT11Accident · Minor injuriesClosedCessna 172F · Loyalsockville, PANTSB NYC81FA080Accident · 1 fatalClosedPiper PA-23 · Union Township, PANTSB NYC81FGM28Accident · No injuriesClosedCessna 150 · Belle Vernon, PANTSB NYC81FGM27Accident · Serious injuriesClosedCessna 180 · Rockwood, PANTSB NYC81FGM26Accident · No injuriesClosedPiper J3C-65 · Mt Pleasant, PANTSB NYC81FGT10Accident · No injuriesClosedBrantly B-2B · New Cumberland, PANTSB NYC81FGM25Accident · Minor injuriesClosedBeech 23 · Irwin, PANTSB NYC81FA076Accident · Minor injuriesClosedRobinson R22 · Summit Twp, PANTSB NYC81DHD38Accident · No injuriesClosedPitts S-1C · Russelville, PANTSB NYC81FHA20Accident · Minor injuriesClosedCessna 210A · Doylestown, PANTSB NYC81FGM24Accident · Serious injuriesClosedCessna 182J · Butler, PANTSB NYC81FHA19Accident · Minor injuriesClosedCessna 170 · Uniondale, PANTSB NYC81DHA18Accident · No injuriesClosedPiper PA-38 · Easton, PANTSB NYC81FGT09Accident · Minor injuriesClosedCessna 172P · Brogue, PANTSB NYC81DHA17Accident · Minor injuriesClosedAeronca 7AC · Springfield, PANTSB NYC81FGM23Accident · No injuriesClosedPiper PA-28 · Baggaley, PANTSB NYC81FGT08Accident · Serious injuriesClosedTaylorcraft BC12-D · Hanover, PANTSB NYC81FGT07Accident · Minor injuriesClosedCessna 150 · Columbia, PANTSB NYC81FA072Accident · 2 fatalClosedChampion 7ECA · West Middlesex, PANTSB NYC81DHA16Accident · No injuriesClosedVariviggen BWR-1 · Reading, PANTSB NYC81FGM22Accident · No injuriesClosedCessna 177B · West Mifflin, PANTSB NYC81FA070Accident · 6 fatalClosedPiper PA-32 · Easton, PA