NTSB investigations
1,269 cases where NTSB found Performance/control parameters, general.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062000')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062000')) 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 CEN09CA509Accident · No injuriesData collectionFinal reportCessna 172S · Bluffton, OHThe student pilot's failure to compensate for wind conditions and maintain aircraft control during the landing.NTSB CEN09CA504Accident · Minor injuriesData collectionFinal reportVanderhoof Steve AIR Comman · Mentone, INThe pilot's failure to maintain aircraft control during the landing and subsequent impact with a parked aircraft.NTSB ERA09TA440Accident · Minor injuriesFinal reportEurocopter AS 350B3 · Jacksonville, FLThe flight instructor's improper decision to attempt hover flight without hydraulic power and his subsequent loss of control.NTSB WPR09LA386Accident · Serious injuriesLimited investigationFinal reportAirborne Windsports PTY XT-912-L · Lihue, HIThe flight instructor's failure to maintain control of the airplane following an in-flight encounter with turbulence during descent.NTSB WPR09LA381Accident · Serious injuriesLimited investigationFinal reportSchempp Hirth Discus CS · Williams, CAThe pilot's failure to maintain clearance with terrain after intentionally releasing from the tow plane at a low altitude during the initial climb.NTSB WPR09LA380Accident · Serious injuriesLimited investigationFinal reportDavenport DAVE-EZ · Santa Monica, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB WPR09LA378Accident · 1 fatalLimited investigationFinal reportGray RV-6 · Caldwell, IDThe pilot's failure to maintain adequate airspeed that led to a stall/spin while maneuvering in the traffic pattern.NTSB CEN09CA484Accident · Minor injuriesData collectionFinal reportPiper PA22 · Terrell, TXThe pilot's improper decision to continue the approach and landing during thunderstorm activity, resulting in the loss of aircraft control.NTSB ERA09CA432Accident · Minor injuriesData collectionFinal reportBingham Chuck Rotorway 1 · Atlanta, GAThe pilot's failure to maintain control of the helicopter while hovering in gusting wind conditions.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 ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.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 CEN09LA444Accident · 1 fatalLimited investigationFinal reportBeech TC-45J · Verdel, NEThe pilot's improper decision to fly an airplane that was not airworthy and for which he was not properly rated to operate, and his failure to maintain control of the airplane during a forced landing to a field following an engine failure. Contributing to the…NTSB ERA09CA405Accident · No injuriesData collectionFinal reportPiper PA28 · Blacksburg, VAThe pilot's failure to maintain directional control during the takeoff roll.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 CEN09CA432Accident · No injuriesData collectionFinal reportRemos Remos G-3/ · Erie, COThe student pilot's improper recovery from a bounced landing and the flight instructor's delayed reaction to take control and recover.NTSB WPR09CA338Accident · No injuriesData collectionFinal reportBell 206B · Burlington, WAThe pilot’s failure to maintain control of the helicopter while attempting to lift off from a trailer. The helicopter subsequently impacted the ground and rolled over.NTSB ERA09LA398Accident · 2 fatalLimited investigationFinal reportBarber John A Glasair · Switzerland, FLA loss of control in flight for undetermined reasons. Contributing to the accident was the pilot's performance of aerobatic maneuvers at altitudes lower than those recommended by the kit manufacturer, resulting in insufficient terrain clearance to conduct a…NTSB CEN09LA427Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540 · Tarkio, MOThe pilot's failure to maintain aircraft control during the aerobatic flight.NTSB WPR09LA318Accident · 1 fatalLimited investigationFinal reportAlexander Schleicher ASW 27-18E · Ephrata, WAThe pilot’s failure to maintain control of the glider during flight and his exceedance of the glider’s design limits during an attempted recovery from a spin.NTSB WPR09LA317Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus 2CM · Paragonah, UTThe glider departed controlled flight for undetermined reasons.NTSB ERA09LA400Accident · Serious injuriesLimited investigationFinal reportApollo Monsoon · Kanona, NYThe pilot's loss of control while landing in convective weather conditions. Contributing to the accident was his misjudgment of the approaching weather.NTSB WPR09FA309Accident · 4 fatalField investigationFinal reportBeech B95 · Holbrook, AZThe pilot’s decision to depart when ill and his failure to maintain control of the airplane during a return to the airport, likely because of his physical illness and drug impairment.NTSB ERA09CA367Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Morgantown, WVThe pilot’s failure to maintain control of the helicopter during the practice hovering autorotation. Contributing to the accident was the pilot’s lack of experience in night vision goggle helicopter operations.NTSB CEN09LA384Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Llano, TXThe pilot's inability to maintain aircraft control due to the failure of the left main landing gear wheel, which resulted in the separation of the wheel from the aircraft.NTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.NTSB CEN09CA383Accident · No injuriesData collectionFinal reportPietenpol GN-1 · Waxahachie, TXThe pilot's failure to maintain control of the airplane during a landing.NTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.NTSB CEN09CA376Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Collins, COThe pilot's failure to maintain control of the airplane during a crosswind landing. Contributing to the accident was the instructor's delayed action in regaining control of the airplane.NTSB WPR09LA301Accident · Serious injuriesLimited investigationFinal reportPaul Antares · Petaluma, CAThe pilot's failure to maintain aircraft control while landing in gusting winds.NTSB CEN09FA369Accident · 2 fatalField investigationFinal reportCessna R182 · Dougherty, TXThe pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…NTSB CEN09CA368Accident · No injuriesData collectionFinal reportGrob G103 · Wellington, COThe pilot’s failure to maintain control of the glider during takeoff.NTSB WPR09LA270Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Yerington, NVThe pilot's failure to maintain aircraft control while maneuvering during an aerial application flight.NTSB ERA09LA356Accident · 1 fatalLimited investigationFinal reportChris Mitchell Titan Tornado · Chadbourn, NCThe pilot’s failure to maintain aircraft control during initial climb following a loss of engine power. The reason for the power loss was not determined.NTSB CEN09CA367Accident · No injuriesData collectionFinal reportCessna 152 · Fort Collins, COThe pilot's failure to control the airplane after engine startup, resulting in a ground collision with a nearby airplane.NTSB WPR09LA293Accident · 2 fatalLimited investigationFinal reportChampion 7ECA · Lake Elsinore, CAA loss of airplane control for undetermined reasons.NTSB CEN09FA364Accident · 1 fatalField investigationFinal reportCessna 150L · Rockwall, TXThe pilot’s failure to maintain aircraft control following a loss of engine power due to contamination in the carburetor. Contributing the severity of the accident was the pilot’s failure to utilize his shoulder harness.NTSB CEN09CA366Accident · Serious injuriesData collectionFinal reportSabre 2PL · Harrison, NEA loss of directional control for undetermined reasons.NTSB ERA09LA348Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Fairmont, WVThe pilot’s failure to maintain control of the airplane during takeoff. Contributing to the accident was the pilot's inadequate use of the checklist.NTSB WPR09LA286Accident · Serious injuriesLimited investigationFinal reportWermling KR-2 Rand Robinson · Anaconda, MTThe non-certificated pilot’s failure to maintain airspeed and aircraft control during initial climb resulting in a stall/spin.NTSB ERA09CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · West Chester, PAThe student pilot’s improper recovery from a bounced landing. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB CEN09CA361Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Trumann, ARThe pilot's failure to maintain aircraft control in flight. Contributing to the accident was his decision to fly with known hazardous weather conditions in the vicinity.NTSB CEN09CA352Accident · No injuriesData collectionFinal reportAviat A-1A · Marfa, TXThe pilot's failure to maintain control while landing in gusty winds.NTSB ERA09CA336Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Somerville, NJThe loss of directional control during the landing roll due to the separation of the tailwheel centering spring for an undetermined reason.NTSB ERA09CA328Accident · Serious injuriesData collectionFinal reportTrick Trikes Storm Thunder · Raleigh, NCThe pilot's failure to maintain aircraft control on approach for landing.NTSB CEN09CA337Accident · No injuriesData collectionFinal reportCarillon John C Zodiac CH6 · Clinton, ARThe pilot's failure to maintain control of the aircraft during takeoff. Contributing to the accident was his failure to secure a wing fuel panel prior to departure.NTSB ERA09CA320Accident · Serious injuriesData collectionFinal reportAB Sportine Aviacija LAK-17A · Middletown, NYThe pilot's failure to maintain control of the airplane while landing in gusty winds, which resulted in a loss of adequate airspeed and a subsequent aerodynamic stall.NTSB CEN09LA331Accident · 1 fatalLimited investigationFinal reportGentry John K Chinook PL · Bridgeport, TXThe flight instructor and pilot's decision to take off with known control deficiencies with the aircraft which resulted in a loss of control.NTSB ERA09CA337Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Meredith, NHThe pilot’s failure to maintain control during landing.NTSB CEN09CA321Accident · No injuriesData collectionFinal reportCessna U206C · Brainerd, MNThe pilot's failure to maintain aircraft control while landing in gusty winds.