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 MKC77FA037Accident · 3 fatalClosedPiper PA-28 · Eagle Butte, SDSep 3, 1977 · N7731W · DestroyedNTSB CHI77FEI42Accident · 1 fatalClosedFalck Spec · Cleveland, OHSep 3, 1977 · N60089 · DestroyedNTSB ANC77FA085Accident · 2 fatalClosedPiper PA-18 · Anchorage, AKSep 2, 1977 · N2992Z · DestroyedNTSB ANC77FA084Accident · 3 fatalClosedCessna 172 · Palmer, AKSep 2, 1977 · N61661 · Substantial damageNTSB ANC77FA083Accident · 3 fatalClosedCessna 185 · Minto Lake, AKSep 2, 1977 · N2563Z · 2 aircraft · Minor damageNTSB NYC77FA093Accident · 1 fatalClosedPiper PA-28 · Duanesburg, NYSep 1, 1977 · N6360R · DestroyedNTSB ANC78DAH09Accident · 1 fatalClosedTaylorcraft BC-12D · Red Devil Lake, AKSep 1, 1977 · N39133 · DestroyedNTSB NYC77FA090Accident · 2 fatalClosedPiper PA-28R · Greenwich, CTAug 31, 1977 · N3960X · DestroyedNTSB LAX77FA069Accident · 4 fatalClosedPiper PA-32 · Corona, CAAug 31, 1977 · N3422W · DestroyedNTSB MKC77FA036Accident · 1 fatalClosedCessna 172M · Henning, MNAug 30, 1977 · N64190 · DestroyedNTSB LAX77FA068Accident · 2 fatalClosedBellanca 17-30 · San Dimas, CAAug 30, 1977 · N4889V · DestroyedNTSB IAD77FA063Accident · 1 fatalClosedCessna 172M · Manchester, KYAug 29, 1977 · N20430 · No damageNTSB FTW77FRG65Accident · 2 fatalClosedBoeing B75-N1 · Kingsville, TXAug 29, 1977 · N59695 · Substantial damageNTSB OAK77FA052Accident · 2 fatalClosedCessna 205A · Kirkwood, CAAug 28, 1977 · N4874U · DestroyedNTSB NYC77FA089Accident · 1 fatalClosedCessna 195B · Mt Holley Spgs, PAAug 28, 1977 · N4404C · DestroyedNTSB NYC77FA088Accident · 4 fatalClosedBeech F35 · North Wales, PAAug 28, 1977 · N3357C · DestroyedNTSB FTW77FA073Accident · 3 fatalClosedPiper PA-28R · Hugo, OKAug 28, 1977 · N33862 · DestroyedNTSB FTW77FA072Accident · 3 fatalClosedPiper PA-24 · Canyon, TXAug 28, 1977 · N5209P · DestroyedNTSB DEN77FA055Accident · 2 fatalClosedBeech C-23 · Miami, NMAug 28, 1977 · N9756L · DestroyedNTSB ANC77DA079Accident · 7 fatalClosedCessna 411 · Yakutat, AKAug 27, 1977 · N4930T · DestroyedNTSB OAK77FA051Accident · 4 fatalClosedAerostar 601 · Little Norway, CAAug 26, 1977 · N7481S · 2 aircraft · Substantial damageNTSB OAK77FA050Accident · 2 fatalClosedSkyvan SC-7 · Kailua Kona, HIAug 25, 1977 · N4917 · DestroyedNTSB NYC77FA087Accident · 1 fatalClosedPiper PA-24 · New Lebanon, NYAug 25, 1977 · N8575P · DestroyedNTSB MIA77FKQ39Accident · 1 fatalClosedCessna A188B · Winona, MSAug 25, 1977 · N79462 · Substantial damageNTSB LAX77FA067Accident · 4 fatalClosedMooney M20E · Torrance, CAAug 25, 1977 · N79389 · DestroyedNTSB LAX77FA066Accident · 3 fatalClosedBeech 65-88 · Camarillo, CAAug 25, 1977 · N711KW · DestroyedNTSB CHI77FA069Accident · 4 fatalClosedCessna 170 · Florence, WIAug 23, 1977 · N4052V · DestroyedNTSB MIA77FLG33Accident · 1 fatalClosedCessna 182 · Myrtle Beach, SCAug 22, 1977 · N3256U · DestroyedNTSB LAX77FA065Accident · 2 fatalClosedBeech E18S · Catalina Is, CAAug 22, 1977 · N979SB · DestroyedNTSB CHI77FA068Accident · 1 fatalClosedCessna 172N · Salem, MIAug 22, 1977 · N75810 · DestroyedNTSB SEA77FYM59Accident · 1 fatalClosedPitts MR1 · Vancouver, WAAug 21, 1977 · N30059 · DestroyedNTSB SEA77FA049Accident · 4 fatalClosedCessna 185 · Hansville, WAAug 21, 1977 · N1738R · DestroyedNTSB NYC77FA085Accident · 1 fatalClosedBeech P35 · Pittsburgh, PAAug 21, 1977 · N446Q · DestroyedNTSB MIA77FA082Accident · 2 fatalClosedChampion 7EC · Yazoo City, MSAug 21, 1977 · N9003B · DestroyedNTSB OAK77FXQ34Accident · 1 fatalClosedPiper PA-32 · Carson City, NVAug 20, 1977 · N5873V · DestroyedNTSB OAK77FA049Accident · 4 fatalClosedPiper PA-28 · Los Banos, CAAug 20, 1977 · N8474F · DestroyedNTSB MIA77FKJ76Accident · 1 fatalClosedPiper PA-25 · Castleberry, ALAug 20, 1977 · N4622Y · DestroyedNTSB MIA77FA081Accident · 1 fatalClosedBeech G18S · Aero Oasis Apt, FLAug 20, 1977 · N273V · DestroyedNTSB ANC77FA077Accident · 3 fatalClosedBell 206-B · Deadhorse, AKAug 20, 1977 · N59382 · DestroyedNTSB NYC77FA084Accident · 1 fatalClosedDehavilland DHC-2 · Morrisville, PAAug 19, 1977 · N67690 · DestroyedNTSB FTW77FA071Accident · 1 fatalClosedPiper PA-28R · Healdton, OKAug 19, 1977 · N38140 · DestroyedNTSB SEA77FA048Accident · 3 fatalClosedCessna 195A · Elgin, ORAug 18, 1977 · N4304V · DestroyedNTSB MKC77FA034Accident · 2 fatalClosedLuscombe 8A · Carthage, MOAug 18, 1977 · N71272 · DestroyedNTSB FTW77FA070Accident · 1 fatalClosedBeech V35B · Ida, LAAug 18, 1977 · N1605W · DestroyedNTSB CHI77FA067Accident · 4 fatalClosedFairchild F24 · Cedar, MIAug 18, 1977 · N81225 · DestroyedNTSB ANC77FA075Accident · 1 fatalClosedTaylorcraft BC-12D · Kakhonak, AKAug 18, 1977 · N24404 · DestroyedNTSB FTW77FA069Accident · 1 fatalClosedCessna 150L · Fort Worth, TXAug 17, 1977 · N15EB · DestroyedNTSB DEN77FA054Accident · 3 fatalClosedCessna 172 · Nsalina, UTAug 17, 1977 · N7985U · DestroyedNTSB ANC77FA074Accident · 2 fatalClosedPiper PA-12 · Delta Junction, AKAug 17, 1977 · N2541M · DestroyedNTSB LAX77FUG58Accident · 1 fatalClosedPiper PA-28 · 29 Palms, CAAug 16, 1977 · N1116X · Substantial damage