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 OAK77FA002Accident · 2 fatalClosedBeech B35 · Lower Lake, CAOct 23, 1976 · N8797A · DestroyedNTSB FTW77FA008Accident · 2 fatalClosedCessna 182L · Shaw, LAOct 23, 1976 · N42213 · DestroyedNTSB CHI77FA004Accident · 2 fatalClosedCessna 150H · Joliet, ILOct 23, 1976 · N23080 · DestroyedNTSB FTW77FRG05Accident · 1 fatalClosedAir Tractor AT-301 · La Feria, TXOct 22, 1976 · N4343S · DestroyedNTSB SEA77FA003Accident · 1 fatalClosedBellanca 8KCAB · Billings, MTOct 21, 1976 · N11705 · DestroyedNTSB LAX77FA004Accident · 2 fatalClosedBeech 35-C33 · Los Angeles, CAOct 21, 1976 · N21TH · 2 aircraft · DestroyedNTSB IAD77FKM03Accident · 3 fatalClosedBalloon 1 · Charlotte, NCOct 21, 1976 · NONE · DestroyedNTSB FTW77FA006Accident · 1 fatalClosedCessna 210B · Granbury, TXOct 21, 1976 · N9640X · Substantial damageNTSB DEN77FA003Accident · 4 fatalClosedCessna 210F · Edgerton, WYOct 21, 1976 · N313E · DestroyedNTSB IAD77FA008Accident · 4 fatalClosedPiper PA-31 · Hampton, VAOct 20, 1976 · N61436 · DestroyedNTSB IAD77FA007Accident · 1 fatalClosedCessna 182 · Centreville, VAOct 20, 1976 · N4699K · DestroyedNTSB CHI76FA003Accident · 1 fatalClosedCessna 150M · Amherst, WIOct 20, 1976 · N704PN · DestroyedNTSB DEN77FTM07Accident · 1 fatalClosedCessna P206B · Nephi, UTOct 19, 1976 · N4764F · DestroyedNTSB DEN77FA002Accident · 2 fatalClosedCessna 150 · Texico, NMOct 19, 1976 · N66113 · DestroyedNTSB NYC77FA004Accident · 4 fatalClosedPiper PA-28 · Elizabethville, PAOct 18, 1976 · N55989 · Substantial damageNTSB FTW77FA005Accident · 1 fatalClosedPiper PA-28R · Elmendorf, TXOct 18, 1976 · N5348T · DestroyedNTSB NYC77FA005Accident · 1 fatalClosedPiper PA-28 · Frenchville, PAOct 17, 1976 · N4189J · DestroyedNTSB MIA77FL901Accident · 1 fatalClosedBensen B-8M · Laurens, SCOct 16, 1976 · N6536 · DestroyedNTSB FTW77FA004Accident · 4 fatalClosedPiper PA-23 · College Sta, TXOct 16, 1976 · N1434P · DestroyedNTSB FTW77FA007Accident · 1 fatalClosedBellanca 17-30 · Seguin, TXOct 15, 1976 · N4819V · DestroyedNTSB NYC77FA003Accident · 1 fatalClosedAeronca 15AC · Erwinna, PAOct 14, 1976 · N1269H · Substantial damageNTSB NYC77FA002Accident · 1 fatalClosedBeech B95A · Frankfort, NYOct 14, 1976 · N2056C · DestroyedNTSB MIA77FA002Accident · 2 fatalClosedCessna 150J · Kissimee, FLOct 11, 1976 · N61083 · DestroyedNTSB FTW77DA003Accident · 1 fatalClosedPitts Spcl S-1S · Durant, OKOct 11, 1976 · N7WH · 2 aircraft · Minor damageNTSB LAX77FVA07Accident · 1 fatalClosedCessna 150 · Kernville, CAOct 10, 1976 · N1402Q · Substantial damageNTSB CHI77FEK02Accident · 2 fatalClosedBel-Spezio BEL · Rockbridge, OHOct 10, 1976 · N3554 · DestroyedNTSB SEA77FA002Accident · 1 fatalClosedGlobe GC-1B · Hood River, OROct 9, 1976 · N80915 · DestroyedNTSB LAX77FA002Accident · 2 fatalClosedMooney M20C · Phoenix, AZOct 9, 1976 · N2734W · DestroyedNTSB IAD77FA005Accident · 4 fatalClosedPiper PA-34 · Busick, NCOct 9, 1976 · N15025 · DestroyedNTSB SEA77DA001Accident · 1 fatalClosedAeronca 11AC · Medical Lake, WAOct 8, 1976 · N9053E · DestroyedNTSB OAK76FA001Accident · 1 fatalClosedWildmaster 2 · Oroville, CAOct 8, 1976 · N28524 · DestroyedNTSB MIA77FA001Accident · 2 fatalClosedCessna 210L · Villanow, GAOct 7, 1976 · N2135S · DestroyedNTSB IAD77FA002Accident · 4 fatalClosedCessna 177RG · Centerville, TNOct 6, 1976 · N1865Q · DestroyedNTSB LAX77FUJ02Accident · 2 fatalClosedCessna A188A · Buckeye, AZOct 5, 1976 · N9997G · DestroyedNTSB FTW77FA002Accident · 3 fatalClosedMooney M20C · Houma, LAOct 4, 1976 · N16515 · DestroyedNTSB DEN77FA001Accident · 1 fatalClosedCessna 182A · Buford, WYOct 4, 1976 · N6033B · DestroyedNTSB OAK77FVM01Accident · 1 fatalClosedVolksplane VP-1 · Gilroy, CAOct 3, 1976 · N14DP · DestroyedNTSB FTW77FQG01Accident · 1 fatalClosedWarren-Fayo · Big Spring, TXOct 3, 1976 · N11GW · DestroyedNTSB FTW77FA001Accident · 2 fatalClosedCessna 150H · Claude, TXOct 3, 1976 · N22300 · DestroyedNTSB CHI77FA002Accident · 1 fatalClosedCessna 177B · Manteno, ILOct 3, 1976 · N34434 · DestroyedNTSB MIA77FKJ01Accident · 1 fatalClosedGrumman G-164 · Pansey, ALOct 2, 1976 · N23RA · DestroyedNTSB MIA77DKT01Accident · 1 fatalClosedBensen Gyro · Gulfstream, FLOct 2, 1976 · NONE · DestroyedNTSB LAX77FA001Accident · 4 fatalClosedBeech 35 · Bagdad, AZOct 2, 1976 · N362TC · DestroyedNTSB IAD77FA001Accident · 1 fatalClosedCessna 182 · Hudson, KYOct 2, 1976 · N2907Y · DestroyedNTSB CHI77FA001Accident · 1 fatalClosedCessna 172M · Hagerstown, INOct 2, 1976 · N6945H · DestroyedNTSB NYC77FA001Accident · 2 fatalClosedBeech E55 · Bradford, PAOct 1, 1976 · N4055S · DestroyedNTSB LAX76FNK13Accident · 1 fatalClosedPitts Spcl SIS · Prescott, AZSep 29, 1976 · N9RS · DestroyedNTSB CHI76AC094Accident · 1 fatalClosedCessna 182 · Perrysville, INSep 29, 1976 · N3424F · DestroyedNTSB ANC76AA142Accident · 1 fatalClosedPiper PA-28R · Juneau, AKSep 29, 1976 · N1493T · DestroyedNTSB MIA76AM112Accident · 4 fatalClosedPiper PA-22 · Treasure Is, FLSep 27, 1976 · N8541D · Destroyed