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 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 CEN22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Ash Flat, ARThe partial loss of engine power during a go-around resulting in an inadvertent entry into an aerodynamic stall. Contributing to the accident was the inexperience of the low-time pilot.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 CEN22LA103Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 120 · Sturtevant, WIThe pilot’s loss of directional control during the takeoff for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.NTSB 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 ERA22LA099Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20C · Southeast Arcadia, FLThe total loss of engine power for reasons that could not be determined based on the available evidence for this investigation.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.NTSB GAA22WA043Accident · 1 fatalClass 5 · ForeignRobinson R66 · Mrassu, RussiaNTSB GAA22WA041AccidentClass 5 · ForeignPiper PA34 · Gauteng, South AfricaNTSB GAA22WA037Accident · 3 fatalClass 5 · ForeignCessna A185 · Laguna Negra, ParaguayNTSB CEN22FA053Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · Perry, OKA loss of lateral control during a hover that resulted in an impact with terrain. Based on the available evidence, the reason for the loss of lateral control could not be determined.NTSB GAA22WA060Accident · 3 fatalClass 4 · ForeignPiper PA34 · Ubatuba, BrazilNTSB WPR22LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Tooele, UTThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB GAA22WA059AccidentClass 5 · ForeignCessna A188 · Joao Pinheiro, BrazilNTSB GAA22WA032Accident · 2 fatalClass 5 · ForeignCessna 182 · Hope, CanadaNTSB WPR22LA034Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Molalla, ORThe loss of engine power for undetermined reasons.NTSB CEN22LA039Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36TC · Rockport, TXThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN22LA038Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · West Union, OHA malfunction of the flight controls for reasons that could not be determined based on available information.NTSB ERA22LA039Accident · No injuriesClass 3 · LimitedFinal reportBell 47D1 · Zelienople, PAA total loss of engine power for reasons that could not be determined.NTSB ENG22WA003Incident · 2 fatalClass 5 · ForeignBoeing 727 · Ciudad de la Costa, UruguayNTSB GAA22WA021Accident · 1 fatalClass 3 · ForeignBell 206 · Eswatini, South Africa