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 CEN09LA502Accident · Serious injuriesLimited investigationFinal reportCessna 337F · Frankfort, MIThe pilot intentionally attempting to take off with an inoperative engine, which lead to the airplane's inability to maintain airspeed in the initial climb, resulting in a stall and impact with trees.NTSB CEN09LA487Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Black River Falls, WIThe loss of engine power during cruise due to the number two cylinder piston connecting rod failure for undetermined reasons.NTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.NTSB CEN09CA500Accident · No injuriesData collectionFinal reportCessna P210N · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC09CA075Accident · No injuriesData collectionFinal reportCessna 180 · Buckland, AKThe improper installation of the right brake cylinder, which allowed a portion of the cylinder to disengage and jam the right rudder/brake pedal, resulting in a loss of directional control during landing. Contributing to the accident was an inadequate…NTSB ERA09CA426Accident · No injuriesData collectionFinal reportCessna 150M · Lexington, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel manangement.NTSB ERA09CA425Accident · Minor injuriesData collectionFinal reportCessna 177 · Towanda, PAThe failure of the pilot to maintain control of the airplane during a go around following a bounced landing.NTSB CEN09CA472Accident · No injuriesData collectionFinal reportFisher RV-7A · Brodhead, WIThe pilot's improper landing flare and recovery from a bounced landing.NTSB ERA09CA422Accident · Minor injuriesData collectionFinal reportDart GW · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the wet turf landing surface.NTSB CEN09LA466Accident · 1 fatalLimited investigationFinal reportLuscombe 8C · Mount Carmel, ILThe reason for this accident was not determined.NTSB CEN09LA463Accident · No injuriesLimited investigationFinal reportPilgrim Samuel W JR RV-6 · Oshkosh, WIThe failure of the rudder pedal which resulted in the pilot's inability to maintain directional control of the aircraft.NTSB CEN09FA462Accident · 1 fatalField investigationFinal reportBeech V35 · Oklahoma City, OKThe pilot’s decision to operate an airplane with known deficiencies, and the loss of engine power during climb for undetermined reasons.NTSB WPR09LA371Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Chelan, WAFailure of a seal in the hydraulic system resulting in a loss of hydraulic pressure while maneuvering at low altitude.NTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.NTSB WPR09CA367Accident · No injuriesData collectionFinal reportXtremeair XP-30/2002339 · Santa Ynez, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB WPR09CA366Accident · Minor injuriesData collectionFinal reportRans S-12 XL Airaile · Marana, AZThe pilot's failure to maintain directional control during takeoff.NTSB ERA09LA420Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Fort Pierce, FLA loss of engine power due to fuel starvation as a result the failure of the engine fuel pump diaphragms during climb.NTSB CEN09CA474Accident · No injuriesData collectionFinal reportBeech H-18 · Dayton, OHThe pilot's failure to lock the tailwheel during landing resulting in the loss of directional control.NTSB WPR09CA363Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Metaline Falls, WAThe pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.NTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.NTSB CEN09CA587Accident · No injuriesData collectionFinal reportTolbert Robert R Rans S-6 · Santa Rosa, NMThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during takeoff.NTSB CEN09CA455Accident · No injuriesData collectionFinal reportForster SA-300 · Iowa City, IAthe loss of engine power for undetermined reasons.NTSB CEN09CA452Accident · Minor injuriesData collectionFinal reportWeatherly 620B · New England, NDThe loss of engine power for undetermined reasons while maneuvering at low altitude.NTSB ERA09LA412Accident · 1 fatalLimited investigationFinal reportJames O'Bert Vari-Eze · Columbus, GAThe pilots improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA09LA410Accident · No injuriesLimited investigationFinal reportRobinson R44 · Silver Spring, PAThe student pilot's inability to fully control the helicopter, during cruise and the resultant off-field hard landing.NTSB WPR09LA357Accident · 2 fatalLimited investigationFinal reportWeiss Lancair · Santa Clarita, CAThe pilot's failure to maintain adequate airspeed and control while maneuvering.NTSB WPR09LA355Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Truckee, CAA loss of engine power during initial climb for undetermined reasons.NTSB CEN09LA445Accident · Serious injuriesLimited investigationFinal reportMarvin Faulk Tinker Bell · La Porte, TXThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in a collision with terrain.NTSB WPR09LA350Accident · Minor injuriesLimited investigationFinal reportBielawa Rotorway E · Sequim, WAThe failure (disbonding) of a composite main rotor blade for undetermined reasons, leading to an immediate loss of control in flight during hover.NTSB CEN09LA447Accident · No injuriesLimited investigationFinal reportCessna A188B · Suring, WIA loss of engine power resulting from the fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the engine failure was the operator's failure to overhaul the engine in accordance with the manufacturer's…NTSB ANC09TA068Accident · No injuriesFinal reportCessna 180A · Anchorage, AKThe pilot's failure to maintain directional control while landing in a crosswind, which resulted in a ground-loop.NTSB WPR09FA347Accident · 3 fatalField investigationFinal reportRaytheon G36 · Hawthorne, CAThe pilot’s failure to maintain an adequate airspeed during a go-around, which resulted in a loss of airplane control. Contributing to the accident was the inadvertent activation of the fuel boost pump during the attempted go-around.NTSB WPR09CA351Accident · No injuriesData collectionFinal reportCox John Wiley Kitfox III · Laurel, MTThe pilot's failure to maintain directional control during an attempted go-around from a landing.NTSB WPR09CA349Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Snohomish, WAA complete loss of engine power due to the failure of the airplane's engine-driven fuel pump.NTSB CEN09LA446Accident · No injuriesLimited investigationFinal reportBeech S35 · Tuscola, ILThe pilot failure to maintain proper speed and distance during approach to land which resulted in landing long and subsequent runway excursion.NTSB CEN09LA440Accident · 1 fatalLimited investigationFinal reportAntares MA-33 · Centerburg, OHThe pilot's failure to maintain adequate airspeed resulting in an aerodynamic stall.NTSB WPR09LA343Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Yellow Pine, IDThe pilot's failure to maintain clearance from the trees while taking off in a high-density altitude. Contributing to the accident were the pilot's failure to perform pre-takeoff performance calculations, his positioning of the elevator trim in a nose-down…NTSB ERA09CA403Accident · Minor injuriesData collectionFinal reportSmith PA18 replica · Chesterville, METhe pilot's failure to maintain aircraft control while turning from base leg to final approach.NTSB ERA09CA402Accident · No injuriesData collectionFinal reportCessna T337 · Pittsburgh, PAThe pilot's failure to obtain the proper touchdown point during landing.NTSB CEN09LA442Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Boyd, TXA total loss of engine power due to the pilot's improper leaning procedures, resulting in a forced landing and collision with a fence.NTSB ANC09FA062Accident · 2 fatalField investigationFinal reportZenair Stol CH 701 · Wasilla, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall during takeoff and his decision to fly the airplane over its allowable gross weight. Contributing to the accident was the airplane's excessive gross weight.NTSB CEN09CA435Accident · No injuriesData collectionFinal reportFlight Design Ctsw · North Vernon, INThe pilot's improper landing flare which resulted in a stall and nose over during touchdown.NTSB ERA09CA395Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Rutherford, NCThe pilot's failure to maintain adequate airspeed while performing a go-around which resulted in a stall.NTSB ANC09LA065Accident · No injuriesLimited investigationFinal reportNoorduyn UC-64A · Akiachak, AKThe loss of engine power due to the failure of a crankshaft component, resulting in an off-airport landing.NTSB WPR09CA346Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Sulphur Creek, IDThe pilot's failure to maintain directional control during the landing roll.NTSB ERA09LA394Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Hertford, NCThe in-flight collision with terrain for undetermined reasons.NTSB CEN09LA427Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540 · Tarkio, MOThe pilot's failure to maintain aircraft control during the aerobatic flight.NTSB CEN09FA425Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Simla, COThe pilot’s failure to maintain control of the airplane while practicing aerobatic maneuvers and his subsequent failure to recover from an inadvertent spin.NTSB WPR09FA334Accident · 2 fatalField investigationFinal reportCessna 182P · Mammoth Lakes, CAThe pilot's improper in-flight planning/decision to attempt to fly at a low altitude in a confined area of mountainous terrain in a high density altitude weather condition, and his failure to maintain clearance from the trees.NTSB WPR09CA333Accident · No injuriesData collectionFinal reportBell 47G-2 · Turlock, CAThe pilot's failure to maintain rotor RPM while maneuvering at a low altitude.