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 FTW78FQG22Accident · 1 fatalClosedSnow S-2R · Friona, TXMar 26, 1978 · N5605X · DestroyedNTSB DEN78FA034Accident · 6 fatalClosedCessna 411 · Santa Fe, NMMar 26, 1978 · N417DR · DestroyedNTSB MIA78DA080Accident · 2 fatalClosedAero Comdr 680 · Missing AircraftMar 25, 1978 · N128C · DestroyedNTSB CHI78FA031Accident · 3 fatalClosedBeech H18 · Centreville, ILMar 25, 1978 · N58JM · DestroyedNTSB OAK78FA024Accident · 2 fatalClosedCessna 150M · Carson City, NVMar 24, 1978 · N714BU · DestroyedNTSB NYC78FA036Accident · 1 fatalClosedBeech G35 · Philadelphia, PAMar 24, 1978 · N257A · DestroyedNTSB MIA77FA055Accident · 1 fatalClosedBensen B-8M · Homestead, FLMar 24, 1978 · N1559 · Substantial damageNTSB FTW78FA035Accident · 2 fatalClosedBell 47G-4A · Morgan City, LAMar 23, 1978 · N8182J · DestroyedNTSB LAX78FA037Accident · 6 fatalClosedCessna T207A · Riverside, CAMar 22, 1978 · N7354U · DestroyedNTSB OAK78FA023Accident · 2 fatalClosedGrumman AA-5A · Red Bluff, CAMar 21, 1978 · N9740U · DestroyedNTSB NYC78FA035Accident · 4 fatalClosedBeech S35 · Carrabassett, MEMar 19, 1978 · N5789K · DestroyedNTSB NYC78FA034Accident · 5 fatalClosedBeech B95A · Onchiota, NYMar 19, 1978 · N28885 · DestroyedNTSB MKC78FA029Accident · 2 fatalClosedCessna 172 · Leawood, KSMar 19, 1978 · N6892A · DestroyedNTSB FTW78FA034Accident · 2 fatalClosedBeech 65-90 · Houston, TXMar 19, 1978 · N2MF · DestroyedNTSB SEA78FA023Accident · 4 fatalClosedPiper PA-28 · Milton Frwtr, ORMar 18, 1978 · N1844T · DestroyedNTSB IAD78FA051Accident · 3 fatalClosedPiper PA-28 · Wilmington, DEMar 18, 1978 · N55645 · DestroyedNTSB DEN78FTC17Accident · 1 fatalClosedCessna 172 · Alta, WYMar 18, 1978 · N25435 · DestroyedNTSB UNK78X0110Accident · 2 fatalClosedBeech 65 · Angmagslk, GreenlandMar 17, 1978 · N8431N · DestroyedNTSB IAD78FA052Accident · 2 fatalClosedCessna 172E · Leitchfield, KYMar 17, 1978 · N5615T · DestroyedNTSB IAD78FA049Accident · 4 fatalClosedCessna 177 · Maryville, TNMar 17, 1978 · N3379T · DestroyedNTSB CHI78FEV22Accident · 1 fatalClosedHughes 500D · Ellisville, ILMar 17, 1978 · N8393F · Substantial damageNTSB CHI78FA029Accident · 1 fatalClosedGrum Amer AA5-B · Sandusky, OHMar 17, 1978 · N1552R · DestroyedNTSB SEA78FA022Accident · 3 fatalClosedCessna 172 · Lynden, WAMar 16, 1978 · C-GHUS · 2 aircraft · DestroyedNTSB MIA78FA054Accident · 1 fatalClosedPiper PA-31 · Leesburg, FLMar 16, 1978 · N7488L · DestroyedNTSB NYC78FA033Accident · 2 fatalClosedPiper PA-28 · Sandgate, VTMar 15, 1978 · N9006K · DestroyedNTSB MKC78FA028Accident · 4 fatalClosedPiper PA-32R · Belfield, NDMar 15, 1978 · N75089 · DestroyedNTSB FTW78FA032Accident · 1 fatalClosedBell 47G · Eola, TXMar 15, 1978 · N967B · DestroyedNTSB MIA78FA053Accident · 1 fatalClosedLake LA-4 · Pierson, FLMar 14, 1978 · N2038L · DestroyedNTSB DEN78FA033Accident · 1 fatalClosedCessna 152 · Parker, COMar 14, 1978 · N757CP · DestroyedNTSB CHI79FA028Accident · 1 fatalClosedPiper PA-32R · Rock Falls, ILMar 14, 1978 · N7299C · DestroyedNTSB CHI78FA027Accident · 2 fatalClosedBeech D18 · Whitelake, MIMar 14, 1978 · N427Q · DestroyedNTSB ANC78FA025Accident · 1 fatalClosedPiper PA-12 · Kotzebue, AKMar 13, 1978 · N3383M · Substantial damageNTSB SEA78FYE12Accident · 1 fatalClosedBerg Sprite SW1 · Lakewood, WAMar 12, 1978 · N9756 · DestroyedNTSB NYC78FA032Accident · 1 fatalClosedPiper PA-23 · Connellsville, PAMar 12, 1978 · N40355 · DestroyedNTSB MKC78FA027Accident · 1 fatalClosedPiper PA-22 · Rapid City, SDMar 12, 1978 · N9820D · Substantial damageNTSB LAX78FA035Accident · 2 fatalClosedPiper PA-28 · Frazier Park, CAMar 12, 1978 · N6594W · DestroyedNTSB LAX78FA034Accident · 3 fatalClosedCessna 182P · Benson, AZMar 12, 1978 · N6955M · DestroyedNTSB CHI78FA025Accident · 3 fatalClosedCessna T210M · Beecher, ILMar 12, 1978 · N761EJ · DestroyedNTSB SEA78FA021Accident · 1 fatalClosedPiper PA-28 · Springdale, WAMar 11, 1978 · N32085 · DestroyedNTSB LAX78FUQ19Accident · 1 fatalClosedAmateur Baby L · Pacoima, CAMar 11, 1978 · N741Z · DestroyedNTSB LAX78FA038Accident · 1 fatalClosedCessna 150L · Huntington Bch, CAMar 11, 1978 · N114NS · 2 aircraft · DestroyedNTSB LAX78FA036Accident · 2 fatalClosedPiper PA-28 · Mormon Lake, AZMar 11, 1978 · N9028W · DestroyedNTSB FTW78FA033Accident · 4 fatalClosedPiper PA-28 · Hiwasse, ARMar 11, 1978 · N4513X · DestroyedNTSB OAK78FA022Accident · 5 fatalClosedCessna 210L · Mammoth Lakes, CAMar 10, 1978 · N210JL · DestroyedNTSB IAD78FA050Accident · 2 fatalClosedPiper PA-28 · Melfa, VAMar 10, 1978 · N9519K · DestroyedNTSB DEN78FAO32Accident · 5 fatalClosedCessna T210L · Woodland Park, COMar 10, 1978 · N22443 · DestroyedNTSB DEN78FA031Accident · 3 fatalClosedBeech S35 · Aurora, COMar 10, 1978 · N5818S · Substantial damageNTSB ANC78FA024Accident · 1 fatalClosedBellanca 7GCBC · Anchorage, AKMar 10, 1978 · N57452 · Substantial damageNTSB MKC78FA026Accident · 2 fatalClosedCessna 172 · Memphis, MOMar 9, 1978 · N7592X · DestroyedNTSB IAD78FA048Accident · 3 fatalClosedAero Comdr 681 · Greenup, KYMar 8, 1978 · N5NP · Destroyed