Fatal NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first

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 c.\"highestInjuryLevel\" = 'Fatal'
  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 NYC77FA022Accident · 2 fatalClosedPiper PA-23 · Danvers, MADec 21, 1976 · N66HR · DestroyedNTSB OAK77FA008Accident · 2 fatalClosedCessna 150G · Escalon, CADec 19, 1976 · N2630J · DestroyedNTSB IAD77FA016Accident · 2 fatalClosedBoeing A75 · Crofton, MDDec 19, 1976 · N63806 · Substantial damageNTSB DEN77FA015Accident · 3 fatalClosedGrum Amer AA-1 · Alder, CODec 19, 1976 · N5679L · DestroyedNTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MIDec 19, 1976 · N99258 · DestroyedNTSB OAK77FA007Accident · 4 fatalClosedBeech H-35 · Vacaville, CADec 18, 1976 · N5458D · DestroyedNTSB ANC77DA018Accident · 2 fatalClosedCessna A185F · Nondalton, AKDec 18, 1976 · N3464Y · DestroyedNTSB FTW77FA023Accident · 2 fatalClosedPiper PA-28 · El Paso, TXDec 17, 1976 · N7379W · DestroyedNTSB LAX77FA015Accident · 1 fatalClosedPiper PA-23 · Blythe, CADec 15, 1976 · N5590Y · DestroyedNTSB CHI77FEX06Accident · 1 fatalClosedCessna 150G · Patriot, INDec 15, 1976 · N2879S · DestroyedNTSB CHI77FA015Accident · 2 fatalClosedAeronca 7AC · Freedom, WIDec 15, 1976 · N2973E · Substantial damageNTSB FTW77FA022Accident · 1 fatalClosedAmerican AA1B · Oklahoma City, OKDec 14, 1976 · N6278L · DestroyedNTSB MIA77FA018Accident · 1 fatalClosedGrum Amer AA-1B · Dorado, PRDec 12, 1976 · N9954L · DestroyedNTSB DCA77AA006Accident · 3 fatalClosedDehavilland DHC-6 · Wildwood, NJDec 12, 1976 · N101AC · DestroyedNTSB OAK77FJA01Accident · 2 fatalClosedYankee AA1 · Wainiha, HIDec 11, 1976 · N5910L · DestroyedNTSB FTW77FA019Accident · 1 fatalClosedCessna 172H · Houston, TXDec 11, 1976 · N1455F · DestroyedNTSB DEN77FA013Accident · 1 fatalClosedCessna 120 · Sheridan, WYDec 11, 1976 · N90193 · DestroyedNTSB CHI77FEV06Accident · 1 fatalClosedHughes 369C · Pontiac, ILDec 11, 1976 · N9135F · Substantial damageNTSB CHI77FA014Accident · 3 fatalClosedCessna 172M · Vandalia, ILDec 11, 1976 · N64024 · DestroyedNTSB CHI77FA012Accident · 1 fatalClosedCessna 177 · Harrison, OHDec 11, 1976 · N29380 · DestroyedNTSB CHI76FA013Accident · 1 fatalClosedCessna 421B · Winchester, INDec 11, 1976 · N570C · DestroyedNTSB FTW77FA020Accident · 3 fatalClosedCessna 182E · Temple, TXDec 10, 1976 · N3091Y · DestroyedNTSB CHI77FA011Accident · 1 fatalClosedCessna 195 · Roanoke, INDec 10, 1976 · N169CB · DestroyedNTSB OAK77FA015Accident · 2 fatalClosedLockheed PV-1 · Yosemite, CADec 9, 1976 · N80BD · DestroyedNTSB MIA77FA017Accident · 2 fatalClosedCessna 150J · Opa-Locka, FLDec 7, 1976 · N60153 · DestroyedNTSB MIA77FA016Accident · 5 fatalClosedPiper PA-23 · Clewiston, FLDec 6, 1976 · N4240P · DestroyedNTSB MKC77FA007Accident · 3 fatalClosedPiper PA-24 · Kimball, NEDec 5, 1976 · N6973P · DestroyedNTSB LAX77FA014Accident · 5 fatalClosedAerostar 601P · Costa Mesa, CADec 5, 1976 · N7485S · DestroyedNTSB FTW77FA018Accident · 2 fatalClosedCessna 310 · Bronte, TXDec 5, 1976 · N5204A · DestroyedNTSB NYC77FA019Accident · 5 fatalClosedPiper PA-34 · Forked River, NJDec 4, 1976 · N15698 · DestroyedNTSB NYC77FA018Accident · 5 fatalClosedPiper PA-31 · Grand View, NYDec 4, 1976 · N59825 · 2 aircraft · DestroyedNTSB LAX77FUJ10Accident · 1 fatalClosedScorpion TOO · Corona, CADec 4, 1976 · N21DD · DestroyedNTSB LAX77FA016Accident · 2 fatalClosedPiper PA-28R · Scottsdale, AZDec 4, 1976 · N298CC · DestroyedNTSB CHI77FA010Accident · 1 fatalClosedCessna 150E · Depere, WIDec 4, 1976 · N3526J · DestroyedNTSB MIA77DA015Accident · 2 fatalClosedCessna 337G · Summer Haven, FLDec 1, 1976 · N72459 · DestroyedNTSB DEN77FA011Accident · 2 fatalClosedPiper PA-32 · Denver, CONov 29, 1976 · N4125R · Substantial damageNTSB ANC77FA012Accident · 2 fatalClosedBeech E90 · Tok, AKNov 29, 1976 · N6843S · DestroyedNTSB MIA77FA014Accident · 1 fatalClosedPiper J3C · Copeland, FLNov 28, 1976 · N2228M · DestroyedNTSB LAX77FA012Accident · 1 fatalClosedBell 47J · Glen Ivy, CANov 28, 1976 · N62883 · DestroyedNTSB IAD77FA015Accident · 4 fatalClosedCessna 210 · Oxford, NCNov 28, 1976 · N360WL · DestroyedNTSB IAD77FA014Accident · 4 fatalClosedPiper PA-23 · Lexington, KYNov 28, 1976 · N4423P · DestroyedNTSB NYC77FA016Accident · 3 fatalClosedPiper PA-28 · Westhampton, NYNov 27, 1976 · N75233 · DestroyedNTSB MIA77FA013Accident · 2 fatalClosedPiper PA-28R · Tallahassee, FLNov 27, 1976 · N4615J · DestroyedNTSB MIA77FA012Accident · 2 fatalClosedCessna 182P · Savannah, GANov 26, 1976 · N21311 · DestroyedNTSB DEN77FA012Accident · 2 fatalClosedPiper PA-28 · Farmington, NMNov 26, 1976 · N4208F · DestroyedNTSB CHI77FA008Accident · 2 fatalClosedCessna 310P · Muskegon, MINov 26, 1976 · N246BS · DestroyedNTSB SEA77FA007Accident · 4 fatalClosedPiper PA-28R · Kimberly, ORNov 25, 1976 · N15634 · DestroyedNTSB FTW77FA017Accident · 1 fatalClosedErco 415-C · Little Rock, ARNov 25, 1976 · N99324 · DestroyedNTSB ANC77DA011Accident · 1 fatalClosedCessna 206 · Kotzebue, AKNov 24, 1976 · N35593 · No damageNTSB NYC77FA015Accident · 1 fatalClosedCessna 150L · Sherburne, VTNov 23, 1976 · N5376Q · Destroyed