NTSB investigations, 1965

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

19622026
NTSB investigations, 1965 per year, 1962–2026: 180,581 cases
196272
196378
19645,253
19655,377
19665,912
19676,339
19685,199
19695,027
19704,915
19714,825
19724,430
19734,398
19744,565
19754,403
19764,314
19774,412
19784,624
19794,165
19803,921
19813,836
19823,545
19833,514
19843,405
19853,055
19862,831
19872,774
19882,685
19892,502
19902,479
19912,419
19922,328
19932,283
19942,229
19952,281
19962,150
19972,121
19982,195
19992,175
20002,183
20012,031
20022,000
20032,062
20041,930
20052,001
20061,826
20071,984
20081,882
20091,783
20101,786
20111,848
20121,834
20131,561
20141,534
20151,581
20161,662
20171,635
20181,687
20191,626
20201,396
20211,645
20221,700
20231,678
20241,693
20251,655
20261,342

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
  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 OAK66F0179Accident · No injuriesClosedMooney 20A · Hayward, CADec 31, 1965 · N6552B · Substantial damageNTSB OAK66D0178Accident · Minor injuriesClosedPiper PA-22 · Mammoth Lake, CADec 31, 1965 · N3954P · Substantial damageNTSB NYC66F0443Accident · No injuriesClosedErcoupe 415-C · Laytonsville, MDDec 31, 1965 · N2527H · Substantial damageNTSB NYC66D0438Accident · Minor injuriesClosedLuscombe 8A · Sanford, MEDec 31, 1965 · N71424 · Substantial damageNTSB NYC66D0420Accident · No injuriesClosedCessna 310C · Philadelphia, PADec 31, 1965 · N6703T · Substantial damageNTSB NYC66D0416Accident · No injuriesClosedBeechcraft G35 · Mendon, MADec 31, 1965 · N4409D · DestroyedNTSB MKC66F0336Accident · Minor injuriesClosedCessna U206 · Augusta, KSDec 31, 1965 · N8059Z · Substantial damageNTSB MKC66D0371Accident · No injuriesClosedMooney M20A · Kansas City, KSDec 31, 1965 · N6562B · Substantial damageNTSB MKC66D0335Accident · No injuriesClosedCessna 182 · Wichita, KSDec 31, 1965 · N2621F · Substantial damageNTSB MIA66F0398Accident · No injuriesClosedGlobe GC-1A · Orlando, FLDec 31, 1965 · N80588 · Substantial damageNTSB MIA66F0393Accident · No injuriesClosedChampion 7FC · Kissimee, FLDec 31, 1965 · N7531E · Substantial damageNTSB MIA66A0075Accident · 2 fatalClosedUniv Acft GC-1B · Greenville, SCDec 31, 1965 · N2381B · DestroyedNTSB LAX66A0052Accident · Minor injuriesClosedBell 47G-2 · Piru, CADec 31, 1965 · N972B · Substantial damageNTSB DEN66D0193Accident · No injuriesClosedCessna 170B · Carefree, AZDec 31, 1965 · N4500C · Substantial damageNTSB CHI66F0509Accident · No injuriesClosedMooney M20B · Springfield, ILDec 31, 1965 · N74707 · Substantial damageNTSB ANC66D0086Accident · No injuriesClosedCessna 172 · Port Heiden, AKDec 31, 1965 · N8269X · Substantial damageNTSB SEA66F0193Accident · No injuriesClosedCessna 150 · Ellensburg, WADec 30, 1965 · N7718E · Substantial damageNTSB SEA66A0039Accident · 1 fatalClosedCessna 170B · Pendleton, ORDec 30, 1965 · N2382D · Substantial damageNTSB NYC66F0435Accident · No injuriesClosedErcoupe 415-D · Marlboro, MADec 30, 1965 · N1DA · Substantial damageNTSB NYC66D0698Accident · Minor injuriesClosedCessna 172 · Charleston, WVDec 30, 1965 · N2413U · Substantial damageNTSB NYC66D0448Accident · No injuriesClosedChampion 7GC · Leesburg, VADec 30, 1965 · N8522E · Substantial damageNTSB MKC66F0346Accident · No injuriesClosedPiper PA-22 · Park Rapids, MNDec 30, 1965 · N1657A · Substantial damageNTSB MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NEDec 30, 1965 · N7236X · Substantial damageNTSB MKC66D0364Accident · No injuriesClosedCessna 182 · Centerville, IADec 30, 1965 · N8304S · Substantial damageNTSB MIA66F0505Accident · Serious injuriesClosedNavion A · Oceanway, FLDec 30, 1965 · N527BB · Substantial damageNTSB MIA66A0074Accident · No injuriesClosedBrantly B-2 · Tampa, FLDec 30, 1965 · N5906X · Substantial damageNTSB LAX66A0051Accident · 4 fatalClosedPiper PA-22 · S.Luis Obispo, CADec 30, 1965 · N7707D · DestroyedNTSB LAX66A0050Accident · Minor injuriesClosedHughes 269B · Bakersfield, CADec 30, 1965 · N9374F · Substantial damageNTSB FTW66A0061Accident · 4 fatalClosedBeech A35 · Llano, TXDec 30, 1965 · N126Y · DestroyedNTSB DEN66A0051Accident · No injuriesClosedBell 47G3B1 · Mesa, AZDec 30, 1965 · N73947 · Substantial damageNTSB ANC66A0047Accident · 3 fatalClosedPiper PA-14 · Anchorage, AKDec 30, 1965 · N4254H · DestroyedNTSB SEA66D0188Accident · No injuriesClosedCessna 180 · Babb, MTDec 29, 1965 · N6494X · Substantial damageNTSB SEA66A0040Accident · 4 fatalClosedPiper PA-30 · Ironside, ORDec 29, 1965 · N7675Y · DestroyedNTSB OAK66F0176Accident · No injuriesClosedPiper PA-23 · Reno, NVDec 29, 1965 · N5572Y · Substantial damageNTSB OAK66D0170Accident · No injuriesClosedCessna 210C · Antioch, CADec 29, 1965 · N3682Y · Substantial damageNTSB NYC66F0412Accident · Serious injuriesClosedCessna 150 · Medford, NJDec 29, 1965 · N6157T · Substantial damageNTSB NYC66F0395Accident · No injuriesClosedPiper PA-24 · Lunenburg, VADec 29, 1965 · N5911Z · Substantial damageNTSB MKC66D0366Accident · No injuriesClosedBeech A23 · Marion, IADec 29, 1965 · N8857M · Substantial damageNTSB MKC66D0340Accident · No injuriesClosedCessna 150 · Faucett, MODec 29, 1965 · N8955S · Substantial damageNTSB MIA66F0355Accident · Minor injuriesClosedCessna 172 · Pine Hall, NCDec 29, 1965 · N6967A · Substantial damageNTSB MIA66A0073Accident · 3 fatalClosedPiper PA-24Dec 29, 1965 · N6077P · DestroyedNTSB FTW66F0473Accident · No injuriesClosedBeechcraft AT-11 · Monroe, LADec 29, 1965 · N556T · Substantial damageNTSB FTW66D0464Accident · No injuriesClosedPiper PA-22 · Rosston, OKDec 29, 1965 · N2181A · Substantial damageNTSB FTW66D0437Accident · No injuriesClosedCessna 150 · Fayetteville, ARDec 29, 1965 · N6469T · Substantial damageNTSB FTW66A0060Accident · 3 fatalClosedBeech G35 · Redericksburg, TXDec 29, 1965 · N4554D · DestroyedNTSB DEN66F0199Accident · No injuriesClosedMooney M20C · Phoenix, AZDec 29, 1965 · N7815V · Substantial damageNTSB DEN66F0195Accident · No injuriesClosedCessna 310A · Salt Lake City, UTDec 29, 1965 · N5261A · Substantial damageNTSB DEN66A0052Accident · 3 fatalClosedBeech C35 · Coalville, UTDec 29, 1965 · N5945C · DestroyedNTSB CHI66F0552Accident · No injuriesClosedCessna 150 · West Chicago, ILDec 29, 1965 · N4119U · Substantial damageNTSB SEA66F0194Accident · Minor injuriesClosedStinson 108-1 · Springfield, ORDec 28, 1965 · N8641K · Substantial damage