NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 NYC67D0439Accident · No injuriesClosedPiper PA-22 · Clarion, PADec 31, 1966 · N3547P · Substantial damageNTSB NYC67F0574Accident · No injuriesClosedPiper PA-24 · Coraopolis, PADec 30, 1966 · N5276P · Substantial damageNTSB NYC67F0428Accident · No injuriesClosedPiper PA-24 · Selinsgrove, PADec 30, 1966 · N8999P · Substantial damageNTSB NYC67D0675Accident · No injuriesClosedCessna 172C · Greenville, PADec 30, 1966 · N8274X · Substantial damageNTSB NYC67F0438Accident · No injuriesClosedLuscombe 8E · Aliquippa, PADec 25, 1966 · N2527K · DestroyedNTSB NYC67F0411Accident · No injuriesClosedCessna 411 · Erie, PADec 20, 1966 · N2214Z · Substantial damageNTSB NYC67D0480Accident · Minor injuriesClosedPiper PA-28 · Millcreek, PADec 17, 1966 · N5483Z · Substantial damageNTSB NYC67D0417Accident · No injuriesClosedAeronca 7AC · Mechanicsburg, PADec 17, 1966 · N82146 · No damageNTSB NYC67A0091Accident · No injuriesClosedPiper PA-23 · Lock Haven, PADec 5, 1966 · N5625U · Substantial damageNTSB NYC67D0397Accident · No injuriesClosedNavion G · West Chester, PANov 29, 1966 · N2443T · Substantial damageNTSB NYC67A0089Accident · No injuriesClosedConvair 340 · New Cumberland, PANov 29, 1966 · N3414 · Substantial damageNTSB NYC67A0085Accident · 1 fatalClosedPiper PA-18 · Northeast, PANov 23, 1966 · N4202Z · DestroyedNTSB NYC67A0083Accident · 4 fatalClosedPiper PA-23 · Lewisburg, PANov 23, 1966 · N4562P · DestroyedNTSB NYC67A0082Accident · No injuriesClosedPiper PA-24 · Berwick, PANov 23, 1966 · N8912P · Substantial damageNTSB NYC67F0378Accident · No injuriesClosedMaule M4 · Mt Pleasant, PANov 20, 1966 · N4724T · Substantial damageNTSB NYC67F0349Accident · No injuriesClosedCessna 320B · Easton, PANov 18, 1966 · N810S · Substantial damageNTSB NYC67F0367Accident · No injuriesClosedCessna 180 · Culmerville, PANov 17, 1966 · N3613C · Substantial damageNTSB NYC67F0372Accident · Serious injuriesClosedStinson 108-3 · New Castle, PANov 13, 1966 · N6970M · DestroyedNTSB NYC67D0379Accident · No injuriesClosedPiper PA-28 · Clearfield, PANov 13, 1966 · N8546W · Substantial damageNTSB NYC67D0374Accident · No injuriesClosedMooney M20E · Johnstown, PANov 11, 1966 · N7844V · Substantial damageNTSB NYC67F0377Accident · No injuriesClosedCessna 150 · Hiladelphia, PANov 8, 1966 · N8517G · Substantial damageNTSB NYC67D0358Accident · No injuriesClosedPiper PA-24 · Pottstown, PANov 8, 1966 · N8353P · Substantial damageNTSB NYC67A0077Accident · 3 fatalClosedBeech S35 · Columbia X-Rds, PANov 7, 1966 · N6030F · DestroyedNTSB NYC67A0076Accident · No injuriesClosedPiper PA-30 · New Cumberland, PANov 7, 1966 · N7507Y · Substantial damageNTSB NYC67I0074Incident · No injuriesClosedViscount 745D · Pittsburg, PANov 2, 1966 · N7422 · No damageNTSB NYC67F0341Accident · No injuriesClosedCessna 140 · Danville, PAOct 30, 1966 · N1992V · Substantial damageNTSB NYC67F0317Accident · Minor injuriesClosedPiper PA-12 · Clarks Summit, PAOct 30, 1966 · N3414M · DestroyedNTSB NYC67D0373Accident · No injuriesClosedMooney M20E · Grove City, PAOct 30, 1966 · N7826V · Substantial damageNTSB NYC67F0355Accident · No injuriesClosedBeechcraft E18S · Reedsville, PAOct 27, 1966 · N219Y · Substantial damageNTSB NYC67F0326Accident · No injuriesClosedPiper PA-30 · Morrisville, PAOct 25, 1966 · N7907Y · DestroyedNTSB NYC67D0375Accident · Minor injuriesClosedPiper PA-22 · Erie, PAOct 23, 1966 · N5385Z · Substantial damageNTSB NYC67A0064Accident · No injuriesClosedBrantly 305 · West Mifflin, PAOct 22, 1966 · N2207U · Substantial damageNTSB NYC67D0365Accident · No injuriesClosedStinson 108-1 · Leechburg, PAOct 21, 1966 · N8701K · Substantial damageNTSB NYC67A0106Accident · No injuriesClosedHiller UH-12A · Honesdale, PAOct 13, 1966 · N8109H · Substantial damageNTSB NYC67F0300Accident · No injuriesClosedCessna 150 · Carlisle, PAOct 2, 1966 · N7834E · Substantial damageNTSB NYC67D0323Accident · No injuriesClosedPiper PA-20 · Finleyville, PAOct 2, 1966 · N1564A · Substantial damageNTSB NYC67F0280Accident · No injuriesClosedMooney M20E · Avoca, PASep 30, 1966 · N1279X · Substantial damageNTSB NYC67F0252Accident · No injuriesClosedCessna 337 · Ohnstown, PASep 28, 1966 · CF-SBX · Substantial damageNTSB NYC67D0366Accident · No injuriesClosedPiper PA-28 · Johnston, PASep 28, 1966 · N7856W · Substantial damageNTSB NYC67A0052Accident · 1 fatalClosedBensen B8M · Benton, PASep 25, 1966 · N1138 · DestroyedNTSB NYC67F0244Accident · Serious injuriesClosedCessna 180 · Tarentum, PASep 6, 1966 · N1612C · Substantial damageNTSB NYC67F0189Accident · No injuriesClosedCessna 180 · Freedom, PASep 5, 1966 · N2919A · Substantial damageNTSB NYC67F0271Accident · Serious injuriesClosedCessna 182 · Clarion, PASep 4, 1966 · N8387S · DestroyedNTSB NYC67F0206Accident · No injuriesClosedCessna 182A · Pottstown, PASep 3, 1966 · N2041G · Substantial damageNTSB NYC67F0176Accident · No injuriesClosedMooney MK20A · Allentown, PASep 1, 1966 · N8170E · Substantial damageNTSB NYC67D0246Accident · No injuriesClosedMooney M20C · Philadelphia, PASep 1, 1966 · N5681Q · Substantial damageNTSB NYC67F0230Accident · Minor injuriesClosedPiper PA-22 · Milroy, PAAug 31, 1966 · N9552D · Substantial damageNTSB NYC67A0041Accident · No injuriesClosedHughes 269A · Montoursville, PAAug 30, 1966 · N8803F · DestroyedNTSB NYC67F0190Accident · No injuriesClosedPiper PA-28 · West Mifflin, PAAug 28, 1966 · N6393W · Substantial damageNTSB NYC67F0247Accident · No injuriesClosedCessna 172B · Annville, PAAug 25, 1966 · N8094X · Substantial damage