NTSB investigations
1,537 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '000') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '000') 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 CEN21LA307Accident · Serious injuriesClass 4 · LimitedFinal reportQuad City Challenger · Ste. Genevieve, MOAn impact with terrain for reasons that could not be determined based on available evidence.NTSB CEN21LA321Accident · No injuriesClass 4 · LimitedFinal reportSwann Lynn J Seawind 3000 · Charlevoix, MIThe loss of engine power for undetermined reasons based on available evidence.NTSB CEN21LA303Accident · No injuriesClass 3 · LimitedFinal reportAeronca 15AC · Hastings, MIA total loss of engine power for reasons that could not be determined based on the available information.NTSB ANC21LA047Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Sterling, AKA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ENG21WA029IncidentClass 5 · ForeignBoeing 737 · Ciudad de México, MexicoNTSB GAA21WA147Accident · 2 fatalClass 5 · ForeignNorth American T28 · Jickovice, CzechiaNTSB CEN21FA270Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor 502B · Paragould, ARAn inflight loss of control and subsequent impact with terrain during an aerial application flight for reasons that could not be determined based on the available evidence.NTSB GAA21WA138AccidentClass 5 · ForeignBell 214 · Nipigon, CanadaNTSB CEN21LA254Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Drew, MSA loss of control during takeoff for reasons that could not be determined.NTSB CEN21LA257Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Wallingford, IAImpact with trees and terrain during takeoff for reasons that could not be determined based on the available information.NTSB WPR21LA220Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24 · Paris, IDA total loss of engine power for reasons that could not be determined.NTSB GAA21WA122Accident · 1 fatalClass 5 · ForeignCessna F172 · Abzac, France, FranceNTSB GAA21WA117AccidentClass 5 · ForeignCessna 172 · Guatemela, GuatemalaNTSB GAA21WA120Accident · 1 fatalClass 5 · ForeignStorm Fury RG · Mucia, Spain, SpainNTSB GAA21WA114Accident · 2 fatalClass 5 · ForeignLegacy 2000 · Oberramsern, SwitzerlandNTSB GAA21WA111Accident · 1 fatalClass 5 · ForeignRobinson R44 · Estepona, SpainNTSB CEN21LA204Accident · 1 fatalClass 3 · LimitedFinal reportPiper J3C-65 · Slaughter, LAA total loss of engine power for reasons that could not be determined from the available evidence.NTSB GAA21WA088Accident · 1 fatalClass 5 · ForeignAgusta A119 · Nuevo Laredo, MexicoNTSB GAA21WA086Accident · 1 fatalClass 5 · ForeignSikorsky S76C+ · Oak Cheon Goon, South KoreaNTSB GAA21WA064Accident · Minor injuriesClass 5 · ForeignPiper PA46 · Iztapa, GuatemalaNTSB GAA21WA066Accident · No injuriesClass 5 · ForeignCessna 150 · Cajeme, Sonora, MexicoNTSB GAA21WA061Accident · 2 fatalClass 5 · ForeignCessna T206H · Quintana Roo, Mexico, MexicoNTSB GAA21WA060Accident · 7 fatalClass 5 · ForeignCessna 401 · Hermosillo, Mexico, MexicoNTSB ENG21WA051Incident · Serious injuriesClass 5 · ForeignAerospatiale AS350 · Aoki Village, JapanNTSB GAA21WA054Accident · 4 fatalClass 5 · ForeignBell 206 · XIa Men City, ChinaNTSB GAA21WA053Accident · 1 fatalClass 4 · ForeignRobinson R44 · Leksand, SwedenNTSB GAA21WA087Accident · Minor injuriesClass 5 · ForeignBell 212 · Bowen Island, CanadaNTSB GAA21WA040Accident · 2 fatalClass 4 · ForeignPiper PA-28-161 · Acklin, BahamasNTSB GAA21WA075Incident · No injuriesClass 5 · ForeignCessna 501 · Odesa, UkraineNTSB ANC21LA020Accident · 1 fatalClass 3 · LimitedFinal reportRobinson Helicopter R66 · Kodiak, AKAn impact with ocean waters for reasons that could not be determined based on the available information.NTSB GAA21WA037Accident · 5 fatalClass 5 · ForeignBeech B300 · Ji'an City Jiangxi Province, ChinaNTSB GAA21WA063AccidentClass 5 · ForeignPiper PA25 · Panuco, Veracruz, MexicoNTSB ERA21LA141Accident · 1 fatalClass 3 · LimitedFinal reportSteinman Mark E Lancair 320 · Atlantic Ocean (Atlantic Ocean)The airplane’s impact with water for reasons that could not be determined.NTSB GAA21WA033Accident · 2 fatalClass 5 · ForeignAviat A1C-180 · Nanyuki, KenyaNTSB ERA21LA126Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Pahokee, FLA loss of main rotor rpm for reasons that could not be determined, which resulted in an autorotation and a subsequent hard landing and rollover.NTSB ANC21WA009Accident · 1 fatalClass 5 · ForeignRobinson R66 · Ojiro in Shimada-City, Shizuoka, JapanNTSB CEN21LA100Accident · Serious injuriesClass 3 · LimitedFinal reportWalton Daniel J Sonex · Pecatonica, ILA total loss of engine power for reasons that could not be determined based on the available information, and the pilot’s exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall/spin and…NTSB WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.NTSB WPR21WA065Accident · 2 fatalClass 5 · ForeignRobinson R44 · Tallong, AustraliaNTSB WPR21WA062Accident · 1 fatalClass 5 · ForeignCessna 172 · Katale, UgandaNTSB ERA21WA064Accident · Serious injuriesClass 5 · ForeignCessna 188 · Esperanza, Dominican RepublicNTSB CEN21WA063Accident · 1 fatalClass 5 · ForeignRotorsport UK Cavalon · Avoch, United KingdomNTSB CEN21WA056Accident · 2 fatalClass 5 · ForeignQuest Kodiak 100 · Guatemala City, GuatemalaNTSB WPR21WA050Accident · 1 fatalClass 5 · ForeignCirrus SR22 · Nelspruit, South AfricaNTSB WPR21LA032Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · Billings, MTThe pilot’s failure to maintain the proper descent glide path while on final approach for reasons that could not be determined from available evidence.NTSB CEN21LA035Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Crystal Beach, TXThe partial loss of engine power for reasons that could not be determined.NTSB CEN21FA024Accident · 1 fatalClass 3 · FieldFinal reportGlasair III · Ford Heights, ILThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA21WA115Accident · No injuriesClass 5 · ForeignRobinson R44 · Melili, KenyaNTSB CEN21LA018Accident · 2 fatalClass 3 · LimitedFinal reportCessna T182 · Houma, LAImpact with terrain for reasons that could not be determined with the available information.NTSB CEN21WA013Accident · 1 fatalClass 5 · ForeignCessna FRA150 · Troutbeck, United Kingdom