Fatal NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 GAA25WA084Accident · 1 fatalClass 5 · ForeignBell 206 · Polokwane Civil Aerodrome, South AfricaNTSB GAA25WA082Accident · 1 fatalClass 5 · ForeignPiper PA-34-220T · Braunschweig, GermanyNTSB GAA25WA077Accident · 1 fatalClass 5 · ForeignRobinson R44 · Pacific Ocean, EcuadorNTSB ERA25MA106Accident · 7 fatalClass 2 · MajorPreliminary reportLearjet 55 · Philadelphia, PAOn January 31, 2025, at 1807 eastern standard time, a Learjet 55 airplane, Mexican registration XA-UCI (call sign MTS056) was destroyed when it was involved in an accident in Philadelphia, Pennsylvania. The two pilots, two medical crewmembers, and two…NTSB GAA25WA083Accident · 1 fatalClass 5 · ForeignCessna C185F · Naivasha, KenyaNTSB DCA25MA108Accident · 67 fatalClass 1 · MajorFinal reportBombardier CL-600-2C10 · Washington, DCThe Federal Aviation Administration’s (FAA) placement of a helicopter route in close proximity to a runway approach path; their failure to regularly review and evaluate helicopter routes and available data, and their failure to act on recommendations to…NTSB GAA25WA073Accident · 3 fatalClass 3 · ForeignCessna 550 · Baruta, VenezuelaNTSB DCA25WA118Accident · 20 fatalClass 5 · ForeignBeech 1900 · Juba, SudanNTSB GAA25WA098Accident · 3 fatalClass 5 · ForeignRobinson R44 · Cruzilia, BrazilNTSB GAA25WA070Accident · 2 fatalClass 3 · ForeignCessna 182 · Región del Bio Bio, ChileNTSB ERA25FA103Accident · 1 fatalClass 3 · FieldPreliminary reportBeech V35B · Charlottesville, VAOn January 25, 2025, about 1235 eastern standard time, a Beech V35B, N2UZ, was destroyed when it was involved in an accident near Charlottesville, Virginia. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA080Accident · 1 fatalClass 5 · ForeignCessna 188 · Canarana, BrazilNTSB GAA25WA069Accident · 2 fatalClass 5 · ForeignPiper PA18 · Les Allues, FranceNTSB GAA25WA064Accident · 3 fatalClass 4 · ForeignBell Textron Canada 407 · Paredones Commune, ChileNTSB WPR25FA079Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Rock Springs, WYOn January 14, 2025, about 0622 mountain standard time, a Piper PA-24-250, N6502P, was destroyed when it was involved in an accident near Rock Springs, Wyoming. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB GAA25WA057Accident · 1 fatalClass 5 · ForeignThrush S2R · Santa Ines, HondurasNTSB CEN25LA075Accident · 1 fatalClass 3 · LimitedFinal reportBellanca 7GCBC · Batesville, ARThe pilot’s failure to maintain clearance from powerlines while flying at low altitude.NTSB GAA25WA058Accident · 3 fatalClass 5 · ForeignCessna 172 · Nairobi, KenyaNTSB GAA25WA056Accident · 1 fatalClass 4 · ForeignCessna 525 · Ubatuba, BrazilNTSB GAA25WA053Accident · 10 fatalClass 4 · ForeignCessna 402 · Medellin, ColombiaNTSB GAA25WA052Accident · 3 fatalClass 5 · ForeignCessna 208 · Rottnest Island, AustraliaNTSB WPR25LA080Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-300 · Round Mountain, NVImpact with mountainous terrain for reasons that could not be determined due to a lack of available evidence.NTSB WPR25FA072Accident · 2 fatalClass 3 · FieldPreliminary reportVans RV-10 · Fullerton, CAOn January 2, 2025, about 1409 Pacific standard time, an experimental amateur built Vans Aircraft RV-10, N8757R, was destroyed when it was involved in an accident near Fullerton, California. The pilot and passenger were fatally injured, and there were 19…NTSB ERA25FA086Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310 · Peebles, OHOn December 30, 2024, about 1515 eastern standard time, a Cessna 310D, N6979T, was substantially damaged when it was involved in an accident near Peebles, Ohio. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA25WA072Accident · 173 fatalClass 2 · ForeignBoeing 737 · Muan County, South KoreaNTSB DCA25WA069Accident · 35 fatalClass 5 · ForeignEmbraer ERJ190 · Aktau, KazakhstanNTSB GAA25WA049Accident · 1 fatalClass 5 · ForeignRockwell International 112TCA · Fife, United KingdomNTSB DCA25WA079Accident · 1 fatalClass 3 · ForeignAirbus Canada A220 · Graz, AustriaNTSB GAA25WA203Accident · 7 fatalClass 5 · ForeignCessna C207 · Nayarit, MexicoNTSB GAA25WA048Accident · 10 fatalClass 3 · ForeignPiper PA42 · Gramado, BrazilNTSB GAA25WA061Accident · 2 fatalClass 5 · ForeignCessna 310 · Manicore, BrazilNTSB ERA25FA082Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Cintrona, PRMaintenance personnel’s inadequate inspection of the airplane, which resulted in inflight the failure of the right aileron carry through cable due to wear, reduced effectiveness of the airplane’s ailerons, and a subsequent loss of control.NTSB ERA25FA080Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · East Aurora, NYOn December 19, 2024, at 1122 eastern standard time, a Beech A36, N36WP, was destroyed when it was involved in an accident near East Aurora, New York. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB GAA25WA044Accident · 2 fatalClass 5 · ForeignBombardier BD100 · San Fernando, ArgentinaNTSB ANC25FA010Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 208B · Honolulu, HIOn December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as…NTSB WPR25FA062Accident · 1 fatalClass 3 · FieldFinal reportAmerican Eurocopter AS350B3 · Potrero, CAThe pilot’s loss of control during cruise flight due to incapacitation for reasons that could not be determined.NTSB GAA25WA042Accident · 1 fatalClass 5 · ForeignChampion 8KCAB · Vélez-Málaga, SpainNTSB GAA25WA045Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Santiago, ChileNTSB GAA25WA059Accident · 1 fatalClass 4 · ForeignPiper PA25 · Nova Monte, BrazilNTSB ERA25FA076Accident · 1 fatalClass 3 · FieldFinal reportCostruzioni Aeronautiche Tecnam P2008 · Greenwich, CTA total loss of engine power due to water-contaminated fuel, and the pilots’ inadequate preflight inspection. Contributing to the water contamination were the missing o-ring or packing and damage to the left fuel cap, and the undetected improperly sealed…NTSB ERA25FA071Accident · 1 fatalClass 3 · FieldFinal reportMagni Builder M-16 · Foley, ALThe sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA25FA069Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-12IS · Homosassa, FLOn December 6, 2024, about 2004 eastern standard time, an experimental amateur-built Vans Aircraft Inc RV-12IS, N702DP, was substantially damaged when it was involved in an accident near Homosassa, Florida. The private pilot was fatally injured. The flight…NTSB ERA25FA066Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW24 · Vero Beach, FLOn December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…NTSB GAA25WA037Accident · 1 fatalClass 5 · ForeignRobinson R44 · Maimuru, AustraliaNTSB ERA25FA065Accident · 1 fatalClass 3 · FieldPreliminary reportTruitt James B Vans RV-8A · Fort Blackmore, VAOn December 4, 2024, about 1451 eastern standard time, an experimental amateur-built Vans RV-8A, N627TT, was substantially damaged when it was involved in an accident near Fort Blackmore, Virginia. The commercial pilot was fatally injured. The airplane was…NTSB CEN25FA052Accident · 2 fatalClass 3 · FieldPreliminary reportCozy MK III · Mineola, TXOn November 27, 2024, about 18:30 central standard time, a Cozy Mark III, N51810 was destroyed when it was involved in an accident near Mineola, Texas. The pilot and passenger were fatally injured. The flight was operated under the provisions of Title 14 Code…NTSB GAA25WA032Accident · 5 fatalClass 5 · ForeignCessna U206 · Cantón Central San José y Distrito de Pavas, Costa RicaNTSB DCA25WA046Accident · 1 fatalClass 3 · ForeignBoeing 737 · Vilnius, LithuaniaNTSB ERA25FA058Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Windham, NYOn November 24, 2024, at about 1809 eastern standard time, a Mooney M20J, N58156, was substantially damaged when it was involved in an accident near Windham, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN25FA047Accident · 2 fatalClass 3 · FieldFinal reportCessna 182T · Drake, COThe pilot’s failure to maintain airplane control while maneuvering in mountainous terrain. Contributing was mountain wave turbulence in the area.