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.

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.Aug 6, 2009 · N6186T · Substantial damageNTSB 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.Aug 5, 2009 · N8099P · Substantial damageNTSB 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.Aug 4, 2009 · N186AE · Substantial damageNTSB 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.Aug 2, 2009 · N44VZ · Substantial damageNTSB 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.Aug 2, 2009 · N7HV · Substantial damageNTSB 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.Aug 2, 2009 · N7CE · Substantial damageNTSB 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.Aug 1, 2009 · N69KG · DestroyedNTSB 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.Aug 1, 2009 · N8602C · Substantial damageNTSB 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.Jul 31, 2009 · N267BC · Substantial damageNTSB 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.Jul 27, 2009 · N2980X · Substantial damageNTSB ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.Jul 23, 2009 · N595Z · Substantial damageNTSB 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.Jul 19, 2009 · N25VH · Substantial damageNTSB 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…Jul 19, 2009 · N6688 · DestroyedNTSB ERA09CA405Accident · No injuriesData collectionFinal reportPiper PA28 · Blacksburg, VAThe pilot's failure to maintain directional control during the takeoff roll.Jul 14, 2009 · N7418W · Substantial damageNTSB ERA09CA403Accident · Minor injuriesData collectionFinal reportSmith PA18 replica · Chesterville, METhe pilot's failure to maintain aircraft control while turning from base leg to final approach.Jul 14, 2009 · N846PT · Substantial damageNTSB 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.Jul 12, 2009 · N408RA · Substantial damageNTSB 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.Jul 11, 2009 · N302PD · Substantial damageNTSB 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…Jul 11, 2009 · N132JB · DestroyedNTSB CEN09LA427Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540 · Tarkio, MOThe pilot's failure to maintain aircraft control during the aerobatic flight.Jul 10, 2009 · N26HB · Substantial damageNTSB 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.Jun 29, 2009 · N129TD · Substantial damageNTSB WPR09LA317Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus 2CM · Paragonah, UTThe glider departed controlled flight for undetermined reasons.Jun 29, 2009 · N68MP · Substantial damageNTSB 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.Jun 26, 2009 · N308AA · Substantial damageNTSB 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.Jun 25, 2009 · N912T · Substantial damageNTSB 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.Jun 24, 2009 · N106HN · Substantial damageNTSB 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.Jun 24, 2009 · N6939M · Substantial damageNTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.Jun 24, 2009 · N67797 · Substantial damageNTSB CEN09CA383Accident · No injuriesData collectionFinal reportPietenpol GN-1 · Waxahachie, TXThe pilot's failure to maintain control of the airplane during a landing.Jun 24, 2009 · N1736 · DestroyedNTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.Jun 22, 2009 · N2320P · Substantial damageNTSB 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.Jun 22, 2009 · N5824D · Substantial damageNTSB WPR09LA301Accident · Serious injuriesLimited investigationFinal reportPaul Antares · Petaluma, CAThe pilot's failure to maintain aircraft control while landing in gusting winds.Jun 20, 2009 · N729YF · Substantial damageNTSB 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…Jun 19, 2009 · N182GT · DestroyedNTSB CEN09CA368Accident · No injuriesData collectionFinal reportGrob G103 · Wellington, COThe pilot’s failure to maintain control of the glider during takeoff.Jun 19, 2009 · N5462N · Substantial damageNTSB WPR09LA270Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Yerington, NVThe pilot's failure to maintain aircraft control while maneuvering during an aerial application flight.Jun 18, 2009 · N9723 · Substantial damageNTSB 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.Jun 18, 2009 · N259CM · Substantial damageNTSB 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.Jun 18, 2009 · N95144 · Substantial damageNTSB WPR09LA293Accident · 2 fatalLimited investigationFinal reportChampion 7ECA · Lake Elsinore, CAA loss of airplane control for undetermined reasons.Jun 17, 2009 · N8339V · Substantial damageNTSB 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.Jun 17, 2009 · N66016 · Substantial damageNTSB CEN09CA366Accident · Serious injuriesData collectionFinal reportSabre 2PL · Harrison, NEA loss of directional control for undetermined reasons.Jun 16, 2009 · N2811P · Substantial damageNTSB 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.Jun 14, 2009 · N7544E · Substantial damageNTSB 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.Jun 13, 2009 · N40908 · Substantial damageNTSB 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.Jun 13, 2009 · N659PS · Substantial damageNTSB 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.Jun 12, 2009 · N50956 · Substantial damageNTSB CEN09CA352Accident · No injuriesData collectionFinal reportAviat A-1A · Marfa, TXThe pilot's failure to maintain control while landing in gusty winds.Jun 12, 2009 · N391C · Substantial damageNTSB 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.Jun 8, 2009 · N43766 · Substantial damageNTSB ERA09CA328Accident · Serious injuriesData collectionFinal reportTrick Trikes Storm Thunder · Raleigh, NCThe pilot's failure to maintain aircraft control on approach for landing.Jun 8, 2009 · N2598E · Substantial damageNTSB 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.Jun 4, 2009 · N9093Y · Substantial damageNTSB 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.May 31, 2009 · N391BA · Substantial damageNTSB 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.May 29, 2009 · N31773 · Substantial damageNTSB ERA09CA337Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Meredith, NHThe pilot’s failure to maintain control during landing.May 25, 2009 · N47GT · Substantial damageNTSB CEN09CA321Accident · No injuriesData collectionFinal reportCessna U206C · Brainerd, MNThe pilot's failure to maintain aircraft control while landing in gusty winds.May 25, 2009 · N3970G · Substantial damage