NTSB investigations, 1973, 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, 1973, 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\") = 1973
    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 NYC74FHA22Accident · Minor injuriesClosedPiper PA-23 · Reading, PADec 23, 1973 · N1478P · DestroyedNTSB NYC74AN059Accident · 3 fatalClosedBeech G35 · Langhorn, PADec 22, 1973 · N4561D · DestroyedNTSB NYC74AN058Accident · 2 fatalClosedCessna 177RG · Dravosburg, PADec 21, 1973 · N77RG · DestroyedNTSB NYC74FGM12Accident · No injuriesClosedErco 415-C · West Middlesex, PADec 11, 1973 · N2955H · Substantial damageNTSB NYC74AN051Accident · 2 fatalClosedBeech E18S · Corapolis, PADec 7, 1973 · N387B · DestroyedNTSB NYC74FHA20Accident · No injuriesClosedMooney M20C · Collegeville, PADec 4, 1973 · N6754U · Substantial damageNTSB NYC74DHA19Accident · No injuriesClosedPiper PA-24 · Schwenksville, PANov 28, 1973 · N5478P · Substantial damageNTSB NYC74FHA17Accident · Minor injuriesClosedCessna 172 · Moscow, PANov 26, 1973 · N92136 · DestroyedNTSB NYC74AN049Accident · 1 fatalClosedPiper PA-28 · Lake Scranton, PANov 26, 1973 · N4978L · DestroyedNTSB NYC74AN048Accident · 3 fatalClosedPiper PA-28 · Donnally Mills, PANov 25, 1973 · N8056W · DestroyedNTSB NYC74FHA18Accident · No injuriesClosedMooney M20A · Lake Sheridan, PANov 23, 1973 · N8331E · Substantial damageNTSB NYC74AN047Accident · 3 fatalClosedPiper PA-24 · Dupont, PANov 21, 1973 · N8149P · DestroyedNTSB NYC74AN046Accident · 1 fatalClosedBell 206A · Webster, PANov 20, 1973 · N461NC · 2 aircraft · DestroyedNTSB NYC74IN037Incident · No injuriesClosedBoeing 737 · Keating, PAOct 29, 1973 · N9053U · Minor damageNTSB NYC74FGM11Accident · No injuriesClosedPiper PA-28 · Clarion, PAOct 27, 1973 · N1814J · Substantial damageNTSB NYC74AN035Accident · 2 fatalClosedBell 47G-5 · Waynesburg, PAOct 25, 1973 · N8556F · DestroyedNTSB NYC74FHA14Accident · No injuriesClosedErco 415-D · Tunkhannock, PAOct 20, 1973 · N2396H · Substantial damageNTSB NYC74FGM10Accident · No injuriesClosedAero Comdr 200D · West Mifflin, PAOct 20, 1973 · N2962T · Substantial damageNTSB NYC74DGT13Accident · No injuriesClosedAeronca 15AC · Columbia C Rds, PAOct 20, 1973 · N1271H · Substantial damageNTSB NYC74DHD10Accident · Minor injuriesClosedCessna 172 · New London, PAOct 15, 1973 · N19842 · Substantial damageNTSB NYC74FGT12Accident · Minor injuriesClosedPiper PA-28 · York, PAOct 14, 1973 · N690FL · Substantial damageNTSB NYC74DHA15Accident · No injuriesClosedCessna 310 · Fleetville, PAOct 12, 1973 · N244S · Substantial damageNTSB NYC74DGM09Accident · No injuriesClosedPiper PA-28 · Jeanette, PAOct 11, 1973 · N4860T · Substantial damageNTSB NYC74AN032Accident · 1 fatalClosedSikorsky S-55B · Nemacolin, PAOct 9, 1973 · N414A · DestroyedNTSB NYC74FHA11Accident · Serious injuriesClosedPiper PA-28R · Lehighton, PAOct 8, 1973 · N3072R · Substantial damageNTSB NYC74DHA12Accident · No injuriesClosedBlanik L-13 · Erwinna, PAOct 7, 1973 · N90598 · Substantial damageNTSB NYC74FEM08Accident · Serious injuriesClosedMooney M20 · Dubois, PASep 30, 1973 · N6531B · Substantial damageNTSB NYC74DGT11Accident · No injuriesClosedErco 415-D · Hershey, PASep 30, 1973 · N3850H · Substantial damageNTSB NYC74FHD09Accident · No injuriesClosedCessna 310I · Ambler, PASep 28, 1973 · N12MS · Substantial damageNTSB NYC74FGT09Accident · No injuriesClosedBell 206B · Milesburg, PASep 28, 1973 · N7079J · Substantial damageNTSB NYC74DGT10Accident · No injuriesClosedStinson 108-2 · East Waterford, PASep 28, 1973 · N9745K · Substantial damageNTSB NYC74DGM07Accident · No injuriesClosedAeronca 7DC · Carrolltown, PASep 27, 1973 · N2768E · Substantial damageNTSB NYC74AN031Accident · 2 fatalClosedPiper PA-24 · Montoursville, PASep 27, 1973 · N8470P · DestroyedNTSB NYC74DGM06Accident · No injuriesClosedPiper PA-28 · Smicksburg, PASep 22, 1973 · N5233T · Substantial damageNTSB NYC74FGT08Accident · No injuriesClosedPiper PA-28R · Deer Lake, PASep 21, 1973 · N2685R · Substantial damageNTSB NYC74FGT07Accident · No injuriesClosedPiper PA-40 · Lamar, PASep 21, 1973 · N9999P · DestroyedNTSB NYC74FHA09Accident · Minor injuriesClosedPiper PA-22 · Prospectville, PASep 16, 1973 · N5826Z · Substantial damageNTSB NYC74DGM05Accident · Serious injuriesClosedJeanies Teenie · Indiana, PASep 10, 1973 · N9777 · Substantial damageNTSB NYC74FGT05Accident · Minor injuriesClosedAeronca 7AC · Gettysburg, PASep 8, 1973 · N84591 · Substantial damageNTSB NYC74FHD14Accident · No injuriesClosedBeech P35 · Parker Ford, PASep 3, 1973 · N5335E · Substantial damageNTSB NYC74FGM04Accident · No injuriesClosedPiper J3C-65 · Pittsfield, PASep 3, 1973 · N92636 · Substantial damageNTSB NYC74FHA08Accident · 1 fatalClosedPat-Bar Spcl · Bally, PASep 2, 1973 · N229D · Substantial damageNTSB NYC74FGT04Accident · No injuriesClosedPitts Spcl · Marietta, PAAug 31, 1973 · N7T · Substantial damageNTSB NYC74DGM03Accident · No injuriesClosedTaylorcraft BF1265 · Meadville, PAAug 25, 1973 · N39144 · Substantial damageNTSB NYC74DHA07Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PAAug 24, 1973 · N1241S · Substantial damageNTSB NYC74DHD11Accident · Minor injuriesClosedAmer Avco AA1-B · Bristol, PAAug 19, 1973 · N9627L · DestroyedNTSB NYC74AN016Accident · 1 fatalClosedAeronca 11AC · Prospect, PAAug 18, 1973 · N23518 · Substantial damageNTSB NYC74FHA06Accident · No injuriesClosedBell 47D1 · Stockertown, PAAug 17, 1973 · N2795A · Substantial damageNTSB NYC74AN015Accident · Serious injuriesClosedBeech S35 · State College, PAAug 17, 1973 · N434V · Substantial damageNTSB NYC74DGT06Accident · No injuriesClosedPiper PA-28 · Annville, PAAug 16, 1973 · N655FL · Substantial damage