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 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 WPR22FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna T337G · Gold Hill, COThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering with one engine inoperative, which resulted in an aerodynamic stall/spin and impact with terrain.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 CEN22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Aurora, COA total loss of engine power due to foreign object debris blockage of engine air intake. The source of the debris 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.NTSB ERA22LA283Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-18A · Charlestown, NHThe pilot’s failure to see and avoid power lines while maneuvering at low altitude.NTSB ERA22LA287Accident · Serious injuriesClass 3 · LimitedFinal reportMantell Allan T Lightning · Canandaigua, NYThe pilot’s performance of an off-airport landing shortly after takeoff for reasons that could not be determined.NTSB WPR22FA215Accident · 2 fatalClass 3 · FieldFinal reportBeech E35 · Buckeye, AZThe pilots’ failure to climb and complete a normal traffic pattern after making a low approach and their failure to extend the flaps for reasons that could not be determined, and the flight instructor’s failure to ensure adequate airspeed and bank control…NTSB WPR22LA221Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Stockton, CATail rotor blade impact with an unidentified object, which resulted in the loss of control and subsequent rollover of the helicopter.NTSB CEN22LA252Accident · No injuriesClass 3 · LimitedFinal reportMeyers Industries 200A · Weslaco, TXA total loss of engine power for reasons that could not be determined.NTSB CEN22LA247Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Olla, LAThe partial loss of engine power for undetermined reasons.NTSB CEN22FA232Accident · 2 fatalClass 3 · FieldFinal reportCessna 182G · Kenedy, TXA loss of airplane control on final approach for reasons that could not be determined.NTSB WPR22LA202Accident · Minor injuriesClass 3 · LimitedFinal reportFischer Super Koala · Chelan, WAA total loss of engine power for undetermined reasons.NTSB CEN22LA259Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Mesquite, TXA collapse of the airplane’s landing gear during the landing roll for reasons that could not be determined based on the available information.NTSB GAA22WA195Accident · 1 fatalClass 5 · ForeignCessna 182 · Chirijox, GuatemalaNTSB GAA22WA196Accident · 2 fatalClass 5 · ForeignCessna 152 · Klobuck, PolandNTSB WPR22LA192Accident · 1 fatalClass 3 · LimitedFinal reportMaule MX-7-180C · Willits, CAAn uncommanded descent during a go-around maneuver for undetermined reasons.NTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…NTSB GAA22WA193Accident · 4 fatalClass 5 · ForeignCessna C182 · Slunj, CroatiaNTSB CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…NTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.NTSB GAA22WA190Accident · 2 fatalClass 5 · ForeignPiper PA25 · Brasilandia De Minas, BrazilNTSB GAA22WA181Accident · 4 fatalClass 5 · ForeignCessna 182 · Piracuara, ColombiaNTSB GAA22WA276Accident · No injuriesClass 4 · ForeignTecnam P2006T · Bhiwani, IndiaNTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain control of the airplane for reasons that could not be determined.NTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN22LA185Accident · 1 fatalClass 3 · LimitedFinal reportSuperior Culver LFA · Syracuse, KSThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an inadvertent aerodynamic stall while returning to the airport following a partial loss of engine power for reasons that could not be determined.NTSB GAA22WA158Accident · No injuriesClass 5 · ForeignMonnett Sonerai · Jyväskylä, FinlandNTSB ENG22WA019Accident · 3 fatalClass 5 · ForeignSikorsky S92 · Jeju Island, South Korea