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.
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 NYC81DA069Accident · Serious injuriesClosedBritish AC 1-11 · Pittsburgh, PANTSB NYC81FGT06Accident · No injuriesClosedBell 47G · Shrewsbury, PANTSB NYC81FGM21Accident · No injuriesClosedPiper PA-28 · Breezewood, PANTSB NYC81FHD29Accident · No injuriesClosedCessna 152 · Philadelphia, PANTSB NYC81FA067Accident · No injuriesClosedCessna 210 · Philadelphia, PANTSB NYC81IA061Incident · Minor injuriesClosedShort Bros SD3-30 · Wilkes Barre, PANTSB NYC81FA056Accident · No injuriesClosedBeech G18S · New Cumberland, PANTSB NYC81IA057Incident · No injuriesClosedShorts SD3-30 · Middletown, PANTSB NYC81FGT05Accident · No injuriesClosedPiper PA-28 · Annville, PANTSB NYC81FGM20Accident · Minor injuriesClosedBensen B8M · Greenville, PANTSB NYC81DHA14Accident · No injuriesClosedCessna 150H · Tobyhanna, PANTSB NYC81FGT03Accident · Minor injuriesClosedCessna 172 · Palmyra, PANTSB NYC81DHA13Accident · No injuriesClosedPiper PA-32 · Factoryville, PANTSB NYC82FHD25Accident · No injuriesClosedBeech 55 · West Chester, PANTSB NYC81FHD24Accident · No injuriesClosedEnstrom F-28A · New London, PANTSB NYC81FGM18Accident · No injuriesClosedCessna 170B · Belle Vernon, PANTSB NYC81DHA11Accident · Minor injuriesClosedCessna 172 · Erwinna, PANTSB NYC81FHA10Accident · Minor injuriesClosedCessna 150G · Stroudsburg, PANTSB NYC81FHD21Accident · No injuriesClosedBeech B-35 · New London, PANTSB NYC81FGM19Accident · No injuriesClosedPiper PA-28 · Clearfield, PANTSB NYC81FA042Accident · 1 fatalClosedCessna 401A · State College, PANTSB NYC81FA041Accident · 2 fatalClosedCessna 320 · West Mifflin, PANTSB NYC81FHD19Accident · No injuriesClosedPiper PA-28 · West Chester, PANTSB NYC81FGM17Accident · No injuriesClosedBeech B19 · Bridgeville, PANTSB NYC81FGM16Accident · No injuriesClosedCessna 180 · Apollo, PANTSB NYC81FGM15Accident · No injuriesClosedCessna 172E · Irwin, PANTSB NYC81FA037Accident · No injuriesClosedPiper J3 · Canton, PANTSB NYC81FA036Accident · Serious injuriesClosedPiper PA-12 · Leroy Township, PANTSB NYC81FHD17Accident · No injuriesClosedPiper PA-28 · Bristol, PANTSB NYC81DHA07Accident · No injuriesClosedPiper PA-38 · Easton, PANTSB NYC81FGM13Accident · No injuriesClosedPitts S-1 · Somerset, PANTSB NYC81FGM14Accident · No injuriesClosedPiper PA-38 · Beaver Falls, PANTSB NYC81FGM12Accident · No injuriesClosedPiper PA-28R · Indiana, PANTSB NYC81DHA08Accident · No injuriesClosedCessna 172 · Morgantown, PANTSB NYC81FGT02Accident · Serious injuriesClosedCessna 402B · Bloomsburg, PANTSB NYC81FA031Accident · Minor injuriesClosedBeech H18 · Hazelton, PANTSB NYC81FHD13Accident · Minor injuriesClosedCessna 177RG · Philadelphia, PANTSB NYC81FGM11Accident · No injuriesClosedAeronca 11AC · Elizabeth, PANTSB NYC81FA024Accident · Serious injuriesClosedBeech C-45H · Dillsburg, PANTSB NYC81FGM10Accident · No injuriesClosedAeronca 7EC · Butler, PANTSB NYC81FA020Accident · Serious injuriesClosedAgusta A109-A · Pittsburgh, PANTSB NYC81IA019Incident · No injuriesClosedPiper PA-32 · Coatesville, PA