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 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 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 WPR22LA202Accident · Minor injuriesClass 3 · LimitedFinal reportFischer Super Koala · Chelan, WAA total loss of engine power for undetermined reasons.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 GAA22WA193Accident · 4 fatalClass 5 · ForeignCessna C182 · Slunj, CroatiaNTSB GAA22WA187Accident · 2 fatalClass 5 · ForeignSmith Aerostar 601P · Ceballos, MexicoNTSB 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 GAA22WA158Accident · No injuriesClass 5 · ForeignMonnett Sonerai · Jyväskylä, FinlandNTSB ENG22WA019Accident · 3 fatalClass 5 · ForeignSikorsky S92 · Jeju Island, South KoreaNTSB GAA22WA148Accident · 3 fatalClass 5 · ForeignVans RV10 · Chubut, ArgentinaNTSB GAA22WA147Accident · 1 fatalClass 4 · ForeignHughes 369 · Port McNeil, CanadaNTSB WPR22LA142Accident · Serious injuriesClass 3 · LimitedFinal reportBarber Robert L Sonerai II L · Jean, NVA reported loss of engine power for undetermined reasons.NTSB GAA22WA137Accident · 3 fatalClass 5 · ForeignBeech C90A · Temixco, MexicoNTSB GAA22WA138Accident · 1 fatalClass 5 · ForeignSachse Stephan Aventura II · Klekot, PolandNTSB ERA22LA168Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCVibration in the airframe and flight controls for reasons that could not be determined based on the available evidence.NTSB WPR22LA127Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · St. George, UTThe total loss of engine power for undetermined reasons.NTSB CEN22LA156Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Springtown, TXA total loss of engine power for reasons that could not be determined.NTSB GAA22WA128Accident · 1 fatalClass 5 · ForeignCessna 172RG · Brantford, CanadaNTSB DCA22WA102Accident · 132 fatalClass 5 · ForeignBoeing 737 · Wuzhou, ChinaNTSB ERA22LA162Accident · 1 fatalClass 3 · LimitedFinal reportCzech Sport Piper Sport · Homestead, FLThe airplane’s collision with water for underdetermined reasons.NTSB GAA22WA120Accident · 2 fatalClass 5 · ForeignBeech A36 · Ie, JapanNTSB CEN22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Englewood, COA total loss of engine power on short final for reasons that could not be determined based on the available evidence.NTSB ANC22LA020Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-18-135 · Wasilla, AKA partial loss of engine power for undetermined reasons.NTSB CEN22LA121Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Furlow, ARA loss of engine power for undetermined reasons.NTSB DCA22WA119IncidentClass 5 · ForeignAirbus A320 · Pointe-a-Pitre, GuadeloupeNTSB WPR22LA099Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Napa, CAThe loss of engine power for undetermined reasons, which resulted in an off-airport landing on unimproved terrain.NTSB GAA22WA099Incident · No injuriesClass 5 · ForeignHughes 369HS · Panama City, PanamaNTSB CEN22LA115Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-201 · Olathe, KSThe total loss of engine power for undetermined reasons.NTSB GAA22WA105AccidentClass 5 · ForeignCessna 172N · Reykjavik, IcelandNTSB ENG22WA008IncidentClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaNTSB CEN22FA111Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Hutchinson, MNThe reduction in fuel flow and subsequent partial loss of engine power after takeoff for reasons that could not be determined.NTSB GAA22WA096Accident · 2 fatalClass 5 · ForeignVans RV-6A · Ciudad-Chihuahua state, MexicoNTSB GAA22WA086AccidentClass 5 · ForeignAir Tractor AT602 · Luís Eduardo Magalhães,, BrazilNTSB ANC22LA014Accident · No injuriesClass 3 · LimitedFinal reportBell 205A-1 · El Cajon, CAA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA22FA105Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter Deutschland EC135 P2+ · Drexel Hill, PAAn inflight attitude upset for undetermined reasons that resulted in a rotor system overspeed, a reduction of power from both engines, and a subsequent hard landing.NTSB GAA22WA069Accident · 2 fatalClass 5 · ForeignRobinson R44 · 63 Puy-de-Dome, FranceNTSB GAA22WA072AccidentClass 5 · ForeignRobinson R22 · Karamea, New ZealandNTSB CEN22LA093Accident · No injuriesClass 3 · LimitedFinal reportZenith CH750 · Montrose, COA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN22LA085Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · West Helena, ARThe malfunction of the propeller autofeather system after takeoff for undetermined reasons, which resulted in both propellers going into feather and a hard landing.NTSB GAA22WA057AccidentClass 5 · ForeignLearjet 35A · Cancun, MexicoNTSB ANC22LA011Accident · No injuriesClass 3 · LimitedFinal reportLarry Bingham LB-1 · Haines, AKA partial loss of engine power for reasons that could not be determined based on available information, which resulted in a precautionary landing and impact with snow.NTSB WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.