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 WPR16FA126Accident · 1 fatalField investigationFinal reportPiper PA 23-150 · Hayward, CAThe failure of the left engine due to water contamination and the pilot's subsequent failure to maintain single-engine minimum control airspeed, which resulted in an uncontrolled descent. Contributing to the accident was the pilot's lack of total and recent…NTSB CEN16LA222Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6D · Henley, MOThe pilot’s decision to conduct extended inverted flight, which resulted in a total loss of engine power due to fuel flow disruption. Contributing to the accident was his decision to conduct aerobatic maneuvers at low altitude, which precluded him from…NTSB WPR16LA128Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Prescott, AZThe pilots' improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA16CA322Accident · Serious injuriesData collectionFinal reportMarks Steven Challenger · Marion, WIThe failure of the airplane engine drive belt during the takeoff, resulting in a forced landing and impact with terrain.NTSB CEN16LA230Accident · No injuriesLimited investigationFinal reportGlaeser Nieuport 11 · Gardner, KSThe pilot's diverted attention during the approach for the precautionary landing, which resulted in low airspeed, an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall. Contributing to the accident was the control system…NTSB GAA16CA342Accident · No injuriesData collectionFinal reportSchleicher ASW 28 · Cuddybackville, NYThe pilot's failure to maintain the glide path required for landing in the off-field landing zone.NTSB GAA16CA326Accident · No injuriesData collectionFinal reportSchweizer G 164 · Cummings, NDThe pilot's failure to maintain an adequate rate of descent while landing, which resulted in a hard landing, short of the runway.NTSB GAA16CA323Accident · Minor injuriesData collectionFinal reportMooney M20 · Reedsburg, WIThe pilot's long landing and failure to stop the airplane on the runway, resulting in an overrun, impact with a fence, and substantial damage to the airplane.NTSB GAA16CA504Accident · No injuriesData collectionFinal reportCessna 152 · Immokalee, FLThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB GAA16CA320Accident · No injuriesData collectionFinal reportBeech 77 · Santa Fe, NMThe pilot's decision to takeoff over the maximum takeoff weight in high density altitude conditions, which resulted in an inability to climb above terrain, a forced landing, and a collision with a road sign. Contributing to the accident was the pilot's…NTSB ERA16LA220Accident · No injuriesClass 3 · LimitedFinal reportChampion 7AC · Gorham, NHThe partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to abort the takeoff after the airplane’s initial failure to climb.NTSB GAA16CA321Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Delhi, LAThe pilot's inability to maintain directional control during the landing roll as a result of a piece of concrete from the runway impacting the right main landing gear brake during the landing roll, resulting in a right brake failure and a ground loop.NTSB CEN16LA221Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw HXB · Sealy, TXFailure of maintenance personnel to comply with the engine manufacturer’s mandatory service bulletin, which resulted in failure of the mechanical fuel pump diaphragm and a subsequent total loss of engine power.NTSB CEN16FA224Accident · 3 fatalField investigationFinal reportCessna 320E · Creede, COThe pilot's loss of airplane control during descent following a loss of engine power for reasons that could not be determined because postaccident examinations and engine test-runs of both engines revealed no evidence of any mechanical malfunctions or…NTSB WPR16LA125Accident · No injuriesLimited investigationFinal reportBell 206 · Bishop, CAThe pilot’s improper preflight weather planning, fuel planning, and fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the severity of the accident was the pilot's initiation of the landing flare at a high altitude,…NTSB GAA16CA385Accident · No injuriesData collectionFinal reportRockwell International 114 · Munday, TXThe pilot's failure to maintain directional control during takeoff, which resulted in an aborted takeoff, runway excursion, collision with a fence, and substantial damage.NTSB GAA16CA317Accident · Minor injuriesData collectionFinal reportRyan Navion · McMinnville, ORThe pilot's failure to replace the oil filler cap following the preflight inspection, which resulted in a loss of engine oil and engine power, an emergency landing, and impact with terrain.NTSB GAA16CA319Accident · No injuriesData collectionFinal reportAmerican AA 1 · Denton, MTThe pilot's premature rotation and failure to attain sufficient airspeed required for a sustained climb, resulting in a runway overrun and collision with a fence.NTSB ERA16LA212Accident · Serious injuriesLimited investigationFinal reportPiper PA28RT · Taylorsville, KYThe pilot's improper decision to continue a takeoff with a partial loss of engine power that occurred early in the takeoff roll. The reason for the partial loss of engine power could not be determined because postaccident fire damage to the engine precluded…NTSB ERA16CA227Accident · No injuriesData collectionFinal reportPezetel SZD 48-1JANTAR STD 2 · Maysville, WVThe glider's encounter with insufficient atmospheric lift conditions where the lift was not sufficient to maintain soaring flight, which resulted in an off-airport landing.NTSB WPR16FA124Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 1B · Hawthorne, CAThe failure of both pilots to land the airplane on the remaining runway when a sufficient rate of climb could not be attained. Contributing to the accident was a reduction of available engine power due to severe camshaft lobe wear.NTSB GAA16CA312Accident · No injuriesData collectionFinal reportPiper PA 28 · Gilmer, TXThe student pilot's failure to see and avoid powerlines during landing, and the flight instructor's delayed remediation when the student cut the base to final turn short, resulting in a wire strike and collision with terrain. Contributing to the accident was…NTSB GAA16CA309Accident · No injuriesData collectionFinal reportMaule MX 7 · Ontario, ORThe pilot's failure to maintain directional control during landing, which resulted the right wing impacting the ground, and nose down.NTSB GAA16CA306Accident · Minor injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 150 · York, SCThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with a peach tree(s).NTSB ERA16FA208Accident · 3 fatalField investigationFinal reportMooney M20E · Collegedale, TNThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering after a go-around, which resulted in an aerodynamic stall.NTSB CEN16LA218Accident · No injuriesLimited investigationFinal reportAeronca 7AC · East St. Louis, ILA total loss of engine power due to fracture of the piston pin, which led to fatigue cracking and eventual fracture of the adjacent connecting rod.NTSB ERA16LA213Accident · No injuriesLimited investigationFinal reportCessna 310 · Apopka, FLThe intermittent failure of the left brake master cylinder, which resulted in asymmetric braking and the subsequent loss of directional control during the landing roll.NTSB ERA16LA209Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M 18A · Brunswick, NCThe failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…NTSB ERA16CA214Accident · Minor injuriesData collectionFinal reportHanson Robert H Pietenpol Aircamper · Dundee, MSThe pilot’s failure to maintain clearance from a power line.NTSB ERA16CA211Accident · Serious injuriesData collectionFinal reportPiper PA-28 · Williamsburg, VAThe pilot's failure to maintain adequate airspeed during a go-around which led to the airplane exceeding its critical angle-of-attack and experiencing aerodynamic stall.NTSB CEN16FA214Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Marion, ILThe pilots' failure to maintain adequate airspeed while executing a simulated engine failure and landing maneuver, which resulted in the wing's critical angle of attack being exceeded and a subsequent aerodynamic stall and loss of control.NTSB GAA16CA337Accident · No injuriesData collectionFinal reportCessna T210 · Buena Vista, COThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and substantial damage to the firewall.NTSB GAA16CA314Accident · No injuriesData collectionFinal reportPiper PA 32 · Lincoln Park, NJThe airplane struck a deer during the landing flare resulting in substantial damage.NTSB GAA16CA302Accident · No injuriesData collectionFinal reportPiper PA 28 · Rowesville, SCThe fuel line failure between the fuel transducer and the carburetor, which resulted in a total loss of engine power and subsequent forced off airport landing.NTSB GAA16CA300Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Moundsville, WVThe pilot's failure to maintain directional control during the go-around in gusty crosswind conditions, which resulted in a collision with trees.NTSB GAA16CA298Accident · No injuriesData collectionFinal reportCessna 182 · Stanley, IDThe pilot's failure to attain an adequate climb gradient, which resulted in a collision with a tree and subsequent substantial damage to the left wing and aileron.NTSB CEN16FA212Accident · 3 fatalField investigationFinal reportPiper PA 28-140 · Wishek, NDThe pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…NTSB CEN16FA211Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Houston, TXThe pilot's improper go-around procedure that did not ensure that the airplane was at a safe airspeed before raising the flaps, which resulted in exceedance of the critical angle of attack and resulted in an accelerated aerodynamic stall and spin into…NTSB GAA16LA329Accident · Serious injuriesLimited investigationFinal reportMini Max 1200 · Batesville, INThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to depart without obtaining flight training in the…NTSB GAA16CA316Accident · No injuriesData collectionFinal reportCessna 172 · Cornelia, GAThe student pilot's unnecessary pedal application and the flight instructor's delayed remedial action resulting in a loss of directional control, runway excursion and ground impact during the aborted landing.NTSB GAA16CA295Accident · No injuriesData collectionFinal reportCessna 172 · Thomson, GAThe student pilot's incorrect landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing, nose wheel collapse, and runway excursion.NTSB GAA16CA294Accident · No injuriesData collectionFinal reportBellanca 17 30 · Fredericksburg, VAThe pilot's failure to maintain directional control during the landing roll in gusting wind resulting in a runway excursion and substantial damage.NTSB GAA16CA293Accident · No injuriesData collectionFinal reportBell 47G · Hastings, MNThe pilot's failure to attain a positive rate of climb during takeoff from a service truck, which resulted in an impact with terrain and substantial damage to the tail boom and fuselage.NTSB GAA16CA292Accident · No injuriesData collectionFinal reportAeronca 7BCM · Rochester, WIThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, left main landing gear collapse, and a nose down. Contributing to the accident was the wind shift.NTSB CEN16FA210Accident · 1 fatalField investigationFinal reportCessna 175 · Pine Bluff, ARA loss of engine power during cruise flight for reasons that could not be determined because a test run of the engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation. Contributing to the accident were the…NTSB GAA16CA297Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Chireno, TXThe student pilot's selection of unsuitable terrain for landing, which resulted in the helicopter rolling over during landing, and substantial damage to the tail boom.NTSB GAA16CA296Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Cahokia/St. Louis, ILThe flight instructor's delayed remedial action and his failure to remain vigilant as the helicopter entered the weathercock stability region, in gusting wind conditions, resulting in loss of tail rotor effectiveness and ground impact.NTSB GAA16CA291Accident · Minor injuriesData collectionFinal reportBilly Amerson Stol CH 750 · Manning, SCThe pilot's failure to maintain directional control during landing, which resulted in an impact with a fence and trees.NTSB GAA16CA290Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Beaumont, TXThe non-pilot owner's decision to start the helicopter while awaiting the pilot's arrival, which resulted in a loss of yaw control and a rollover.NTSB CEN16FA209Accident · 1 fatalField investigationFinal reportPruss Richard S Kitfox IV · De Smet, SDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a steep turn at a low altitude, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.