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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MKC77FCD27Accident · 1 fatalClosedPiper PA-25 · Woodbine, IANTSB LAX77FUA18Accident · 2 fatalClosedBoeing PT-17 · Costa Mesa, CANTSB DCA77AA022Accident · 3 fatalClosedLockheed L-188C · St.Louis, MONTSB ANC77FA054Accident · 1 fatalClosedAeronca 7AC · Sterling, AKNTSB SEA77FYA26Accident · 2 fatalClosedPiper PA-18 · Picabo, IDNTSB NYC77FA067Accident · 2 fatalClosedPiper PA-24 · Windham, VTNTSB LAX77FA055Accident · 1 fatalClosedSchweizer SGS126 · Ocotillo Wells, CANTSB CHI77FER04Accident · 1 fatalClosedPiper PA-24 · Superior, WINTSB CHI77FA057Accident · 2 fatalClosedCessna 150J · Missing AircraftNTSB CHI77FA056Accident · 4 fatalClosedPiper PA-23 · Freesoil, MINTSB IAD77FA050Accident · 1 fatalClosedCessna 182 · Bryson City, NCNTSB DEN77FTC18Accident · 1 fatalClosedLuscombe 8A · Walcott, WYNTSB SEA77FYM44Accident · 1 fatalClosedBellanca 8KCAB · Ukiah, ORNTSB ANC77FA053Accident · 1 fatalClosedCessna 180F · Bethel, AKNTSB MIA77DA066Accident · 2 fatalClosedDavis D-1-W · Camden, SCNTSB MIA77FLD73Accident · 1 fatalClosedBoeing E-75 · Ft.Pierce, FLNTSB FTW77FQG36Accident · 1 fatalClosedAero Comdr A9B · Nolan, TXNTSB MIA77FA065Accident · 1 fatalClosedPiper PA18 · Foley, ALNTSB DEN77FA046Accident · 2 fatalClosedPiper PA-22 · Englewood, CONTSB DEN77FA045Accident · 2 fatalClosedCessna 305A · Gunnison, CONTSB LAX77FA053Accident · 5 fatalClosedPiper PA-31 · Grand Canyon, AZNTSB CHI77FA054Accident · 4 fatalClosedMooney M20F · Port Huron, MINTSB CHI77FA053Accident · 5 fatalClosedCessna 182C · Grattan, MINTSB IAD77FA048Accident · 3 fatalClosedNa Rockwell 114 · Littleton, NCNTSB SEA77FYE25Accident · 1 fatalClosedCessna 310Q · Arlington, WANTSB MIA77FA064Accident · 1 fatalClosedCessna 210 · Summerland Key, FLNTSB CHI77FA052Accident · 1 fatalClosedCessna 320D · Cleveland, OHNTSB SEA77FA041Accident · 1 fatalClosedPiper PA-18 · Glasgow, MTNTSB MKC77FA029Accident · 4 fatalClosedPiper PA-28 · Walker, MNNTSB MKC77FA028Accident · 1 fatalClosedBellanca 8GCBC · Mound City, MONTSB MIA77FA063Accident · 2 fatalClosedCessna 182F · Plymouth, FLNTSB NYC77FNE22Accident · 1 fatalClosedPiper PA-25 · Amherst, MANTSB NYC77FA065Accident · 1 fatalClosedEnstrom F-28A · North Wales, PANTSB LAX77FA052Accident · 1 fatalClosedCessna 340A · Corona, CANTSB CHI77FEG21Accident · 1 fatalClosedPitts S-1C · Minford, OHNTSB OAK77DA039Accident · 2 fatalClosedAero Comdr 112 · Missing AircraftNTSB LAX96LA321Accident · 2 fatalLimited investigationClosedRockwell 112 · Eureka, CAThe pilot's intentional VFR flight into instrument meteorological conditions.NTSB IAD77FA046Accident · 1 fatalClosedCessna 150E · Raleigh, NCNTSB FTW77FRA27Accident · 2 fatalClosedPiper J3C-65 · Waller, TXNTSB MKC77FA027Accident · 2 fatalClosedCessna 172 · Cedar Rapids, IANTSB IAD77FKW20Accident · 2 fatalClosedCessna 172 · Midtown Commun, TNNTSB MKC77FTK27Accident · 1 fatalClosedPiper PA-20 · Onida, SDNTSB MKC77FCD23Accident · 1 fatalClosedMorris Cass 111M · Winterset, IANTSB MKC77FCQ42Accident · 1 fatalClosedCessna 188B · Olsburg, KSNTSB MKC77FA026Accident · 2 fatalClosedBeech H35 · Beawfort, MONTSB NYC77FA064Accident · 2 fatalClosedErco 415C · New Bedford, MANTSB OAK77FA037Accident · 1 fatalClosedSikorski S58FT · Golconda, NVNTSB NYC77FA066Accident · 2 fatalClosedCessna 172K · Nantucket, MANTSB MIA77FA061Accident · 1 fatalClosedPiper PA-16 · Valdosta, GANTSB LAX77FA051Accident · 3 fatalClosedCessna 172M · Peoria, AZ