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 OAK78DA032Accident · 3 fatalClosedCessna 182Q · Weber Peak, CAMay 16, 1978 · N735FR · DestroyedNTSB NYC78FA054Accident · 4 fatalClosedCessna 402B · Trenton, MEMay 16, 1978 · N98720 · DestroyedNTSB DEN78FA044Accident · 4 fatalClosedBeech 36 · Granite, COMay 14, 1978 · N7452N · DestroyedNTSB MIA78FA085Accident · 1 fatalClosedAmer Avco AA-1B · Clearwater, FLMay 13, 1978 · N6326L · DestroyedNTSB LAX78FUG26Accident · 1 fatalClosedSchleicher ASW-12 · Hemet, CAMay 13, 1978 · N134Z · DestroyedNTSB IAD78FA061Accident · 1 fatalClosedBeech C23 · The Plains, VAMay 13, 1978 · N24617 · DestroyedNTSB DEN78FA042Accident · 2 fatalClosedBellanca 8GCBC · Nunn, COMay 13, 1978 · N8658V · Substantial damageNTSB CHI78FA039Accident · 3 fatalClosedPiper PA-31T · Pellston, MIMay 13, 1978 · N82271 · DestroyedNTSB MKC78FA037Accident · 2 fatalClosedBeech F35 · East Prairie, MOMay 12, 1978 · N7365B · DestroyedNTSB MIA78FLD44Accident · 1 fatalClosedMaule M5220C · Holopaw, FLMay 12, 1978 · N62012 · DestroyedNTSB MIA78FA084Accident · 3 fatalClosedPiper PA-23 · Oldsmar, FLMay 12, 1978 · N4569P · DestroyedNTSB IAD78FA062Accident · 1 fatalClosedCessna 182Q · Linville, NCMay 12, 1978 · N735MB · DestroyedNTSB NYC78FA052Accident · 3 fatalClosedPiper PA-32 · Lawrence, MAMay 11, 1978 · N3893W · 2 aircraft · DestroyedNTSB LAX78FA047Accident · 1 fatalClosedVolpar C-45H · Lake Elsinore, CAMay 11, 1978 · N63H · DestroyedNTSB ANC78FA037Accident · 1 fatalClosedPiper PA-12 · Anchorage, AKMay 11, 1978 · N3465M · Substantial damageNTSB FTW78FRG39Accident · 3 fatalClosedDehaviland DHC-3 · Del Rio, TXMay 10, 1978 · N5370G · DestroyedNTSB FTW78FQG29Accident · 1 fatalClosedHughes 369HS · Brownfield, TXMay 8, 1978 · N9066F · DestroyedNTSB DCA78AA012Accident · 3 fatalClosedBoeing 727 · Pensacola, FLMay 8, 1978 · N4744NA · Substantial damageNTSB SEA78FA028Accident · 1 fatalClosedCessna 210G · Tumwater, WAMay 7, 1978 · N5892F · DestroyedNTSB NYC78FA048Accident · 2 fatalClosedAerospatle 330J · Atlantic City (Atlantic Ocean)May 7, 1978 · N49496 · Substantial damageNTSB MIA78FA078Accident · 3 fatalClosedPiper PA-28 · Jekyll Island, GAMay 7, 1978 · N47638 · DestroyedNTSB FTW78FA044Accident · 4 fatalClosedCessna 182C · Dobbin, TXMay 7, 1978 · N8809T · DestroyedNTSB MIA78FA077Accident · 2 fatalClosedHamilton T-28A · Huntsville, ALMay 6, 1978 · N3314G · DestroyedNTSB SEA78FA027Accident · 2 fatalClosedBeech 35C33 · Vancouver, WAMay 5, 1978 · N7948M · DestroyedNTSB LAX78FA046Accident · 1 fatalClosedCessna T210M · Salome, AZMay 5, 1978 · N761EK · DestroyedNTSB DEN78FA043Accident · 2 fatalClosedBellanca BL-J4 · Carrizozo, NMMay 5, 1978 · N8774R · DestroyedNTSB DEN78FA040Accident · 4 fatalClosedBeech D50C · Wheatland, WYMay 4, 1978 · N320Z · DestroyedNTSB OAK78FVG29Accident · 1 fatalClosedBoeing A-75N1 · Robbins, CAMay 3, 1978 · N49747 · Substantial damageNTSB LAX78FUJ51Accident · 1 fatalClosedKr-1 · Yuma, AZMay 3, 1978 · N25EA · DestroyedNTSB CHI78FA038Accident · 4 fatalClosedBeech 35 · Middletown, OHMay 3, 1978 · N3290V · DestroyedNTSB NYC78FA047Accident · 2 fatalClosedCessna 150 · Mantoloking, NJMay 2, 1978 · N18669 · DestroyedNTSB MKC78FA036Accident · 1 fatalClosedBeech UC45J · Spiritwood, NDMay 2, 1978 · N94460 · DestroyedNTSB MIA78FA075Accident · 3 fatalClosedLockheed 18-56 · Durbin, FLMay 1, 1978 · N9051 · DestroyedNTSB LAX78FA045Accident · 1 fatalClosedBeech S35 · Palmdale, CAMay 1, 1978 · N5851S · DestroyedNTSB CHI78FA037Accident · 1 fatalClosedCessna 182G · Berrien Spring, MIMay 1, 1978 · N2319R · DestroyedNTSB MIA78FA076Accident · 2 fatalClosedBeech D-18S · Ocala, FLApr 30, 1978 · N800WM · DestroyedNTSB MIA78DA083Accident · 1 fatalClosedCessna 172 · Missing AircraftApr 30, 1978 · N1GH · DestroyedNTSB ANC78FA034Accident · 1 fatalClosedPiper PA-18 · Homer, AKApr 30, 1978 · N13973 · Substantial damageNTSB ANC78FA033Accident · 2 fatalClosedCrosswinds PA-18 · Birchwood, AKApr 30, 1978 · N3749Z · DestroyedNTSB ANC78DA035Accident · 1 fatalClosedMaule M4210C · Bethel, AKApr 30, 1978 · N9842M · Substantial damageNTSB OAK78FA030Accident · 1 fatalClosedBeech C23 · Independence, CAApr 29, 1978 · N9147S · Substantial damageNTSB NYC78FHA21Accident · 1 fatalClosedBensen B8M · Pittstown, NJApr 29, 1978 · N5575 · DestroyedNTSB NYC78FA046Accident · 1 fatalClosedPiper PA-28 · Danbury, CTApr 29, 1978 · N7126W · DestroyedNTSB NYC78FA045Accident · 1 fatalClosedChampion 7ECA · Shenango Twp, PAApr 29, 1978 · N2522F · Substantial damageNTSB MKC78FA035Accident · 2 fatalClosedVultee BT-13 · Augusta, KSApr 29, 1978 · N64470 · 2 aircraft · DestroyedNTSB MKC78FA034Accident · 5 fatalClosedBeech S-35 · Audubon, IAApr 29, 1978 · N7971K · DestroyedNTSB LAX78FUQ23Accident · 1 fatalClosedMakurat 5-BX · Lompoc, CAApr 29, 1978 · N56RM · DestroyedNTSB SEA78FYE20Accident · 1 fatalClosedBensen G-1D · Tacoma, WAApr 28, 1978 · N777GD · DestroyedNTSB OAK78FVG26Accident · 1 fatalClosedPiper PA-28R · Alturas, CAApr 28, 1978 · N9653C · DestroyedNTSB OAK78FA038Accident · 6 fatalClosedCessna T210H · Reno, NVApr 28, 1978 · N2211R · Destroyed