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 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 CEN21FA195Accident · 1 fatalClass 3 · FieldFinal reportCessna 340A · Tatum, TXThe pilot’s loss of airplane control for undetermined reasons.NTSB CEN21LA193Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · McKinney, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB 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 CEN21LA107Accident · 2 fatalClass 3 · LimitedFinal reportHawker Beechcraft G58 · Credit, ARA loss of left engine power for undetermined reasons, which resulted in an emergency descent with one engine inoperative and inadvertent collision with transmission lines. Contributing to the accident was the pilot’s inability to respond appropriately to the…NTSB ANC21WA009Accident · 1 fatalClass 5 · ForeignRobinson R66 · Ojiro in Shimada-City, Shizuoka, JapanNTSB CEN21LA102Accident · 1 fatalClass 3 · LimitedFinal reportHughes 369D · Tuckers Crossing, MSThe pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…NTSB 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 KingdomNTSB CEN21LA004Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Lake Elmo, MNA total loss of engine power for reasons that could not be determined.NTSB WPR20LA320Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T1A · San Diego, CAA loss of engine power for reasons that could not be determined, which resulted in a hard landing off airport.NTSB GAA20WA149AccidentClass 5 · ForeignCessna 182 · Minas City, UruguayNTSB CEN20LA413Accident · FatalClass 3 · LimitedFinal reportCosmos Phase 3 · Wayne, OKA loss of control while taxiing for reasons that could not be determined based on available evidence.NTSB CEN21WA036Accident · 2 fatalClass 5 · ForeignCessna TU206G · Los Laureles, MexicoNTSB CEN20LA392Accident · 3 fatalClass 3 · LimitedFinal reportCessna 172 · Cottage Grove, MNA steep descent and impact with terrain for reasons that could not be determined based on the available information.NTSB WPR20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 208 · Whitmore, AZA loss of directional control during landing due to a flat main landing gear tire, which resulted in a lateral runway excursion and impact with terrain.