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 MIA79FA007Accident · 2 fatalClosedPiper PA-34 · Titusville, FLOct 30, 1978 · N1058U · DestroyedNTSB MIA79FA005Accident · 3 fatalClosedBeech 95 · Madison, ALOct 30, 1978 · N2753Y · DestroyedNTSB LAX79FA010Accident · 2 fatalClosedPiper PA-32 · Mojave, CAOct 30, 1978 · N400EW · DestroyedNTSB OAK79FA006Accident · 2 fatalClosedCessna T210G · Groveland, CAOct 29, 1978 · N210CC · DestroyedNTSB MIA79FA004Accident · 1 fatalClosedGreat Lakes 2T-1A2 · Guntersville, ALOct 29, 1978 · N3809 · DestroyedNTSB FTW79DA008Accident · 1 fatalClosedMooney M18LA · Wilson, TXOct 29, 1978 · N4086 · DestroyedNTSB SEA79FA010Accident · 3 fatalClosedPiper PA-20 · Joseph, OROct 28, 1978 · N2411A · DestroyedNTSB SEA79FA007Accident · 1 fatalClosedSchweizer SGS232 · Hailey, IDOct 28, 1978 · N5753S · DestroyedNTSB NYC79FA006Accident · 1 fatalClosedPiper PA-38 · West Townshend, VTOct 28, 1978 · N9372T · DestroyedNTSB MIA79FKJ09Accident · 1 fatalClosedAmateur Mini · Bessemer, ALOct 28, 1978 · N152CM · DestroyedNTSB LAX79FA009Accident · 2 fatalClosedCessna TU206G · Chula Vista, CAOct 28, 1978 · N756XC · DestroyedNTSB IAD79FKW01Accident · 2 fatalClosedCessna 150G · Evensville, TNOct 28, 1978 · N3637J · DestroyedNTSB IAD79FA006Accident · 1 fatalClosedCessna 120 · Covington, TNOct 28, 1978 · N1811V · Substantial damageNTSB NYC79FA005Accident · 1 fatalClosedPiper PA-28 · Great Bend, PAOct 27, 1978 · N5622W · DestroyedNTSB IAD79FA005Accident · 2 fatalClosedPiper PA-28 · Harpers Ferry, WVOct 27, 1978 · N38463 · DestroyedNTSB CHI79FA012Accident · 1 fatalClosedCessna 172M · Gallipolis, OHOct 27, 1978 · N5131H · 2 aircraft · DestroyedNTSB LAX79FA007Accident · 2 fatalClosedCessna 182P · Whiteriver, AZOct 25, 1978 · N96060 · DestroyedNTSB CHI79FA011Accident · 1 fatalClosedPiper PA-24 · Ashton, ILOct 25, 1978 · N8666P · Substantial damageNTSB FTW79FPJ01Accident · 1 fatalClosedPiper PA-25 · Hydro, OKOct 24, 1978 · N8845L · DestroyedNTSB FTW79FA007Accident · 2 fatalClosedMooney M20E · Texarkana, TXOct 24, 1978 · N9093V · DestroyedNTSB DEN79FA005Accident · 4 fatalClosedBeech 65-80 · Torreon, NMOct 24, 1978 · N886G · DestroyedNTSB OAK79FA004Accident · 1 fatalClosedPiper PA-28 · Galt, CAOct 23, 1978 · N8472F · DestroyedNTSB NYC79FGT02Accident · 1 fatalClosedGyrocopter JW-1 · Smoketown, PAOct 22, 1978 · N4280 · Substantial damageNTSB CHI79FEX02Accident · 1 fatalClosedCassutt LSS · Cloverdale, INOct 22, 1978 · N7133 · DestroyedNTSB SEA79FA006Accident · 4 fatalClosedGrum Amer AA-5B · Roche Harbor, WAOct 21, 1978 · N28924 · DestroyedNTSB SEA79FA005Accident · 5 fatalClosedRolladn SCH LS-1-F · Ephrata, WAOct 21, 1978 · N61MP · 2 aircraft · DestroyedNTSB CHI79FEC01Accident · 2 fatalClosedNord Stampe SV4C · Wixom, MIOct 21, 1978 · N671SV · DestroyedNTSB OAK79FA003Accident · 1 fatalClosedCessna T-210L · San Leandro, CAOct 20, 1978 · N5148Q · DestroyedNTSB LAX79FA006Accident · 1 fatalClosedPiper PA32RT · Green Vly Lk, CAOct 20, 1978 · N36792 · DestroyedNTSB LAX79FA005Accident · 3 fatalClosedBeech 35 · Williams, AZOct 20, 1978 · N2734V · DestroyedNTSB DEN79FA004Accident · 1 fatalClosedCessna 172 · Provo, UTOct 20, 1978 · N1333Y · DestroyedNTSB MIA79FA002Accident · 1 fatalClosedCessna T210M · Plymouth, FLOct 19, 1978 · N6827B · DestroyedNTSB LAX79FA004Accident · 1 fatalClosedLear Jet 24 · Lancaster, CAOct 17, 1978 · N123RE · DestroyedNTSB CHI79FA009Accident · 4 fatalClosedPiper PA-22 · Tell City, INOct 17, 1978 · N3427A · 2 aircraft · DestroyedNTSB OAK79FVG02Accident · 2 fatalClosedNord Stampe SV4C · Shingle Spgs, CAOct 15, 1978 · N515T · DestroyedNTSB FTW79FA004Accident · 2 fatalClosedCessna 172K · New Orleans, LAOct 15, 1978 · N7500G · DestroyedNTSB ANC79FA006Accident · 1 fatalClosedCessna 185 · Ketchikan, AKOct 15, 1978 · N70269 · DestroyedNTSB LAX79FA003Accident · 2 fatalClosedRockwell 112A · Yucca Valley, CAOct 14, 1978 · N1396J · DestroyedNTSB SEA79FA003Accident · 2 fatalClosedPiper PA-18S · Bozeman, MTOct 13, 1978 · N302T · DestroyedNTSB ANC79FA004Accident · 1 fatalClosedDehavnd Can DHC-6 · Barrow, AKOct 13, 1978 · N4048B · Substantial damageNTSB OAK79FA002Accident · 2 fatalClosedBellanca 8KCAB · Palo Alto, CAOct 12, 1978 · N88321 · DestroyedNTSB NYC79FA004Accident · 2 fatalClosedEnstrom F-28A · Bakertown, PAOct 12, 1978 · N257Q · DestroyedNTSB DEN79FA003Accident · 1 fatalClosedCessna 150J · Eunice, NMOct 12, 1978 · N51042 · DestroyedNTSB OAK79DA001Accident · 1 fatalClosedCessna 182 · Monterey, CAOct 11, 1978 · N759TU · DestroyedNTSB NYC79FA003Accident · 2 fatalClosedPiper PA-28R · Parsippany, NJOct 11, 1978 · N1690H · DestroyedNTSB CHI79FA006Accident · 2 fatalClosedPiper PA-24 · Baraboo, WIOct 10, 1978 · N5696P · DestroyedNTSB FTW79FA001Accident · 1 fatalClosedCessna 172 · Bridgeport, TXOct 8, 1978 · N6018R · DestroyedNTSB ANC79FA002Accident · 2 fatalClosedBell 205A-1 · Kenai, AKOct 8, 1978 · N2215W · DestroyedNTSB SEA79FA002Accident · 1 fatalClosedPiper PA-11 · Nashua, MTOct 7, 1978 · N4838M · DestroyedNTSB NYC79FA002Accident · 1 fatalClosedBoeing E-75 · East Gramby Ct, CTOct 7, 1978 · N1395V · Substantial damage