NTSB investigations
10,134 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 CEN10LA166Accident · No injuriesLimited investigationFinal reportCessna 421B · Artesia, NMA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.NTSB WPR10FA162Accident · 2 fatalField investigationFinal reportNorth American AT6 · Bakersfield, CAThe pilots did not maintain clearance from terrain for undetermined reasons.NTSB ANC10LA025Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A-21 · Kodiak, AKThe pilot's failure to maintain clearance from rising terrain during takeoff resulting in collision with trees.NTSB CEN10LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Ninnekah, OKA loss of engine power due to fuel exhaustion, resulting from the pilot’s inadequate preflight inspection.NTSB ANC10FA022Accident · 1 fatalField investigationFinal reportAntares MA-32 · Chugiak, AKThe pilot's decision to pitch the aircraft excessively during a steep climbing maneuver, resulting in a loss of control and an aerodynamic tumble.NTSB WPR10FA158Accident · 1 fatalField investigationFinal reportBeech K35 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management; also causal was his subsequent failure to maintain clearance from power lines.NTSB CEN10CA160Accident · No injuriesData collectionFinal reportUltralight America Spitfire II Modelctv · Cameron, TXThe pilot's failure to maintain control while maneuvering during a forced landing after a partial loss of engine power.NTSB CEN10CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Houston, TXThe student pilot's loss of directional control during takeoff, resulting in a dynamic rollover of the helicopter.NTSB ANC10CA023Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Aniak, AKThe pilot's decision to maneuver at a low altitude during gusting wind conditions, resulting in a collision with terrain.NTSB WPR10LA156Accident · 1 fatalLimited investigationFinal reportNorth American P51D · Chandler, AZThe pilot’s improper flare, resulting in a bounced landing, stall, and loss of directional control.NTSB CEN10CA152Accident · No injuriesData collectionFinal reportBeech A35 · Marfa, TXThe pilot's failure to extend the landing gear.NTSB ANC10LA024Accident · No injuriesLimited investigationFinal reportCessna A185E · Ophir, AKThe total loss of engine power for an undetermined reason.NTSB WPR10CA153Accident · No injuriesData collectionFinal reportAviat A-1C-200 · St. Johns, AZThe pilot's inadequate compensation for the crosswind gusts and failure to maintain proper runway alignment during takeoff.NTSB ERA10CA168Accident · No injuriesData collectionFinal reportAeronca 7AC · Roanoke Rapids, NCThe pilot’s failure to maintain directional control during a crosswind landing/rollout.NTSB ERA10LA166Accident · Minor injuriesLimited investigationFinal reportBelcher William B II Firestar · Wetumpka, ALThe student pilot’s in-flight loss of control as a result of previous damage to the airplane from an undetermined event.NTSB ERA10FA163Accident · 2 fatalField investigationFinal reportNorth American T6 · Santa Rosa Beach, FLThe pilot's failure to maintain airspeed during a low altitude,over water aerobatic maneuver, which resulted in an aggravated stall/spin. Contributing to the accident were the pilot's loss of situational awareness and his decision to perform aerobatics at a…NTSB CEN10FA139Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Cotulla, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning. Contributing to the accident was the low-altitude operating environment that would not allow for a successful autorotation after the loss of engine power.NTSB ERA10LA164Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Savannah, GAThe pilot's failure to maintain airspeed and inadvertent stall after takeoff.NTSB ERA10LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Vero Beach, FLThe certified flight instructor's failure to monitor the airspeed while the student performed a single-engine approach.NTSB CEN10FA141Accident · 2 fatalField investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Marysville, OHThe pilot's improper decision to initiate and continue a flight into instrument meteorological conditions that led to spatial disorientation and a loss of control during cruise flight.NTSB ERA10FA161Accident · 1 fatalField investigationFinal reportCessna T303 · Louisa, VAThe pilot's failure to maintain aircraft control and secure the right engine during a loss of engine power after takeoff. Contributing to the accident was the loss of engine power on the right engine for undetermined reasons.NTSB ERA10LA159Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Arcadia, FLThe total loss of engine power due to a fatigue fracture of the crankshaft resulting from worn bearings.NTSB ERA10LA158Accident · 1 fatalLimited investigationFinal reportMonroig Pedro J Rans S-6S · Mayaguez, PRThe sport pilot's failure to maintain adequate airspeed during landing in crosswind conditions resulting in an aerodynamic stall.NTSB CEN10LA143Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · DeKalb, ILThe collapse of the landing gear during landing due to the company's improper maintenance practices and the pilot's decision to take off with an overextended landing gear strut.NTSB CEN10CA155Accident · No injuriesData collectionFinal reportSchulke Avid Magnum · Lowell, MIThe pilot's inability to maintain directional control while landing on a slush-covered runway due to inadequate maintenance of the airplane brakes by maintenance personnel.NTSB WPR10LA149Accident · Minor injuriesLimited investigationFinal reportSchafer Starduster SA-300 · North Bend, ORThe complete loss of engine power during cruise for undetermined reasons.NTSB ERA10FA154Accident · 1 fatalField investigationFinal reportBeech P35 · Edgewater, MDThe pilot's failure to maintain adequate airspeed while on approach, which resulted in an inadvertent stall. Contributing to the accident was the pilot's likely impairment due to back pain, symptoms of opiate withdrawal, or both.NTSB ERA10CA231Accident · Minor injuriesData collectionFinal reportCessna 340A · Grove City, PAThe pilot's failure to maintain directional control after electing to land on a snow-covered runway.NTSB CEN10LA129Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gatesville, TXThe pilot’s incapacitation as a result of one or more pre-existing medical conditions.NTSB ERA10FA150Accident · 2 fatalField investigationFinal reportBeech C23 · Winter Haven, FLThe pilot’s improper placement of the fuel selector valve during takeoff, and his failure to maintain adequate airspeed following a total loss of engine power resulting in an inadvertent stall. Contributing to the accident was the failure of maintenance…NTSB WPR10CA146Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Delta, UTThe student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…NTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…NTSB WPR10CA145Accident · No injuriesData collectionFinal reportTerrell Caragol RV-7 · Oregon City, ORThe pilot’s failure to attain a proper touchdown point.NTSB CEN10FA125Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Belleville, ILThe pilot’s spatial disorientation and subsequent failure to maintain airplane control during the instrument approach.NTSB WPR10FA142Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Groveland, CAThe pilot's continued flight into night instrument meteorological conditions during the landing approach, which resulted in an in-flight loss of aircraft control due to spatial disorientation.NTSB WPR10LA139Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colfax, WAA partial loss of engine power due to carburetor ice as a result of the pilot's failure to use carburetor heat.NTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB CEN10LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Albany, OHThe pilot’s decision to initiate and continue the flight into known icing conditions with an airplane not properly equipped for flight into icing conditions which exceeded the capabilities of the airplane.NTSB CEN10FA124Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Austin, TXThe pilot’s intentional flight into a building.NTSB WPR10LA137Accident · No injuriesLimited investigationFinal reportFouga CM 170 Magister · Imperial, CAThe pilot's inadequate preflight inspection and his failure to ensure that the speed brakes were retracted, which resulted in a loss of control during takeoff.NTSB WPR10FA136Accident · 3 fatalField investigationFinal reportCessna 310R · Palo Alto, CAThe pilot’s failure follow the standard instrument departure as instructed, and his failure to attain a sufficient altitude to maintain clearance from power lines during takeoff in instrument meteorological conditions.NTSB ERA10FA140Accident · 5 fatalField investigationFinal reportCessna T337G · Farmingdale, NJThe pilots’ failure to adhere to the airplane’s operating limitations, which resulted in overload failure of the right wing. Findings of the investigation were the adverse effects of multiple supplemental type certificates (STC) to the airframe wing structure…NTSB WPR10FA133Accident · 5 fatalField investigationFinal reportEurocopter EC135 · Cave Creek, AZThe sudden and inadvertent lowering of the collective to near the lower stop, followed by a simultaneous movement of the collective back up and the cyclic control to a nearly full-aft position, which resulted in the main rotor disc diverging from its normal…NTSB CEN10CA120Accident · No injuriesData collectionFinal reportAviat A1 · Austin, TXThe pilot's failure to maintain directional control during landing and his failure to properly execute a go-around.NTSB CEN10FA119Accident · 1 fatalField investigationFinal reportPiper PA-31T · Forest City, IAThe pilot's failure to maintain airplane control during final approach.NTSB ANC10TA017Accident · No injuriesFinal reportPiper PA-18-150 · King Cove, AKA total loss of engine power due to the pilot's failure to use carburetor heat in conditions conducive to carburetor ice.NTSB ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.NTSB WPR10LA130Accident · Minor injuriesLimited investigationFinal reportNanchang China CJ-6A · Mesa, AZSeparation of the cylinder from the engine during cruise flight due to fatigue in the studs attaching it to the engine casing.NTSB CEN10FA114Accident · 4 fatalField investigationFinal reportBeech A36 · Winslow, ARThe instrument-rated pilot's spatial disorientation and subsequent loss of airplane control during flight in instrument meteorological and conditions favorable for structural icing.