NTSB investigations
10,140 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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\" = '470' 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" = '470' 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 ERA21LA172Accident · Minor injuriesClass 4 · LimitedFinal reportPhantom Aeronautics Phantom II · McBee, SCThe pilot's failure to maintain adequate clearance from trees while maneuvering in the traffic pattern.NTSB CEN21LA179Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny Powered Parachutes 2000 · Saint Paul, NEThe uncertificated pilot’s failure to maintain control of the powered parachute during low altitude flight in gusting wind conditions.NTSB ERA21LA171Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R66 · Palmyra, PAThe pilot’s improper judgment to attempt a flight while impaired by medications, which resulted in the helicopter’s abnormal ground contact, loss of control, and collision with terrain.NTSB ERA21LA170Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · College Park, MDImproper maintenance of the airplane by its owners and their failure to have qualified maintenance personnel determine the root cause of water infiltration into the fuel system. Also causal was the pilot’s inadequate preflight inspection, which failed to…NTSB CEN21LA176Accident · No injuriesClass 3 · LimitedFinal reportBeech B35 · Pearland, TXThe partial loss of engine power due to a crack in the No. 1 cylinder for unknown reasons.NTSB CEN21LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Austin, TXThe pilot’s failure to maintain directional control while turning onto the taxiway in variable wind conditions.NTSB CEN21LA175Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Augusta, KSInadequate maintenance at the time the carburetor was replaced, which resulted in the improperly installed throttle cable and a partial loss of engine power. Contributing to the accident was an inadequate annual inspection that failed to detect the improper…NTSB ERA21LA167Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Vienna, GAThe pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.NTSB ERA21LA166Accident · Serious injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Fort Pierce, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB ERA21FA165Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1 · Cave Spring, GAThe pilot's inadequate visual lookout and failure to maintain clearance from a power line.NTSB ANC21FA028Accident · Minor injuriesClass 3 · FieldFinal reportPiper PA-18A · Anchorage, AKA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR21FA143Accident · 5 fatalClass 3 · FieldFinal reportAirbus Helicopters AS350-B3 · Palmer, AKThe pilot’s failure to adequately respond to an encounter with whiteout conditions, which resulted in the helicopter’s collision with terrain. Contributing to the accident was the (1) operator’s inadequate pilot training program and pilot competency checks,…NTSB WPR21LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Marana, AZThe student pilot’s improper flare which resulted in a bounced, hard landing and loss of control in a gusting crosswind.NTSB GAA21WA059Accident · No injuriesClass 4 · ForeignBeech 200 · Nairobi, KenyaNTSB ERA21LA162Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 1730 · Bessemer, ALThe pilot’s failure to maintain control of the airplane, which resulted in an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall.NTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.NTSB ERA21LA155Accident · Minor injuriesClass 3 · LimitedFinal reportSocata MS894A · Monroe, GAMaintenance personnel’s failure to properly inspect and maintain the airplane’s engine cowling latches, which resulted in the in-flight separation of the engine cowling and a subsequent forced landing.NTSB ERA21FA154Accident · 3 fatalClass 3 · FieldFinal reportBeech B36 · Pembroke Pines, FLThe pilot’s likely activation of the auxiliary fuel pump to “high” for undetermined reasons during takeoff, which resulted in total loss of engine power due to an excessively rich fuel-to-air mixture. Also causal was the pilot’s exceedance of the airplane’s…NTSB CEN21LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150H · Paris, TXThe pilot’s decision to takeoff with known obstacles on the runway and his subsequent failure to avoid the windsock on takeoff.NTSB CEN21FA150Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1B · Berwyn, NEA loss of control and subsequent impact with terrain as a result of spatial disorientation during cruise in dark night conditions.NTSB ERA21LA143Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C · Panacea, FLThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack during short final approach, which resulted in an aerodynamic stall at low altitude.NTSB GAA21WA038Accident · 1 fatalClass 5 · ForeignRobinson R22 · Bollena, ItalyNTSB ERA21LA145Accident · No injuriesClass 4 · LimitedFinal reportGeorge Matthew Wagoner Zenith 601 HD · Englewood, FLThe pilot’s inadequate compensation for gusty wind conditions, which resulted in a hard landing. The rough terrain of the runway also contributed to the outcome.NTSB ERA21FA140Accident · 3 fatalClass 3 · FieldFinal reportCessna R182 · Gainesville, GAThe pilot’s loss of control due to spatial disorientation. Contributing to the accident was the pilot’s decision to depart into low instrument meteorological conditions.NTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.NTSB WPR21LA118Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-1B · St Johns, AZThe pilot’s decision to operate with a demonstrated crosswind velocity above the airplane’s performance capabilities which resulted in a loss of airplane control and collision with terrain.NTSB CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.NTSB GAA21WA048Accident · No injuriesClass 5 · ForeignRobinson R66 · Khvoyninsky District, RussiaNTSB ERA21FA135Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Mayfield, KYThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall, loss of airplane control, and subsequent impact with terrain.NTSB CEN21LA135Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58 · Greensburg, LAThe pilot’s failure to maintain lateral control and terrain clearance while hovering, which resulted in a dynamic rollover.NTSB DCA21WA086Accident · No injuriesClass 5 · ForeignBoeing 737 · Vijayawada, IndiaNTSB ERA21FA130Accident · 4 fatalClass 3 · FieldFinal reportBell 206 · St Thomas, CBA total loss of engine power due to fatigue failure of two of the stage 3 compressor blades. Contributing to the failure of the compressor blades was the failure of maintenance personnel to inspect the compressor at the recommended interval for operation in…NTSB WPR21LA110Accident · No injuriesClass 3 · LimitedFinal reportDassault FALCON900EX · San Diego, CAThe flight crew’s operation of the airplane outside of the manufacturer’s specified weight and balance limitations and with an improper trim setting, which resulted in the airplane’s inability to rotate during the attempted takeoff. Contributing to the…NTSB CEN21LA128Accident · No injuriesClass 4 · LimitedFinal reportAgustawestland Philadelphia AW119MKII · Alexandria, MNThe helicopter’s impact with an object on departure that could not be determined.NTSB GAA21WA021AccidentClass 5 · ForeignRobinson R22 · Hughenden, AustraliaNTSB GAA21WA018Accident · 2 fatalClass 4 · ForeignBell 206B · Courchevel, FranceNTSB CEN21LA133Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Alamo, TXThe partial loss of engine power due to water-contaminated fuel.NTSB CEN21LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Urbana, OHThe student pilot’s loss of directional control during landing which resulted in an impact with a snowbank. The slippery runway condition contributed to the accident.NTSB ERA21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Leicester, MAThe pilot’s failure to maintain the minimum airspeed for flight in icing conditions, which resulted in a loss of elevator control during approach due to ice accumulation.NTSB CEN21LA120Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Clare, MIThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and impact with terrain.NTSB GAA21WA015Accident · 1 fatalClass 5 · ForeignAir Tractor AT402 · Hoopstad, South AfricaNTSB WPR21LA094Accident · Minor injuriesClass 3 · LimitedFinal reportRandy Wayne Maloney M1 · Eagle Point, ORA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB GAA21WA029Accident · 1 fatalClass 5 · ForeignBell 206 · Wolseley, South AfricaNTSB CEN21LA113Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Newellton, LAThe pilot’s failure to maintain clearance from powerlines/poles and terrain while maneuvering for reasons that could not be determined based on available evidence.NTSB ERA21LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Richmond Hill, GAThe pilot’s mismanagement of the fuel supply, which resulted in fuel starvation.NTSB WPR21LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCreek Michel W Bearhawk · Elko, NVThe pilot’s unstable approach to land, which resulted in a loss of directional control and subsequent nose over. Contributing to the accident was the pilot’s decision to continue an approach in sun glare conditions.NTSB ERA21LA103Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hollywood, FLThe inadequate maintenance and inspection of the fuel system, which resulted in a partial loss of engine power. Contributing was the pilot's mismanagement of the emergency approach and landing, which resulted in a runway overrun.NTSB WPR21WA090Accident · Serious injuriesClass 5 · ForeignCessna 210 · Chibuya, ZimbabweNTSB CEN21LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Sparta, MIThe pilot’s failure to maintain the proper glideslope during final approach, which resulted in contact with a snowbank at the approach end of the runway.NTSB WPR21LA082Accident · 1 fatalClass 3 · LimitedFinal reportCessna 560 · Warm Springs, ORA loss of airplane control due to pilot incapacitation for reasons that could not be determined.