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 GAA22WA019Accident · 1 fatalClass 5 · ForeignCessna 208 · Papua, Papua New GuineaNTSB ERA22LA029Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Westhampton Beach, NYA total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.NTSB CEN22LA012Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Wildwood, ARA total loss of engine power for reasons that could not be determined.NTSB GAA22WA010Accident · No injuriesClass 5 · ForeignCessna 150 · Rio De Janeiro, BrazilNTSB GAA21WA242AccidentClass 5 · ForeignMooney M20M · Tököl, HungaryNTSB ERA21LA384Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Hobe Sound, FLA reported loss of engine performance for reasons that could not be determined.NTSB GAA21WA241AccidentClass 5 · ForeignVans RV8 · Hyvinkää, FinlandNTSB GAA21WA235Accident · 2 fatalClass 5 · ForeignPiper PA18S · Ferme Neuve, CanadaNTSB WPR21LA354Accident · No injuriesClass 3 · LimitedFinal reportHiller UH-12E · Bovill, IDA loss of helicopter control for undetermined reasons based on the available evidence for this accident.NTSB ANC21LA096Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-14 · Chickaloon, AKA total loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB GAA22WA020Accident · 2 fatalClass 5 · ForeignBely lebed · Sovetsky, RussiaNTSB GAA21WA231Accident · 1 fatalClass 5 · ForeignMooney M20J · Sundridge, CanadaNTSB GAA21WA229Accident · 7 fatalClass 3 · ForeignBeech B200GT · Piracicaba, BrazilNTSB GAA21WA237Accident · 1 fatalClass 5 · ForeignCessna 182 · Itaituba, BrazilNTSB GAA21WA224AccidentClass 5 · ForeignCessna 172S · Ruckinge, Kentu, United KingdomNTSB CEN21LA414Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · LaSalle, COA loss of engine power for undetermined reasons.NTSB CEN21LA404Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Delta, COA total loss of engine power that resulted in a forced landing and subsequent noseover. The reason for the total loss of engine power could not be determined based on the available evidence.NTSB CEN21LA405Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A35 · Morrilton, ARThe total loss of engine power for reasons that could not be determined based on available information.NTSB WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.NTSB CEN21LA390Accident · Minor injuriesClass 3 · LimitedFinal reportMantooth Thorp T-18 · San Antonio, TXThe loss of engine power after takeoff for undetermined reasons.NTSB WPR21LA326Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Del Mar, CAThe partial loss of engine power for reasons that could not be determined, which resulted in a forced landing on an interstate highway and subsequent collision with vehicles.NTSB GAA21WA211Accident · 2 fatalClass 5 · ForeignPiper PA24 · Maldonado, UruguayNTSB CEN21FA380Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Adrian, MOThe pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and impact with terrain.NTSB GAA21WA209Accident · 1 fatalClass 5 · ForeignAcroduster II · Marcoola, AustraliaNTSB GAA21WA208Accident · 1 fatalClass 5 · ForeignRockwell 690 · Thunder Bay, CanadaNTSB CEN21LA372Accident · Serious injuriesClass 3 · LimitedFinal reportFlying K Enterprises Sky Raider · Augusta, KSA partial loss of engine power for reasons that could not determined based on available information.NTSB CEN21LA369Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Wheeling, ILA partial loss of engine power for reasons that could not be determined based on available information.NTSB ERA21LA322Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA42 · Hiddenite, NCThe flight instructor’s inability to stop the descent following a practice emergency descent for reasons that could not be determined.NTSB CEN21LA367Accident · Minor injuriesClass 3 · LimitedFinal reportPulsar Sport 150 · Osceola, WIThe total loss of engine power for undermined reasons based on available informationNTSB GAA21WA195Accident · 2 fatalClass 5 · ForeignTecnam P2002 · Khabarovsk, RussiaNTSB WPR21LA299Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Tracy, CAA loss of thrust during a low-level agricultural application flight, which resulted in a descent and impact with terrain. The reason for the loss of thrust could not be determined based on available information.NTSB GAA21WA186Accident · 1 fatalClass 5 · ForeignCessna 208 · Norderney, GermanyNTSB CEN21LA473Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35-A33 · Mineral Wells, TXA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN21LA325Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35-C33 · Longmont, COThe airplane’s lack of climb performance after takeoff in high density altitude conditions for reasons that could not be determined based on the available evidence.NTSB CEN21FA327Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8F · Comstock, TXImpact with terrain for reasons that could not be determined based on the available information.NTSB GAA21WA170Accident · 1 fatalClass 5 · ForeignJoplin Tundra · Athens, CanadaNTSB GAA21WA169Accident · 9 fatalClass 5 · ForeignDe Havilland DHC2 · Örebro, SwedenNTSB CEN21LA307Accident · Serious injuriesClass 4 · LimitedFinal reportQuad City Challenger · Ste. Genevieve, MOAn impact with terrain for reasons that could not be determined based on available evidence.NTSB CEN21LA321Accident · No injuriesClass 4 · LimitedFinal reportSwann Lynn J Seawind 3000 · Charlevoix, MIThe loss of engine power for undetermined reasons based on available evidence.NTSB CEN21LA303Accident · No injuriesClass 3 · LimitedFinal reportAeronca 15AC · Hastings, MIA total loss of engine power for reasons that could not be determined based on the available information.NTSB ANC21LA047Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Sterling, AKA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ENG21WA029IncidentClass 5 · ForeignBoeing 737 · Ciudad de México, MexicoNTSB ERA21LA267Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Easton, MDA total loss of engine power for reasons that could not be determined.NTSB CEN21LA288Accident · No injuriesClass 3 · LimitedFinal reportVining SD1 Minisport · Butler, OHThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall and impact with terrain. The reason for the partial loss of engine power could not be determined based on available information.NTSB GAA21WA147Accident · 2 fatalClass 5 · ForeignNorth American T28 · Jickovice, CzechiaNTSB CEN21FA270Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor 502B · Paragould, ARAn inflight loss of control and subsequent impact with terrain during an aerial application flight for reasons that could not be determined based on the available evidence.NTSB GAA21WA138AccidentClass 5 · ForeignBell 214 · Nipigon, CanadaNTSB CEN21LA254Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Drew, MSA loss of control during takeoff for reasons that could not be determined.NTSB CEN21LA257Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Wallingford, IAImpact with trees and terrain during takeoff for reasons that could not be determined based on the available information.NTSB WPR21LA220Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24 · Paris, IDA total loss of engine power for reasons that could not be determined.