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 CEN23LA022Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · Evansville, INThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Lake Worth, FLA loss of engine power for reasons that could not be determined.NTSB GAA23WA009Accident · 7 fatalClass 5 · ForeignBell 407 · Rudraprayag, IndiaNTSB GAA23WA020Accident · No injuriesClass 5 · ForeignEurocopter AS350 · Los Jaramillos, PanamaNTSB WPR23FA007Accident · 1 fatalClass 3 · FieldFinal reportCornford Craig H Mustang II · Jamul, CAImpact with mountainous terrain for undetermined reasons due to the limited evidence that could be collected from the accident sceneNTSB GAA22WA300Accident · 1 fatalClass 5 · ForeignEmbraer EMB720 · Santa Cruz, BoliviaNTSB GAA22WA287Accident · 2 fatalClass 5 · ForeignCessna 172 · Shaunavon, CanadaNTSB WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…NTSB WPR22LA352Accident · No injuriesClass 3 · LimitedFinal reportJacquneaux Glen R CGS Hawk · Lander, WYA reported severe airframe vibration and subsequent forced landing for reasons that could not be determined because the wreckage was not made available for examination.NTSB GAA22WA293AccidentClass 5 · ForeignFairchild 227 · Queretaro, MexicoNTSB ERA22LA416Accident · No injuriesClass 3 · LimitedFinal reportWilliam L Bell Vans RV-7A · Warrenton, VAA total loss of engine power for reasons that could not be determined because the airplane could not be examined.NTSB GAA22WA280Accident · 1 fatalClass 4 · ForeignAir Tractor AT502 · Camrose, CanadaNTSB GAA22WA282Accident · 1 fatalClass 5 · ForeignEurocopter EC120B · Bidor, MalaysiaNTSB GAA22WA278Accident · 1 fatalClass 5 · ForeignCessna 208B · Oriximina, BrazilNTSB GAA22WA273Accident · Minor injuriesClass 5 · ForeignCessna 172 · Barrancominas, ColombiaNTSB GAA22WA292AccidentClass 3 · ForeignAgusta A119 · Mount Cusna, ItalyNTSB ERA22LA401Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Wadsworth, OHA total loss of engine power for reasons that could not be determined.NTSB CEN22LA403Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Houghton Lake, MIA loss of engine power during cruise flight for undetermined reasons.NTSB ANC22FA069Accident · 1 fatalClass 3 · FieldFinal reportStory Charles Brad TT FOX · Wasilla, AKThe pilot’s inability to maintain control of the airplane for reasons that could not be determined.NTSB ERA22LA389Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 140 · Slocomb, ALThe partial loss of engine power during takeoff for reasons that could not be determined.NTSB WPR22LA317Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design General Avn Ctsw SuperSport · Boulder City, NVA total loss of engine power for undetermined reasons.NTSB WPR22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-30 · St Ignatius, MTA partial loss of power during takeoff for undetermined reasons.NTSB ERA22LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Marathon, FLA total loss of power for undetermined reasons.NTSB ERA22FA376Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Glendora, MSThe collision with terrain for reasons that could not be determined.NTSB CEN22FA376Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Centennial, COThe loss of engine power during a departure climb for undetermined reasons and the aerodynamic stall, which resulted in an uncontrolled descent and impact with terrain.NTSB GAA22WA248Accident · 1 fatalClass 5 · ForeignRobinson R44 · Lanzhou, ChinaNTSB GAA22WA257Accident · 1 fatalClass 5 · ForeignAyres S2R · Morden Reginao, CanadaNTSB CEN22LA361Accident · No injuriesClass 3 · LimitedFinal reportVans RV-10 · Hurst, ILA loss of engine power for reasons that could not be determined.NTSB CEN22LA354Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Lamoni, IAA loss of airplane performance for reasons that could not be determined.NTSB ERA22LA346Accident · Serious injuriesClass 3 · LimitedFinal reportTextron G36 · Ridgeland, SCA loss of engine power for reasons that could not be determined.NTSB ERA22LA345Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Ephratah, NYA loss of engine power for undetermined reasons.NTSB CEN22LA349Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Knox, INA partial loss of engine power for undetermined reasons.NTSB GAA22WA238Accident · 1 fatalClass 5 · ForeignCessna T210L · Puerto Plata, Dominican RepublicNTSB GAA22WA239Accident · No injuriesClass 5 · ForeignCessna 152 · Baramati, IndiaNTSB GAA22WA254Accident · 1 fatalClass 5 · ForeignRobinson R44 · Loanda, BrazilNTSB GAA22WA231Accident · 2 fatalClass 5 · ForeignUnited Consultants UC-1 · Lake Siljan, SwedenNTSB CEN22LA323Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Verona, ILA loss of rotor rpm for reasons that could not be determined.NTSB GAA22WA233Accident · 3 fatalClass 4 · ForeignRobinson R44 · Kronotsky Nature Reserve, RussiaNTSB GAA22WA227Accident · 2 fatalClass 5 · ForeignPiper PA-31-325 · Queretaro, MexicoNTSB GAA22WA225Accident · 2 fatalClass 4 · ForeignBell 206 · Boa Vista, BrazilNTSB CEN22LA313Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Rapid City, SDA total loss of engine power for reasons that could not be determined because the airplane was unavailable for examination.NTSB GAA22WA222Accident · 1 fatalClass 5 · ForeignBell 206 · Richmond, AustraliaNTSB ERA22LA302Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Center Cross, VAA loss of engine power for reasons that could not be determined.NTSB ANC22LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 182D · McGrath, AKA nose landing gear collapse during landing for reasons that could not be determined based on the available information.NTSB GAA22WA218Accident · 4 fatalClass 3 · ForeignLearjet 35 · Tierra del Fuego, ArgentinaNTSB CEN22LA311Accident · No injuriesClass 3 · LimitedFinal reportRotorsport UK MTOSport 2017 · Mead, OKA partial loss of engine power for reasons that could not be determined.NTSB ERA22LA366Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT · Wilmington, NCA partial loss of engine power during initial climb for reasons that could not be determined.NTSB WPR22LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · San Carlos, CAThe total loss of engine power for undetermined reasons.NTSB GAA22WA212AccidentClass 5 · ForeignSikorsky S76D · Mumbai, IndiaNTSB ANC22FA047Accident · 1 fatalClass 3 · FieldFinal reportBell UH1B · Clear, AKA loss of control for reasons that could not be determined based on the available information.