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 SEA77FYM32Accident · 1 fatalClosedCessna 150M · Independence, ORMay 20, 1977 · N704BK · DestroyedNTSB MKC77FA023Accident · 4 fatalClosedPiper PA-28 · White Bear Lke, MNMay 20, 1977 · N55644 · DestroyedNTSB FTW77FA056Accident · 4 fatalClosedCessna 310N · Amarillo, TXMay 20, 1977 · N4153Q · DestroyedNTSB FTW77FA055Accident · 1 fatalClosedBell 47J · Dallas, TXMay 20, 1977 · N6736D · DestroyedNTSB OAK77FA032Accident · 4 fatalClosedCessna 172M · Lahaina Maui, HIMay 19, 1977 · N20548 · DestroyedNTSB CHI77FA043Accident · 2 fatalClosedPiper PA-23 · Norwalk, OHMay 19, 1977 · N124MW · DestroyedNTSB CHI77FEK19Accident · 1 fatalClosedSchweizer 1-35 · Derwent, OHMay 18, 1977 · N34291 · Substantial damageNTSB SEA77FA032Accident · 4 fatalClosedPiper PA-23 · Ashland, ORMay 16, 1977 · N2175P · DestroyedNTSB DCA77AA006Accident · 4 fatalClosedSikorsky S-61L · New York, NYMay 16, 1977 · N619PA · Substantial damageNTSB FTW77FFA22Accident · 1 fatalClosedBoeing E75N1 · Beaumont, TXMay 15, 1977 · N4575N · DestroyedNTSB FTW77FA054Accident · 1 fatalClosedRyan ST-3KR · San Angelo, TXMay 15, 1977 · N47432 · DestroyedNTSB DEN77FA043Accident · 1 fatalClosedCessna 182B · Trinidad, COMay 15, 1977 · N2454G · DestroyedNTSB LAX77FA042Accident · 4 fatalClosedCessna 172 · Dana Point, CAMay 14, 1977 · N9213H · DestroyedNTSB ANC77FA043Accident · 1 fatalClosedBeech C-23 · Dan Creek, AKMay 13, 1977 · N1931L · DestroyedNTSB IAD77FA040Accident · 1 fatalClosedPiper PA-28 · Alexandria, VAMay 12, 1977 · N5382L · Substantial damageNTSB FTW77FF053Accident · 2 fatalClosedCessna 170A · Marion, ARMay 11, 1977 · N9960A · DestroyedNTSB OAK77FA031Accident · 1 fatalClosedCessna 150L · Gilroy, CAMay 9, 1977 · N19703 · DestroyedNTSB MIA77FKT38Accident · 2 fatalClosedPiccard AX-6 · Miami, FLMay 7, 1977 · N75US · DestroyedNTSB OAK77FA030Accident · 1 fatalClosedCessna 320C · Wells, NVMay 6, 1977 · N3044T · DestroyedNTSB IAD77FA039Accident · 3 fatalClosedPiper PA-31 · Taplin, WVMay 6, 1977 · N7439L · DestroyedNTSB DEN77FA041Accident · 2 fatalClosedPiper PA-34 · Bigtrails, WYMay 6, 1977 · N4948F · DestroyedNTSB LAX77FA041Accident · 4 fatalClosedBeech 35 · Huntington Bch, CAMay 5, 1977 · N2826V · DestroyedNTSB SEA77FA031Accident · 2 fatalClosedCessna 182 · Orofino, IDMay 4, 1977 · N4052D · DestroyedNTSB DEN77FA040Accident · 4 fatalClosedBeech J35 · Lander, WYMay 4, 1977 · N83W · DestroyedNTSB NYC77FA055Accident · 2 fatalClosedGR Lakes 2T1A-2 · Milford, NJMay 3, 1977 · N5940L · DestroyedNTSB SEA77FA030Accident · 1 fatalClosedBeech 58 · Vancouver, WAMay 2, 1977 · N83BB · Substantial damageNTSB FTW77FA051Accident · 1 fatalClosedBeech C50 · Utopia, TXMay 2, 1977 · N360 · DestroyedNTSB CHI77FA042Accident · 1 fatalClosedBeagle 206S2 · Mendon, MIMay 2, 1977 · N500KR · DestroyedNTSB SEA77FA029Accident · 2 fatalClosedCessna 172N · Newberg, ORMay 1, 1977 · N733VP · DestroyedNTSB IAD77FLQ12Accident · 1 fatalClosedBeech F35 · Pikeville, KYMay 1, 1977 · N4238B · Substantial damageNTSB DEN77FA039Accident · 1 fatalClosedMooney M20C · Silver Plume, COMay 1, 1977 · N9685M · DestroyedNTSB MIA77FLG15Accident · 2 fatalClosedStarduster 2 · Camden, SCApr 30, 1977 · N2JL · DestroyedNTSB DEN77FA037Accident · 2 fatalClosedPiper PA-32 · Englewood, COApr 30, 1977 · N32282 · DestroyedNTSB DEN77FA038Accident · 2 fatalClosedBellanca 7KCAB · Morgan, UTApr 29, 1977 · N76CC · DestroyedNTSB IAD77AA038Accident · 4 fatalClosedBeech HS.125 · Mclean, VAApr 28, 1977 · N40PC · DestroyedNTSB OAK77FVG31Accident · 2 fatalClosedAero-Comdr S-2R · Maxwell, CAApr 26, 1977 · N4997X · DestroyedNTSB MKC77FA022Accident · 1 fatalClosedPiper PA-36 · Pierre, SDApr 26, 1977 · N57821 · 2 aircraft · Substantial damageNTSB CHI77FEI18Accident · 1 fatalClosedVern Board Mini · Lorain, OHApr 26, 1977 · N57VB · DestroyedNTSB LAX77FA040Accident · 1 fatalClosedCessna 150L · Fullerton, CAApr 24, 1977 · N116NS · DestroyedNTSB OAK77FXQ17Accident · 1 fatalClosedPiper PA-28 · Winnemucca, NVApr 23, 1977 · N41176 · DestroyedNTSB CHI77FA040Accident · 4 fatalClosedAero Comdr 690A · Chicago, ILApr 23, 1977 · N847 · DestroyedNTSB NYC77FA053Accident · 1 fatalClosedBell 47G-4A · Hartsdale, NYApr 22, 1977 · N472FW · DestroyedNTSB MKC77FA021Accident · 1 fatalClosedCessna 182M · Aberdeen, SDApr 22, 1977 · N91622 · DestroyedNTSB UNK77X0104Accident · 1 fatalClosedPiper PA-28 · Gruver, TXApr 21, 1977 · N276V · DestroyedNTSB SEA78DA046Accident · 2 fatalClosedBeech 23 · Lewiston, MTApr 20, 1977 · C-GMUK · DestroyedNTSB LAX77FUA10Accident · 1 fatalClosedPiper PA-28R · Long Beach, CAApr 20, 1977 · N3104R · DestroyedNTSB IAD77FA036Accident · 4 fatalClosedPiper PA-28 · Windsor, NCApr 20, 1977 · N9803W · DestroyedNTSB IAD77FA035Accident · 1 fatalClosedBeech C23 · Knoxville, TNApr 19, 1977 · N9224S · DestroyedNTSB FTW77FA049Accident · 5 fatalClosedBeech BE200 · Ruddock, LAApr 18, 1977 · N256TM · DestroyedNTSB MIA77FA055Accident · 1 fatalClosedAeronca C3 · Immokalee, FLApr 17, 1977 · N15733 · Destroyed