Skip to content

NTSB investigations, PA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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 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 NYC74DGM05Accident · Serious injuriesClosedJeanies Teenie · Indiana, PASep 10, 1973 · N9777 · Substantial damage NTSB NYC74FGT05Accident · Minor injuriesClosedAeronca 7AC · Gettysburg, PASep 8, 1973 · N84591 · Substantial damage NTSB NYC74FHD14Accident · No injuriesClosedBeech P35 · Parker Ford, PASep 3, 1973 · N5335E · Substantial damage NTSB NYC74FGM04Accident · No injuriesClosedPiper J3C-65 · Pittsfield, PASep 3, 1973 · N92636 · Substantial damage NTSB NYC74FHA08Accident · 1 fatalClosedPat-Bar Spcl · Bally, PASep 2, 1973 · N229D · Substantial damage NTSB NYC74FGT04Accident · No injuriesClosedPitts Spcl · Marietta, PAAug 31, 1973 · N7T · Substantial damage NTSB NYC74DGM03Accident · No injuriesClosedTaylorcraft BF1265 · Meadville, PAAug 25, 1973 · N39144 · Substantial damage NTSB NYC74DHA07Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PAAug 24, 1973 · N1241S · Substantial damage NTSB NYC74DHD11Accident · Minor injuriesClosedAmer Avco AA1-B · Bristol, PAAug 19, 1973 · N9627L · Destroyed NTSB NYC74AN016Accident · 1 fatalClosedAeronca 11AC · Prospect, PAAug 18, 1973 · N23518 · Substantial damage NTSB NYC74FHA06Accident · No injuriesClosedBell 47D1 · Stockertown, PAAug 17, 1973 · N2795A · Substantial damage NTSB NYC74AN015Accident · Serious injuriesClosedBeech S35 · State College, PAAug 17, 1973 · N434V · Substantial damage NTSB NYC74DGT06Accident · No injuriesClosedPiper PA-28 · Annville, PAAug 16, 1973 · N655FL · Substantial damage NTSB NYC74AN014Accident · 1 fatalClosedCessna 172K · Huntingdon Vly, PAAug 13, 1973 · N7060G · Destroyed NTSB NYC74AN012Accident · No injuriesClosedPiper PA-23 · University Prk, PAAug 10, 1973 · N94T · Substantial damage NTSB NYC74FHA05Accident · No injuriesClosedBoeing A75N1 · Erwinna, PAAug 4, 1973 · N2313 · Substantial damage NTSB NYC74FHA03Accident · No injuriesClosedSchweizer 126E · Kutztown, PAJul 30, 1973 · N17908 · Substantial damage NTSB NYC74DGM02Accident · No injuriesClosedPiper PA-16 · Beaver Falls, PAJul 30, 1973 · N5680H · Substantial damage NTSB NYC74FHA04Accident · No injuriesClosedCessna 150J · Honesdale, PAJul 25, 1973 · N50476 · Substantial damage NTSB NYC74FGT02Accident · No injuriesClosedDehavilland DH82A · Cogan Station, PAJul 24, 1973 · N90406 · Substantial damage NTSB NYC74FGM01Accident · No injuriesClosedPiper PA-24 · Butler, PAJul 13, 1973 · N8582P · Substantial damage NTSB NYC74FHA01Accident · No injuriesClosedCessna 150L · Benton, PAJul 11, 1973 · N21985 · Substantial damage NTSB NYC74DGT03Accident · No injuriesClosedGlasflugel H301 · Fairfield, PAJul 5, 1973 · N3943 · Minor damage NTSB NYC74FHD05Accident · No injuriesClosedPiper PA-30 · Philadelphia, PAJul 4, 1973 · N740AF · Substantial damage NTSB NYC73FHA28Accident · Minor injuriesClosedPiper PA-28 · Robesonia, PAJun 30, 1973 · N5779W · Substantial damage NTSB NYC73FHA27Accident · No injuriesClosedPiper PA-28 · Easton, PAJun 22, 1973 · N4397J · Substantial damage NTSB NYC73FGT13Accident · No injuriesClosedPiper PA-28 · State College, PAJun 22, 1973 · N7462W · Substantial damage NTSB NYC73DGM36Accident · No injuriesClosedPiper PA-24 · Wampum, PAJun 22, 1973 · N7131P · Substantial damage NTSB NYC73FGT14Accident · No injuriesClosedCessna 140 · Thomasville, PAJun 19, 1973 · N89171 · Substantial damage NTSB NYC73FGM35Accident · No injuriesClosedBeech D95A · Beaver Falls, PAJun 13, 1973 · N4879J · Substantial damage NTSB NYC73AN151Accident · Minor injuriesClosedConvair 580 · Pittsburgh, PAJun 12, 1973 · N5837 · Substantial damage NTSB NYC73FGM37Accident · No injuriesClosedPiper PA-28R · Washington, PAJun 11, 1973 · N4809T · Substantial damage NTSB NYC73DGM34Accident · No injuriesClosedGreat Lakes 2T-1AE · Saltsburg, PAJun 5, 1973 · N305Y · Substantial damage NTSB NYC73DGM33Accident · No injuriesClosedCessna 150G · Erie, PAJun 2, 1973 · N3203J · Substantial damage NTSB NYC73IN146Incident · No injuriesClosedLockheed 1011 · Philadelphia, PAMay 31, 1973 · N313EA · No damage NTSB NYC73FHA26Accident · No injuriesClosedCessna 182N · Easton, PAMay 29, 1973 · N92127 · Substantial damage NTSB NYC73FGM32Accident · Minor injuriesClosedCessna 172G · Elton, PAMay 25, 1973 · N1138F · Substantial damage NTSB NYC73AN144Accident · Minor injuriesClosedHoward Aero 500 · Washington, PAMay 24, 1973 · N621W · Substantial damage NTSB NYC73FGT12Accident · No injuriesClosedPiper PA-28R · York Haven, PAMay 22, 1973 · N5012S · Substantial damage NTSB NYC73FGT10Accident · Minor injuriesClosedAmer Avco AA-1B · Frackville, PAMay 5, 1973 · N9608L · Destroyed NTSB NYC73FGM31Accident · No injuriesClosedStinson 108-1 · Meadville, PAMay 5, 1973 · N9014K · Substantial damage NTSB NYC73FGM30Accident · No injuriesClosedMooney M20F · Butler, PAMay 2, 1973 · N9060V · Substantial damage NTSB NYC73FHA73Accident · Minor injuriesClosedCessna 177B · Pottstown, PAApr 29, 1973 · N34231 · 2 aircraft · Substantial damage NTSB NYC73DHD34Accident · No injuriesClosedEnstrom F-28A · Centr Square, PAApr 29, 1973 · N9589 · Substantial damage NTSB NYC73FGM29Accident · No injuriesClosedBellanca 17-30A · Freidens, PAApr 24, 1973 · N39880 · Substantial damage NTSB NYC73FGT09Accident · No injuriesClosedSchleicher II · Fairfield, PAApr 22, 1973 · N7984 · Substantial damage NTSB NYC73DHD35Accident · No injuriesClosedBellanca 14-19 · N.Philadelphia, PAApr 17, 1973 · N7308V · Substantial damage NTSB NYC73AN134Accident · No injuriesClosedEnstrom F-28A · Philadelphia, PAApr 17, 1973 · N9562 · Substantial damage NTSB NYC73DGM28Accident · No injuriesClosedCessna 172 · Wattsburg, PAApr 16, 1973 · N5360R · Substantial damage NTSB NYC73FHA22Accident · No injuriesClosedCessna 182 · Skytop, PAApr 15, 1973 · N21101 · Substantial damage