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 MKC78FA033Accident · 1 fatalClosedBellanca 8KCAB · Council Bluffs, IAJun 2, 1978 · N57463 · DestroyedNTSB NYC78FA061Accident · 1 fatalClosedAmer Avco AA-5A · Guilford, NYJun 1, 1978 · N9879U · DestroyedNTSB MIA78FA092Accident · 2 fatalClosedPiper PA-28R · Hernando Beach, FLJun 1, 1978 · N2291M · DestroyedNTSB ANC78FA044Accident · 1 fatalClosedPiper PA-11 · King Salmon, AKJun 1, 1978 · N5504H · Substantial damageNTSB MKC78FA043Accident · 2 fatalClosedCessna 140 · Wolbach, NEMay 31, 1978 · N76011 · DestroyedNTSB LAX78FA052Accident · 1 fatalClosedPiper PA-11 · Tonopah, AZMay 30, 1978 · N5086H · DestroyedNTSB FTW78FA049Accident · 2 fatalClosedPiper PA-18 · Greenfield, OKMay 30, 1978 · N5428H · DestroyedNTSB ANC78FA040Accident · 3 fatalClosedCessna 180 · Dillingham, AKMay 30, 1978 · N39CF · 2 aircraft · DestroyedNTSB UNK78X0124Accident · 2 fatalClosedBellanca 14-19 · L Mrcds, NiueMay 29, 1978 · N8238R · DestroyedNTSB SEA78FTI21Accident · 2 fatalClosedBellanca 7KCAB · Pray, MTMay 29, 1978 · N8527 · DestroyedNTSB MKC78FA042Accident · 2 fatalClosedSwift GC-1B · Piedmont, MOMay 29, 1978 · N2302B · DestroyedNTSB MKC78FA041Accident · 4 fatalClosedBeech 35-B33 · Harris, MNMay 29, 1978 · N1320Z · DestroyedNTSB LAX78AA050Accident · 4 fatalClosedCessna 310 · Irvine, CAMay 29, 1978 · N3699D · DestroyedNTSB FTW78FA048Accident · 1 fatalClosedPiper PA-23 · Longdale, OKMay 29, 1978 · N5850Y · DestroyedNTSB DEN78FTM21Accident · 1 fatalClosedBede BD5 · Wendover, UTMay 29, 1978 · N549 · DestroyedNTSB CHI78FEE40Accident · 1 fatalClosedGrum Amer AA1-B · Antioch, ILMay 29, 1978 · N1505R · DestroyedNTSB LAX78FUG29Accident · 1 fatalClosedTruman Cnkl B8M · Adelanto, CAMay 28, 1978 · N64801 · DestroyedNTSB CHI78FA043Accident · 4 fatalClosedPiper PA-22 · Saint Helen, MIMay 28, 1978 · N3610Z · DestroyedNTSB CHI78FA042Accident · 1 fatalClosedCessna 150M · Waukesha, WIMay 28, 1978 · N9376U · DestroyedNTSB UNK78X0122Accident · 2 fatalClosedCessna 180C · Numazi, JAMay 27, 1978 · N3833 · DestroyedNTSB NYC78FA060Accident · 1 fatalClosedPiper PA-28 · Tannersville, PAMay 27, 1978 · N9041 · Substantial damageNTSB FTW78FA047Accident · 2 fatalClosedAero Comdr 690A · Calumet, OKMay 27, 1978 · N299F · DestroyedNTSB CHI78FA041Accident · 4 fatalClosedCessna T210M · Bloomer, WIMay 27, 1978 · N761GV · DestroyedNTSB MIA78FA091Accident · 3 fatalClosedMooney M20C · Jackson, ALMay 26, 1978 · N7813V · DestroyedNTSB MIA78DA117Accident · 2 fatalClosedBeech 65 · Missing AircraftMay 26, 1978 · N809Q · DestroyedNTSB IAD78FA068Accident · 1 fatalClosedTed Smith 601P · Bumpass, VAMay 26, 1978 · N10HF · Substantial damageNTSB SEA78FA033Accident · 1 fatalClosedHughes 269A · Vancouver, WAMay 25, 1978 · N8850F · DestroyedNTSB OAK78DVG41Accident · 1 fatalClosedStarduster SA-300 · Napa, CAMay 25, 1978 · N3195 · DestroyedNTSB LAX78FA049Accident · 1 fatalClosedPiper PA-32 · Redlands, CAMay 24, 1978 · N4189W · DestroyedNTSB FTW78FA046Accident · 1 fatalClosedCessna 182E · Dierks, ARMay 24, 1978 · N99LJ · DestroyedNTSB NYC78FA059Accident · 1 fatalClosedStol UC-1 · Champion, PAMay 23, 1978 · N9504U · Substantial damageNTSB NYC78FA058Accident · 1 fatalClosedPiper PA-31 · Fleetville, PAMay 23, 1978 · N9057Y · DestroyedNTSB LAX78FA043Accident · 1 fatalClosedPiper PA-18 · Upland, CAMay 22, 1978 · N1256A · DestroyedNTSB SEA78FA034Accident · 2 fatalClosedPiper PA-28 · Bremerton, WAMay 21, 1978 · N1914T · DestroyedNTSB SEA78FA031Accident · 1 fatalClosedBuhl Acft LA1 · Kimberly, IDMay 21, 1978 · N12106 · DestroyedNTSB MIA78FA086Accident · 1 fatalClosedCessna 150L · Ft.Lauderdale, FLMay 21, 1978 · N18131 · DestroyedNTSB LAX78FUG28Accident · 1 fatalClosedPiper PA-25 · Blythe, CAMay 21, 1978 · N7170Z · DestroyedNTSB LAX78FA048Accident · 2 fatalClosedCessna 337D · Santa Barbara, CAMay 21, 1978 · N86100 · DestroyedNTSB ANC78FA039Accident · 2 fatalClosedPiper PA-18 · Rocky Cove, AKMay 21, 1978 · N1158A · 2 aircraft · DestroyedNTSB NYC78FA057Accident · 1 fatalClosedBeech 95-B55 · Provincetown, MAMay 20, 1978 · N514Q · DestroyedNTSB NYC78FA056Accident · 2 fatalClosedPiper PA-22 · Northampton, PAMay 20, 1978 · N4656Z · DestroyedNTSB CHI78FA040Accident · 3 fatalClosedCessna 172M · Lapeer, MIMay 20, 1978 · N92572 · DestroyedNTSB MKC78FA039Accident · 1 fatalClosedCessna 402B · Alexandria, MNMay 19, 1978 · N87143 · DestroyedNTSB MKC78FA038Accident · 1 fatalClosedPiper PA-28 · Scott City, KSMay 19, 1978 · N9395W · DestroyedNTSB MIA78DA089Accident · 4 fatalClosedPiper PA-28 · Missing AircraftMay 19, 1978 · N47910 · DestroyedNTSB FTW78FRG43Accident · 2 fatalClosedBensen B-8M · Cotulla, TXMay 18, 1978 · N176E · DestroyedNTSB DCA78AA013Accident · 6 fatalClosedSud Avtn DA-20 · Memphis, TNMay 18, 1978 · N121GW · 2 aircraft · DestroyedNTSB NYC78FA055Accident · 1 fatalClosedBell 47G-3B · Wantagh, NYMay 17, 1978 · N602PD · DestroyedNTSB IAD78FA065Accident · 2 fatalClosedN-American SNJ-5 · Greensboro, NCMay 17, 1978 · N666MC · DestroyedNTSB SEA78FA032Accident · 1 fatalClosedBeech K35 · Wenatchee, WAMay 16, 1978 · N3064C · Destroyed