NTSB investigations, 1964, 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, 1964, 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\") = 1964
    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 UNK65X1204Accident · No injuriesClosedCessna 182 · Benton, PADec 31, 1964 · N3130S · Substantial damageNTSB UNK65X1100Accident · No injuriesClosedBeechcraft B55 · Allentown, PADec 23, 1964 · N6845Q · Substantial damageNTSB UNK65X1099Accident · No injuriesClosedBell 47J2 · Philadelphia, PADec 22, 1964 · N73216 · Substantial damageNTSB UNK65X1045Accident · Minor injuriesClosedBrantly B2B · Hawthorn, PADec 18, 1964 · N2264U · Substantial damageNTSB UNK65X1028Accident · No injuriesClosedCessna 310C · Bedford, PADec 16, 1964 · N1779H · Substantial damageNTSB UNK65X1022Accident · No injuriesClosedVickers VI745D · Franklin, PADec 15, 1964 · N505W · Substantial damageNTSB UNK65X0968Accident · No injuriesClosedPiper PA24 · Philadelphia, PADec 10, 1964 · N6638P · Substantial damageNTSB UNK65X0895Accident · No injuriesClosedChampion 7FC · Berwick, PADec 1, 1964 · N9050B · Substantial damageNTSB UNK65X0890Accident · Serious injuriesClosedPiper PA22 · St Marys, PANov 30, 1964 · N8616C · DestroyedNTSB UNK65X0870Accident · 4 fatalClosedCessna 172 · Philadelphia, PANov 28, 1964 · N3558S · DestroyedNTSB UNK65X0858Accident · Minor injuriesClosedAeronca 7AC · Emporium, PANov 27, 1964 · N84241 · Substantial damageNTSB UNK65X0846Accident · Minor injuriesClosedPiper PA22 · Warren, PANov 26, 1964 · N7302D · Substantial damageNTSB UNK65X0844Accident · 3 fatalClosedCessna 310B · Clarks Summit, PANov 26, 1964 · N5364A · DestroyedNTSB UNK65X0829Accident · Serious injuriesClosedPiper PA-24 · Mars, PANov 25, 1964 · N7334P · Substantial damageNTSB UNK65X0821Accident · Minor injuriesClosedPiper PA-22 · Waynesburg, PANov 24, 1964 · N7204D · DestroyedNTSB UNK65X0717Accident · No injuriesClosedCessna 140A · Somerset, PANov 15, 1964 · N242S · Substantial damageNTSB UNK65X0703Accident · No injuriesClosedCessna 210D · West Mifflin, PANov 14, 1964 · N3733Y · Substantial damageNTSB UNK65X0702Accident · No injuriesClosedStinson 108-1 · Collegeville, PANov 14, 1964 · N9202K · Substantial damageNTSB UNK65X0701Accident · Minor injuriesClosedTaylorcraft DC065 · Emlenton, PANov 14, 1964 · N57731 · DestroyedNTSB UNK65X0599Accident · No injuriesClosedMooney M21 · Clarks Summit, PANov 7, 1964 · N6885U · Substantial damageNTSB UNK65X0587Accident · 1 fatalClosedPiper PA-28 · Center Valley, PANov 6, 1964 · N8892W · Substantial damageNTSB UNK65X0563Incident · No injuriesClosedViscount 745 · Harrisburg, PANov 5, 1964 · N7429 · Minor damageNTSB UNK65X0539Accident · No injuriesClosedBeechcraft B50 · Waynesburg, PANov 3, 1964 · N3561B · Substantial damageNTSB UNK65X0495Accident · No injuriesClosedCurtis C-46F · Pittsburgh, PAOct 30, 1964 · N618Z · Substantial damageNTSB UNK65X0494Accident · Serious injuriesClosedPiper PA24 · Stahlstown, PAOct 30, 1964 · N7721P · DestroyedNTSB UNK65X0461Accident · No injuriesClosedCessna 310C · Phillipsburg, PAOct 28, 1964 · N1779H · Substantial damageNTSB UNK65X0435Accident · No injuriesClosedCessna 150 · Clarion, PAOct 25, 1964 · N7766E · Substantial damageNTSB UNK65X0426Accident · No injuriesClosedTaylorcraft BC1265 · Slate Run, PAOct 25, 1964 · N23888 · DestroyedNTSB UNK65X0408Accident · No injuriesClosedCesna 310 · Kylertown, PAOct 24, 1964 · N6705T · Substantial damageNTSB UNK65X0354Incident · No injuriesClosedBoeing 727-23 · Allentown, PAOct 21, 1964 · N1791 · No damageNTSB UNK65X0353Accident · No injuriesClosedCessna T-50 · Collegeville, PAOct 21, 1964 · N69841 · Substantial damageNTSB UNK65X0327Accident · No injuriesClosedBeechcraft 23 · Clark Summits, PAOct 18, 1964 · N8727M · Substantial damageNTSB UNK65X0324Accident · No injuriesClosedAeronca 7DC · Bridgeville, PAOct 18, 1964 · N4533E · Substantial damageNTSB UNK65X0294Accident · No injuriesClosedBeechcraft K35 · State College, PAOct 16, 1964 · N3085C · Substantial damageNTSB UNK65X0196Accident · No injuriesClosedCessna 140 · Slate Run, PAOct 8, 1964 · N89012 · DestroyedNTSB UNK65X0172Accident · No injuriesClosedAeronca 65C · Dalton, PAOct 7, 1964 · N22392 · Substantial damageNTSB UNK65X0163Accident · No injuriesClosedCessna 182F · Lancaster, PAOct 6, 1964 · N3532Y · Substantial damageNTSB UNK65X0154Accident · No injuriesClosedCessna 150 · Allentown, PAOct 5, 1964 · N6560T · Substantial damageNTSB UNK65X0119Accident · No injuriesClosedPiper PA30 · Reading, PAOct 3, 1964 · N7178Y · Substantial damageNTSB UNK64X4220Accident · No injuriesClosedLuscombe 8E · Butler, PASep 30, 1964 · N2527K · Substantial damageNTSB UNK64X4178Accident · No injuriesClosedCessna 172 · Lancaster, PASep 27, 1964 · N5150A · Substantial damageNTSB UNK64X4135Incident · No injuriesClosedBoeing 707 131B · Reading, PASep 25, 1964 · N6781TW · Minor damageNTSB UNK64X4057Accident · 3 fatalClosedCessna 170B · Ickesburg, PASep 19, 1964 · N4460B · DestroyedNTSB UNK64X4034Accident · No injuriesClosedPiper PA24 · Phildelphia, PASep 18, 1964 · N7867P · Substantial damageNTSB UNK64X4015Accident · No injuriesClosedPiper PA22 · Blawnox, PASep 17, 1964 · N7032B · Substantial damageNTSB UNK64X3999Accident · No injuriesClosedPiper PA24 · Ulysses, PASep 16, 1964 · N6123P · Substantial damageNTSB UNK64X3990Accident · No injuriesClosedPiper PA28 · Lewistown, PASep 14, 1964 · N8606W · Substantial damageNTSB UNK64X3969Accident · No injuriesClosedNavion · Honesdale, PASep 13, 1964 · N8718H · Substantial damageNTSB UNK64X3952Accident · 1 fatalClosedCessna 175 · Quakertown, PASep 13, 1964 · N8382T · DestroyedNTSB UNK64X3915Accident · Minor injuriesClosedPiper PA28 · Martinsburg, PASep 11, 1964 · N5166W · Substantial damage