NTSB investigations, 1981, PA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first

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 NYC81DA069Accident · Serious injuriesClosedBritish AC 1-11 · Pittsburgh, PAJun 30, 1981 · N1127J · No damageNTSB NYC81FGT06Accident · No injuriesClosedBell 47G · Shrewsbury, PAJun 29, 1981 · N902Z · DestroyedNTSB NYC81FGM21Accident · No injuriesClosedPiper PA-28 · Breezewood, PAJun 27, 1981 · N4221J · Substantial damageNTSB NYC81FHD29Accident · No injuriesClosedCessna 152 · Philadelphia, PAJun 26, 1981 · N4910B · Substantial damageNTSB NYC81FA067Accident · No injuriesClosedCessna 210 · Philadelphia, PAJun 25, 1981 · N4805K · Minor damageNTSB NYC81IA061Incident · Minor injuriesClosedShort Bros SD3-30 · Wilkes Barre, PAJun 22, 1981 · N304CA · Minor damageNTSB NYC81FA056Accident · No injuriesClosedBeech G18S · New Cumberland, PAJun 12, 1981 · N547DA · Substantial damageNTSB NYC81IA057Incident · No injuriesClosedShorts SD3-30 · Middletown, PAJun 11, 1981 · N331CA · No damageNTSB NYC81FGT05Accident · No injuriesClosedPiper PA-28 · Annville, PAJun 10, 1981 · N33743 · Substantial damageNTSB NYC81FGM20Accident · Minor injuriesClosedBensen B8M · Greenville, PAJun 7, 1981 · N8496T · Substantial damageNTSB NYC81DHA14Accident · No injuriesClosedCessna 150H · Tobyhanna, PAJun 5, 1981 · N22578 · Substantial damageNTSB NYC81FGT03Accident · Minor injuriesClosedCessna 172 · Palmyra, PAMay 31, 1981 · N8422X · Substantial damageNTSB NYC81DHA13Accident · No injuriesClosedPiper PA-32 · Factoryville, PAMay 25, 1981 · N32303 · Substantial damageNTSB NYC82FHD25Accident · No injuriesClosedBeech 55 · West Chester, PAMay 23, 1981 · N322SP · Substantial damageNTSB NYC81FHD24Accident · No injuriesClosedEnstrom F-28A · New London, PAMay 17, 1981 · N9608 · Substantial damageNTSB NYC81FGM18Accident · No injuriesClosedCessna 170B · Belle Vernon, PAMay 8, 1981 · N250K · Substantial damageNTSB NYC81DHA11Accident · Minor injuriesClosedCessna 172 · Erwinna, PAMay 3, 1981 · N21294 · Substantial damageNTSB NYC81FHA10Accident · Minor injuriesClosedCessna 150G · Stroudsburg, PAMay 2, 1981 · N4073J · Substantial damageNTSB NYC81FHD21Accident · No injuriesClosedBeech B-35 · New London, PAMay 1, 1981 · N5253C · Substantial damageNTSB NYC81FGM19Accident · No injuriesClosedPiper PA-28 · Clearfield, PAApr 22, 1981 · N2695T · Substantial damageNTSB NYC81FA042Accident · 1 fatalClosedCessna 401A · State College, PAApr 21, 1981 · N6265Q · DestroyedNTSB NYC81FA041Accident · 2 fatalClosedCessna 320 · West Mifflin, PAApr 20, 1981 · N5500E · DestroyedNTSB NYC81FHD19Accident · No injuriesClosedPiper PA-28 · West Chester, PAApr 16, 1981 · N8754E · Substantial damageNTSB NYC81FGM17Accident · No injuriesClosedBeech B19 · Bridgeville, PAApr 12, 1981 · N18888 · Substantial damageNTSB NYC81FGM16Accident · No injuriesClosedCessna 180 · Apollo, PAApr 12, 1981 · N3327D · Substantial damageNTSB NYC81FGM15Accident · No injuriesClosedCessna 172E · Irwin, PAApr 7, 1981 · N5718T · Substantial damageNTSB NYC81FA037Accident · No injuriesClosedPiper J3 · Canton, PAApr 2, 1981 · N21609 · Substantial damageNTSB NYC81FA036Accident · Serious injuriesClosedPiper PA-12 · Leroy Township, PAMar 28, 1981 · N2918M · Substantial damageNTSB NYC81FHD17Accident · No injuriesClosedPiper PA-28 · Bristol, PAMar 27, 1981 · N2876Z · Substantial damageNTSB NYC81DHA07Accident · No injuriesClosedPiper PA-38 · Easton, PAMar 23, 1981 · N2535A · Substantial damageNTSB NYC81FGM13Accident · No injuriesClosedPitts S-1 · Somerset, PAMar 22, 1981 · N70JM · Substantial damageNTSB NYC81FGM14Accident · No injuriesClosedPiper PA-38 · Beaver Falls, PAMar 21, 1981 · N2552D · Substantial damageNTSB NYC81FGM12Accident · No injuriesClosedPiper PA-28R · Indiana, PAMar 15, 1981 · N4957J · Substantial damageNTSB NYC81DHA08Accident · No injuriesClosedCessna 172 · Morgantown, PAMar 14, 1981 · N5721R · DestroyedNTSB NYC81FGT02Accident · Serious injuriesClosedCessna 402B · Bloomsburg, PAMar 11, 1981 · N7888Q · DestroyedNTSB NYC81FA031Accident · Minor injuriesClosedBeech H18 · Hazelton, PAMar 11, 1981 · N161SP · Substantial damageNTSB NYC81FHD13Accident · Minor injuriesClosedCessna 177RG · Philadelphia, PAFeb 25, 1981 · N34144 · DestroyedNTSB NYC81FGM11Accident · No injuriesClosedAeronca 11AC · Elizabeth, PAFeb 15, 1981 · N3769E · Substantial damageNTSB NYC81FA024Accident · Serious injuriesClosedBeech C-45H · Dillsburg, PAFeb 2, 1981 · N45437 · DestroyedNTSB NYC81FGM10Accident · No injuriesClosedAeronca 7EC · Butler, PAJan 25, 1981 · N7578B · Substantial damageNTSB NYC81FA020Accident · Serious injuriesClosedAgusta A109-A · Pittsburgh, PAJan 16, 1981 · N86NR · DestroyedNTSB NYC81IA019Incident · No injuriesClosedPiper PA-32 · Coatesville, PAJan 15, 1981 · N2147N · Minor damage