NTSB investigations
1,709 cases where the sequence of events included Unknown or undetermined.
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA26WA083Accident · Minor injuriesClass 5 · ForeignCessna 188 · Hatillo Palma, Dominican RepublicNTSB GAA26WA097Incident · No injuriesClass 4 · ForeignCessna C152 · Pucallpa, PeruNTSB GAA26WA084Incident · No injuriesForeign investigationPiaggio P180 · Grenoble Alpes Isère, FranceNTSB GAA26WA090Incident · No injuriesClass 5 · ForeignBeech G58 · Caceres, BrazilNTSB GAA26WA091Accident · 1 fatalClass 5 · ForeignCessna 172 · Caracaraí,, BrazilNTSB GAA26WA075Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Kumamoto Prefecture, JapanNTSB GAA26WA078Incident · No injuriesClass 5 · ForeignPiper PA23 · Santiago, ChileNTSB WPR26FA082Accident · Serious injuriesClass 3 · FieldPreliminary reportBell Helicopter Textron 206L-1 · Kamas, UTOn January 18, 2026, about 1510 mountain standard time, a Bell 206L-1, N138DD, was substantially damaged when it was involved in an accident near Kamas, Utah. The pilot and three passengers received minor injuries. The helicopter was operated as a Title 14…NTSB GAA26WA074Accident · 3 fatalClass 5 · ForeignRobinson R44 · Rio de Janeiro, BrazilNTSB GAA26WA137Accident · Serious injuriesClass 5 · ForeignAyres S2R600 · Lebu, ChileNTSB GAA26WA072Accident · 6 fatalClass 3 · ForeignPiper PA-31-325 · Paipa, ColombiaNTSB GAA26WA073Accident · 1 fatalClass 3 · ForeignAir Tractor AT602 · Lucas do Rio Verde, BrazilNTSB CEN26FA086Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Sabine Pass, TXOn January 8, 2026, about 1431 central standard time, a Beech A36 airplane, N5677X, was substantially damaged when it was involved in an accident near Sabine Pass, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title…NTSB GAA26WA067Accident · 2 fatalClass 5 · ForeignRobinson R44 · Bardymsky Municipal District, RussiaNTSB GAA26WA066Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Guarulhos, BrazilNTSB GAA26WA064Accident · Minor injuriesClass 5 · ForeignCessna 188 · Santa Vitória do Palmar, BrazilNTSB GAA26WA060Accident · 8 fatalClass 3 · ForeignDassault FALCON50 · Ankara, TürkiyeNTSB GAA26WA194Incident · No injuriesClass 5 · ForeignHawker 800XP · Kano, NigeriaNTSB GAA26WA051Accident · 2 fatalClass 5 · ForeignBell 206 · Ranana, New ZealandNTSB CEN26LA061Accident · Serious injuriesClass 3 · LimitedPreliminary reportBell Textron Canada 505 · Divot, TXOn December 13, 2025, about 1345 central standard time, a Bell Helicopter 505, N865S, was substantially damaged when it was involved in an accident near Divot, Texas. The pilot was seriously injured and the passenger sustained minor injuries. The helicopter…NTSB GAA26WA063Accident · 1 fatalClass 5 · ForeignRobin DR400 · Le Havre, FranceNTSB GAA26WA045Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Buenos Aires, ArgentinaNTSB GAA26WA041Accident · 2 fatalClass 5 · ForeignRobinson R44 · Malawa, PolandNTSB GAA26WA037Accident · 1 fatalClass 4 · ForeignCessna 172 · Nanaimo, CanadaNTSB WPR26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportAmerican AA-1A · High Rolls, NMOn November 26, 2025, about 1145 mountain standard time, an American Aviation AA-1A airplane, N9439L was destroyed when it was involved in an accident near Alamogordo, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a…NTSB CEN26FA050Accident · 2 fatalClass 3 · FieldPreliminary reportSocata TBM 700 · Monroe, WIOn November 24, 2025, about 1713 central standard time (CST), a Socata TBM 700 airplane, N700PT, was destroyed when it was involved in an accident near Monroe, Wisconsin. The pilot and pilot-rated passenger sustained fatal injuries. The airplane was operated…NTSB GAA26WA030Accident · 3 fatalClass 5 · ForeignCirrus SR20 · Yame City, JapanNTSB DCA26WA079Accident · No injuriesClass 5 · ForeignBoeing 737 · Val-D'Or, CanadaNTSB GAA26WA027Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Krivi Put, CroatiaNTSB WPR26FA043Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172M · Poleta, CAOn November 10, 2025, at about 1515 Pacific standard time, Cessna 172M, N13221, was substantially damaged when it was involved in an accident near Poleta, California. A pilot-rated passenger and a passenger were fatally injured, and the pilot was seriously…NTSB GAA26WA022Accident · 4 fatalClass 5 · ForeignCessna TU206 · Bocoa, Vaupés, ColombiaNTSB GAA26WA016Accident · 1 fatalClass 5 · ForeignRobinson R44 · Bentley, United KingdomNTSB GAA26WA019Accident · 1 fatalClass 4 · ForeignRans S9 · San Felipe, ChileNTSB GAA26WA015Accident · 1 fatalClass 5 · ForeignCessna 208 · Diani, KenyaNTSB GAA26WA014Accident · 1 fatalClass 5 · ForeignTextron 182T · Nuuk, GreenlandNTSB GAA26WA053Accident · No injuriesClass 5 · ForeignCessna 172 · Uljin, South KoreaNTSB CEN26FA022Accident · 1 fatalClass 3 · FieldPreliminary reportKitfox II · Spruce Pine, NCOn October 17, 2025, about 1154 eastern daylight time, a Kitfox II airplane, N8610X was destroyed when it was involved in an accident near Spruce Pine, North Carolina. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA019Accident · 1 fatalClass 3 · FieldPreliminary reportBeech V35 · Austin, NVOn October 15, 2025, about 1447 Pacific daylight time, a Beech V35, C-FETM, was substantially damaged when it was involved in an accident near Austin, Nevada. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN26LA016Accident · No injuriesClass 3 · LimitedPreliminary reportRotorway AG162 · Valley View, TXOn October 13, 2025, at 1229 central daylight time, a Rotorway AG162 helicopter, N162AD, sustained substantial damage when it was involved in an accident near Valley View, Texas. The pilot and passenger were uninjured. The helicopter was operated under Title…NTSB WPR26FA008Accident · 1 fatalClass 3 · FieldPreliminary reportAirbus Helicopters EC 130 T2 · Sacramento, CAOn October 6, 2025, about 1905 Pacific daylight time, an Airbus Helicopters EC-130 T2, N414RX, was substantially damaged when it was involved in an accident in Sacramento, California. The pilot and flight paramedic sustained serious injuries; the flight nurse…NTSB GAA26WA009Accident · Serious injuriesClass 4 · ForeignBell 214B-1 · Squamish, CanadaNTSB CEN26FA012Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A35 · Skidmore, TXOn October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…NTSB CEN26FA005Accident · 3 fatalClass 3 · FieldPreliminary reportBeech 58P · Williston, FLOn October 5, 2025, at 1610 eastern daylight time, a Beech 58P airplane, N121GJ, was destroyed when it was involved in an accident near Williston, Florida. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA003Accident · 1 fatalClass 4 · ForeignRobinson R22 · Brogans Creek, AustraliaNTSB GAA25WA268Accident · 1 fatalForeign investigationBushmaster Super 22 · Lillooet, CanadaNTSB GAA25WA270Accident · 4 fatalClass 5 · ForeignCessna 175 · Aquidauana, BrazilNTSB WPR25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportMurphy SR3500 · Bigfork, MTOn September 19, 2025, about 1205 mountain daylight time, an experimental amateur built Murphy SR3500, N62ZT, was destroyed when it was involved in an accident near Bigfork, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB ANC25LA121Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-210C · Lime Village, AKA collision with terrain during takeoff.NTSB GAA25WA271Accident · 1 fatalClass 5 · ForeignCessna P210 · Corumba, BrazilNTSB CEN25FA367Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Lakeville, MNOn September 6, 2025, about 1442 central daylight time, a Robinson Helicopter Company R66 helicopter, N6633L was destroyed when it was involved in an accident near Lakeville, Minnesota. The pilot and passenger were fatally injured. The helicopter was operated…