NTSB investigations, 1965, PA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1965, 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\") = 1965
    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 NYC66D0420Accident · No injuriesClosedCessna 310C · Philadelphia, PADec 31, 1965 · N6703T · Substantial damageNTSB NYC66F0405Accident · No injuriesClosedPiper P A-28 · Mt Alton, PADec 28, 1965 · N8418W · Substantial damageNTSB NYC66F0401Accident · Minor injuriesClosedPiper PA-22 · Butler, PADec 22, 1965 · N5843Z · Substantial damageNTSB NYC66D0434Accident · No injuriesClosedCessna 195 · Philadelphia, PADec 17, 1965 · N177US · Substantial damageNTSB NYC66D0453Accident · Minor injuriesClosedErcoupe 415-C · Londonderry Tp, PADec 16, 1965 · N2205H · DestroyedNTSB NYC66D0424Accident · Minor injuriesClosedCessna 172 · Pittsburg, PADec 15, 1965 · N2589U · Substantial damageNTSB NYC66A0066Accident · 1 fatalClosedPiper PA-28 · Reading, PADec 13, 1965 · N8911T · DestroyedNTSB NYC66A0064Accident · 2 fatalClosedMaule M-4 · Windber, PADec 4, 1965 · N4719T · DestroyedNTSB NYC66F0410Accident · No injuriesClosedAero Cmdr 680-E · Philadelphia, PADec 3, 1965 · N9375R · Substantial damageNTSB NYC66D0364Accident · No injuriesClosedBeechcraft A-23 · Doylestown, PANov 28, 1965 · N3552R · Substantial damageNTSB NYC66D0362Accident · No injuriesClosedPiper PA-28 · Langhorne, PANov 23, 1965 · N6523W · Substantial damageNTSB NYC66F0363Accident · No injuriesClosedNavion A · Morrisville, PANov 21, 1965 · N4047K · Substantial damageNTSB NYC66D0383Accident · No injuriesClosedCessna 210E · New Cumberland, PANov 21, 1965 · N4900U · Substantial damageNTSB NYC66F0392Accident · Serious injuriesClosedCessna 190 · Latrobe, PANov 20, 1965 · N1598D · DestroyedNTSB NYC66D0355Accident · No injuriesClosedStinson 108-1 · Mechanicsburg, PANov 20, 1965 · N8535K · Substantial damageNTSB NYC66F0353Accident · No injuriesClosedCessna 182 · Kutztown, PANov 16, 1965 · N2432R · Substantial damageNTSB NYC66D0352Accident · No injuriesClosedPiper PA-28 · Mt Pocono, PANov 14, 1965 · N8751W · Substantial damageNTSB NYC66A0053Accident · Serious injuriesClosedDouglas DC-3 · Coraopolis, PANov 9, 1965 · N52 · DestroyedNTSB NYC66D0346Accident · No injuriesClosedMooney M20C · Kane, PANov 8, 1965 · N6672R · Substantial damageNTSB NYC66F0326Accident · No injuriesClosedStearman Hamond · Honesdale, PANov 7, 1965 · N15525 · Substantial damageNTSB NYC66D0335Accident · No injuriesClosedCessna 175 · Lewiston, PANov 1, 1965 · N7531M · Substantial damageNTSB NYC66F0393Accident · No injuriesClosedPiper PA-24 · West Mifflin, PAOct 31, 1965 · N5276P · Substantial damageNTSB NYC66F0376Accident · No injuriesClosedBellanca 14-13 · Somerset, PAOct 31, 1965 · N74392 · Substantial damageNTSB NYC66F0347Accident · No injuriesClosedPiper PA24 · Lock Haven, PAOct 31, 1965 · N8317P · Substantial damageNTSB NYC66D0345Accident · No injuriesClosedPiper PA-22 · Butler, PAOct 17, 1965 · N4318A · 2 aircraft · Substantial damageNTSB NYC66F0289Accident · No injuriesClosedCessna 150 · West Chester, PAOct 16, 1965 · N5633E · Substantial damageNTSB NYC66A0048Accident · No injuriesClosedBensen B8M · Benton, PAOct 3, 1965 · N1138 · Substantial damageNTSB NYC66F0253Accident · No injuriesClosedBeechcraft C-35 · Newton, PASep 30, 1965 · N325AA · Substantial damageNTSB NYC66F0254Accident · Serious injuriesClosedPiper PA-28 · Philadelphia, PASep 28, 1965 · N6378W · Substantial damageNTSB NYC66D0296Accident · No injuriesClosedCessna 175 · Bedford, PASep 26, 1965 · N7036M · Substantial damageNTSB NYC66F0319Accident · No injuriesClosedHelio MK2 · Shippenville, PASep 23, 1965 · N5456E · Substantial damageNTSB NYC66D0360Accident · No injuriesClosedCessna 172 · Erie, PASep 22, 1965 · N5360R · Substantial damageNTSB NYC66F0238Accident · No injuriesClosedPiper PA-23 · Allentown, PASep 21, 1965 · N286GB · Substantial damageNTSB NYC66D0255Accident · No injuriesClosedMooney M20A · Avondale, PASep 17, 1965 · N6567B · Substantial damageNTSB NYC66D0336Accident · Minor injuriesClosedPiper J3C-65 · Brockport, PASep 11, 1965 · N92357 · Substantial damageNTSB NYC66F0227Accident · No injuriesClosedStinson 108-2 · Franklin, PASep 6, 1965 · N964D · Substantial damageNTSB NYC66F0199Accident · No injuriesClosedPiper PA-28 · Morrisville, PASep 5, 1965 · N6142W · Substantial damageNTSB NYC66A0032Accident · 1 fatalClosedStinson 108-3 · Milroy, PASep 5, 1965 · N6353M · DestroyedNTSB NYC66D0197Accident · No injuriesClosedAeronca 7AC · West Chester, PASep 4, 1965 · N85627 · Substantial damageNTSB NYC66F0221Accident · No injuriesClosedPiper J3C · Monroeville, PASep 3, 1965 · N98679 · Substantial damageNTSB NYC66F0208Accident · No injuriesClosedCessna 180 · Tarentum, PASep 3, 1965 · N4998A · Substantial damageNTSB NYC66A0030Accident · 1 fatalClosedNavion A · St Marys, PASep 2, 1965 · N5115K · DestroyedNTSB NYC66A0029Accident · 4 fatalClosedMaule BD-M-4 · Champion, PASep 1, 1965 · N4735T · DestroyedNTSB NYC66D0229Accident · No injuriesClosedNavion B · Elysburg, PAAug 31, 1965 · N5259K · Substantial damageNTSB NYC66D0198Accident · No injuriesClosedPiper PA-22 · State College, PAAug 31, 1965 · N6164D · Substantial damageNTSB NYC66F0233Accident · Serious injuriesClosedPiper PA15 · Bloomsburg, PAAug 30, 1965 · N4132H · DestroyedNTSB NYC66F0214Accident · Minor injuriesClosedNavion 4 · Austin, PAAug 26, 1965 · N4270K · DestroyedNTSB NYC66F0205Accident · No injuriesClosedCessna 182A · Dravosburg, PAAug 23, 1965 · N4732D · Substantial damageNTSB NYC66A0027Accident · Minor injuriesClosedBrantly 305 · Millheim, PAAug 23, 1965 · N2202U · Substantial damageNTSB NYC66F0230Accident · No injuriesClosedCessna 140 · Keating, PAAug 16, 1965 · N76066 · Substantial damage