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

19632026
NTSB investigations, 1981, PA per year, 1963–2026: 4,232 cases
19632
1964157
1965149
1966172
1967192
1968154
1969132
1970136
1971153
1972104
1973118
1974143
1975131
1976123
1977116
1978124
1979109
198089
198192
198296
198381
198484
198575
198664
198764
198865
198945
199065
199147
199247
199348
199441
199555
199638
199756
199840
199941
200047
200134
200235
200329
200437
200533
200636
200735
200833
200930
201019
201127
201239
201327
201424
201535
201632
201733
201828
201930
202019
202128
202235
202311
202419
202517
202612

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.

NTSB NYC82FGT07Accident · No injuriesClosedAeronca 7AC · Wellsboro, PADec 31, 1981 · N83073 · Substantial damageNTSB NYC82DA013Accident · No injuriesClosedAeronca 7AC · Wellsboro, PADec 31, 1981 · N83073 · Substantial damageNTSB NYC82FGM08Accident · No injuriesClosedHummer A · Butler, PADec 26, 1981 · N8537Z · Substantial damageNTSB NYC82DHA05Accident · No injuriesClosedMooney M20K · Kutztown, PADec 13, 1981 · N231RK · 2 aircraft · Minor damageNTSB NYC82FGT06Accident · No injuriesClosedStinson 108 · Brogue, PADec 12, 1981 · N97206 · Substantial damageNTSB NYC82FGM07Accident · No injuriesClosedCessna 340 · West Mifflin, PADec 11, 1981 · N7632Q · Substantial damageNTSB NYC82FGT05Accident · No injuriesClosedPiper PA-24 · Montoursville, PANov 27, 1981 · N7521P · Substantial damageNTSB NYC82FA011Accident · 4 fatalClosedCessna 150G · Osgood, PANov 25, 1981 · N8521J · 2 aircraft · DestroyedNTSB NYC82FGM06Accident · No injuriesClosedCessna 140 · Newry, PANov 18, 1981 · N2008N · DestroyedNTSB NYC82FA009Accident · 4 fatalClosedPiper PA-32 · Mount Pocono, PANov 15, 1981 · N178RB · DestroyedNTSB NYC82FGM05Accident · No injuriesClosedCessna 150G · West Middlesex, PANov 14, 1981 · N8305J · Substantial damageNTSB NYC82FGM04Accident · No injuriesClosedCessna 150 · Wattsburg, PANov 8, 1981 · N1945Z · Substantial damageNTSB NYC82FGT04Accident · 1 fatalClosedCarver HP-14B · Altoona, PANov 7, 1981 · N3320X · DestroyedNTSB NYC82DHA06Accident · Minor injuriesClosedSchweizer SGS2 · Kutztown, PAOct 24, 1981 · N2979H · Substantial damageNTSB NYC82FGM03Accident · No injuriesClosedBellanca 17-30A · Seven Springs, PAOct 15, 1981 · N93647 · DestroyedNTSB NYC82FGT03Accident · No injuriesClosedCessna 182A · Chambersburg, PAOct 11, 1981 · N4724D · Substantial damageNTSB NYC81FGM02Accident · Serious injuriesClosedCessna 150J · Dubois, PAOct 6, 1981 · N50552 · Substantial damageNTSB NYC82FGT02Accident · No injuriesClosedCessna 150K · Pottsville, PAOct 5, 1981 · N6385G · Substantial damageNTSB NYC82FGT01Accident · Serious injuriesClosedAeronca 7BCM · York, PAOct 4, 1981 · N9329H · DestroyedNTSB NYC81DHA24Accident · No injuriesClosedVeriviggen 1 · Reading, PASep 30, 1981 · N277LN · Substantial damageNTSB NYC81FHA25Accident · Serious injuriesClosedCessna 310 · Doylestown, PASep 29, 1981 · N4125Q · Substantial damageNTSB NYC81FGT13Accident · No injuriesClosedAmer Avco AA-1B · Marietta, PASep 21, 1981 · N8969L · Substantial damageNTSB NYC81FGM32Accident · No injuriesClosedCessna 310P · Pittsburgh, PASep 20, 1981 · CF-KBC · Substantial damageNTSB NYC81DHD39Accident · Minor injuriesClosedPiper J-3C · Coatesville, PASep 20, 1981 · N6925H · DestroyedNTSB NYC81FGT12Accident · 1 fatalClosedChampion 7KCAB · Towanda, PASep 19, 1981 · N7541F · DestroyedNTSB NYC81FGM31Accident · No injuriesClosedCessna 150J · Belle Vernon, PASep 13, 1981 · N60365 · Substantial damageNTSB NYC81FGM30Accident · Minor injuriesClosedBell 47G-2A · Hollidaysburg, PASep 7, 1981 · N7764 · DestroyedNTSB NYC81FGM29Accident · Minor injuriesClosedBell 47G-2A · Garland, PASep 6, 1981 · N72501 · DestroyedNTSB NYC81FGT11Accident · Minor injuriesClosedCessna 172F · Loyalsockville, PASep 5, 1981 · N8766U · DestroyedNTSB NYC81FA080Accident · 1 fatalClosedPiper PA-23 · Union Township, PASep 3, 1981 · N62789 · DestroyedNTSB NYC81FGM28Accident · No injuriesClosedCessna 150 · Belle Vernon, PAAug 29, 1981 · N6451G · Substantial damageNTSB NYC81FGM27Accident · Serious injuriesClosedCessna 180 · Rockwood, PAAug 29, 1981 · N2809A · DestroyedNTSB NYC81FGM26Accident · No injuriesClosedPiper J3C-65 · Mt Pleasant, PAAug 20, 1981 · N98472 · Substantial damageNTSB NYC81FGT10Accident · No injuriesClosedBrantly B-2B · New Cumberland, PAAug 19, 1981 · N2277U · Substantial damageNTSB NYC81FGM25Accident · Minor injuriesClosedBeech 23 · Irwin, PAAug 17, 1981 · N2358J · Substantial damageNTSB NYC81FA076Accident · Minor injuriesClosedRobinson R22 · Summit Twp, PAJul 29, 1981 · N9079M · Substantial damageNTSB NYC81DHD38Accident · No injuriesClosedPitts S-1C · Russelville, PAJul 29, 1981 · N18UN · Substantial damageNTSB NYC81FHA20Accident · Minor injuriesClosedCessna 210A · Doylestown, PAJul 26, 1981 · N1437J · Substantial damageNTSB NYC81FGM24Accident · Serious injuriesClosedCessna 182J · Butler, PAJul 25, 1981 · N2902F · Substantial damageNTSB NYC81FHA19Accident · Minor injuriesClosedCessna 170 · Uniondale, PAJul 19, 1981 · N1400D · Substantial damageNTSB NYC81DHA18Accident · No injuriesClosedPiper PA-38 · Easton, PAJul 16, 1981 · N2482A · Substantial damageNTSB NYC81FGT09Accident · Minor injuriesClosedCessna 172P · Brogue, PAJul 14, 1981 · N51357 · Substantial damageNTSB NYC81DHA17Accident · Minor injuriesClosedAeronca 7AC · Springfield, PAJul 14, 1981 · N82773 · Substantial damageNTSB NYC81FGM23Accident · No injuriesClosedPiper PA-28 · Baggaley, PAJul 13, 1981 · N6635W · Substantial damageNTSB NYC81FGT08Accident · Serious injuriesClosedTaylorcraft BC12-D · Hanover, PAJul 10, 1981 · N39222 · Substantial damageNTSB NYC81FGT07Accident · Minor injuriesClosedCessna 150 · Columbia, PAJul 8, 1981 · N76CA · DestroyedNTSB NYC81FA072Accident · 2 fatalClosedChampion 7ECA · West Middlesex, PAJul 6, 1981 · N9001L · DestroyedNTSB NYC81DHA16Accident · No injuriesClosedVariviggen BWR-1 · Reading, PAJul 3, 1981 · N277LN · Substantial damageNTSB NYC81FGM22Accident · No injuriesClosedCessna 177B · West Mifflin, PAJul 2, 1981 · N35241 · Substantial damageNTSB NYC81FA070Accident · 6 fatalClosedPiper PA-32 · Easton, PAJul 1, 1981 · N54383 · Destroyed