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 CHI78FEV08Accident · 1 fatalClosedCessna 150H · Carmi, ILNov 22, 1977 · N18636 · DestroyedNTSB OAK78FA005Accident · 4 fatalClosedBeech E35 · Willows, CANov 21, 1977 · N3274C · DestroyedNTSB FTW78FA012Accident · 2 fatalClosedPiper PA-18 · Waldron, ARNov 21, 1977 · N83441 · DestroyedNTSB ANC78FA003Accident · 2 fatalClosedBrittnorman BN2A-8 · Missing AircraftNov 21, 1977 · N36MN · DestroyedNTSB MIA78FA014Accident · 2 fatalClosedCessna 150M · Richland, FLNov 20, 1977 · N7586U · DestroyedNTSB CHI78FA010Accident · 1 fatalClosedPiper PA-28R · Ladoga, INNov 19, 1977 · N3095R · DestroyedNTSB ANC78FAD01Accident · 1 fatalClosedCessna 150 · Goddard, AKNov 19, 1977 · N63640 · Substantial damageNTSB CHI788A011Accident · 5 fatalClosedBeech P35 · New Salem, INNov 17, 1977 · N9958Y · DestroyedNTSB MIA78FA013Accident · 7 fatalClosedCessna 441 · Greensboro, ALNov 15, 1977 · N9971G · DestroyedNTSB LAX78FA007Accident · 3 fatalClosedPiper PA-28 · Newport Beach, CANov 15, 1977 · N15904 · 2 aircraft · Substantial damageNTSB SEA78FA008Accident · 4 fatalClosedCessna 172M · Newport, WANov 13, 1977 · C-GSKO · DestroyedNTSB LAX78FA005Accident · 2 fatalClosedBellanca 17-30 · Fullerton, CANov 13, 1977 · N6572V · DestroyedNTSB DEN78FA007Accident · 2 fatalClosedStinson 108-2 · Hope, NMNov 13, 1977 · N178C · DestroyedNTSB NYC78FA006Accident · 2 fatalClosedPorterfield 35W · Ft Devens, MANov 12, 1977 · N19448 · DestroyedNTSB OAK78FVW03Accident · 1 fatalClosedJeanie Teenie · Boulder City, NVNov 11, 1977 · N5240 · DestroyedNTSB ANC78FA002Accident · 2 fatalClosedMooney M-20C · Northway, AKNov 9, 1977 · N6709N · Substantial damageNTSB IAD78FA011Accident · 2 fatalClosedPiper PA-32 · Emmitsburg, MDNov 7, 1977 · N3347W · DestroyedNTSB FTW78FA011Accident · 3 fatalClosedN.American NA-265 · New Orleans, LANov 7, 1977 · N77AP · DestroyedNTSB DEN78FA006Accident · 2 fatalClosedCessna 182P · Kemmerer, WYNov 7, 1977 · N7368S · DestroyedNTSB CHI78FA008Accident · 1 fatalClosedCessna 310P · Eagle River, WINov 7, 1977 · N5861M · DestroyedNTSB NYC78FA007Accident · 3 fatalClosedCessna 180 · Jay, VTNov 6, 1977 · N9298C · DestroyedNTSB CHI78FA007Accident · 1 fatalClosedCessna 310Q · Watertown, WINov 6, 1977 · N7701Q · DestroyedNTSB NYC78FA005Accident · 5 fatalClosedPiper PA-23 · Claryville, NYNov 5, 1977 · N14277 · DestroyedNTSB MIA78RA012Accident · 6 fatalClosedCessna 310Q · Freeport, Burkina FasoNov 5, 1977 · N555RM · DestroyedNTSB MIA78FA011Accident · 1 fatalClosedCessna 150J · Sugarloaf Key, FLNov 5, 1977 · N51027 · DestroyedNTSB SEA78FA007Accident · 1 fatalClosedPiper PA-28 · Gales Creek, ORNov 4, 1977 · N2710Q · DestroyedNTSB OAK78FA004Accident · 4 fatalClosedCessna 172K · Willits, CANov 4, 1977 · N7330G · DestroyedNTSB OAK78FA003Accident · 2 fatalClosedPiper PA-28R · Las Vegas, NVNov 4, 1977 · N5690V · DestroyedNTSB MKC78FA007Accident · 1 fatalClosedCessna 310 · Kansas City, KSNov 4, 1977 · N777BB · DestroyedNTSB CHI78FA006Accident · 2 fatalClosedCessna 150G · Columbus, OHNov 4, 1977 · N6221S · DestroyedNTSB FTW78FPJ05Accident · 1 fatalClosedCessna A188B · Thomas, OKNov 3, 1977 · N4833R · DestroyedNTSB MKC78FA006Accident · 1 fatalClosedCessna 210L · Odessa, MONov 1, 1977 · N29161 · DestroyedNTSB MIA78FA010Accident · 2 fatalClosedCessna 150L · Inverness, FLOct 30, 1977 · N18732 · DestroyedNTSB LAX78FA003Accident · 1 fatalClosedCessna 182J · Buckeye, AZOct 30, 1977 · N3531F · DestroyedNTSB IAD78FA009Accident · 1 fatalClosedCessna 150L · Ash, NCOct 30, 1977 · N16175 · DestroyedNTSB CHI78FA005Accident · 4 fatalClosedBeech P35 · Francesville, INOct 30, 1977 · N1555S · 2 aircraft · DestroyedNTSB NYC78FA004Accident · 2 fatalClosedWaco UPF-7 · Palmyra, NYOct 29, 1977 · N32140 · DestroyedNTSB FTW78FA008Accident · 1 fatalClosedSchweizer 1-26B · Cedar Hill, TXOct 29, 1977 · N10368 · DestroyedNTSB CHI78FA004Accident · 5 fatalClosedCessna 180 · Bidwell, OHOct 29, 1977 · N51GC · DestroyedNTSB MIA77FA009Accident · 2 fatalClosedCessna 182K · Atlanta, GAOct 28, 1977 · N2842R · DestroyedNTSB DEN78FA005Accident · 1 fatalClosedCessna 150G · Kiowa, COOct 28, 1977 · N3373J · DestroyedNTSB MIA78FKQ03Accident · 1 fatalClosedThrush S2R · Poplarville, MSOct 27, 1977 · N8921Q · DestroyedNTSB MIA78FA008Accident · 2 fatalClosedLet-Np-K L-13 · Pensacola, FLOct 27, 1977 · N779 · DestroyedNTSB IAD78FA008Accident · 1 fatalClosedPiper PA-23 · Morganton, NCOct 27, 1977 · N5250Y · DestroyedNTSB SEA78FA005Accident · 2 fatalClosedPiper PA-32 · Troutdale, OROct 26, 1977 · N1230W · DestroyedNTSB NYC78FA002Accident · 1 fatalClosedPiper PA-28 · Randolph, NJOct 26, 1977 · N3QA · DestroyedNTSB NYC78FA001Accident · 4 fatalClosedMooney M20J · Morristown, VTOct 26, 1977 · N201GT · Substantial damageNTSB OAK78FVW01Accident · 2 fatalClosedHoward DGA-6 · Tonopah, NVOct 25, 1977 · N273Y · DestroyedNTSB MKC78FA005Accident · 1 fatalClosedPiper PA-28 · Lamar, MOOct 25, 1977 · N7983N · DestroyedNTSB FTW78FPJ04Accident · 1 fatalClosedPiper PA-36 · Garber, OKOct 25, 1977 · N57782 · Destroyed