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 ERA12FA303Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Anderson, SCThe pilot's failure to maintain control of the airplane during the aborted landing, which resulted in an aerodynamic stall and impact with terrain.Apr 27, 2012 · N154CK · Substantial damageNTSB CEN12LA260Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Bryan, TXThe pilot's diverted attention, which resulted in a loss of control while maneuvering the airplane at a low altitude.Apr 25, 2012 · N510KW · Substantial damageNTSB WPR12FA180Accident · 2 fatalField investigationFinal reportLeague Lancair IV-TP · Sisters, ORThe pilots’ inability to maintain control of the airplane and arrest a steep spiral dive while maneuvering for reasons that could not be determined because postaccident examination could not identify any anomalies that would have precluded normal operation…Apr 23, 2012 · N66HL · Substantial damageNTSB CEN12FA251Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Newcomerstown, OHThe pilot’s loss of airplane control in instrument meteorological conditions due to his distraction by electrical system anomalies, which resulted in an uncontrolled descent. The reason for the electrical system anomalies could not be determined.Apr 21, 2012 · N110EB · Substantial damageNTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.Apr 10, 2012 · N9518J · Substantial damageNTSB WPR12CA162Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Henderson, NVThe pilot did not maintain directional and yaw control of the helicopter during approach and landing, which resulted in a dynamic rollover.Apr 9, 2012 · N55NZ · Substantial damageNTSB CEN12LA227Accident · 1 fatalLimited investigationFinal reportGrumman F8F-1 · Breckenridge, TXThe pilot's loss of airplane control during a low-altitude aerobatic maneuver.Apr 4, 2012 · N14HP · Substantial damageNTSB WPR12LA152Accident · 2 fatalLimited investigationFinal reportNelson Rans S-12 · Mesa, AZThe pilot’s failure to maintain airplane control while maneuvering at low altitude shortly after takeoff.Apr 3, 2012 · N586BN · Substantial damageNTSB ANC12FA028Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKOperation of the airplane by a non-certificated pilot and his failure to maintain adequate airspeed and airplane control, which resulted in an aerodynamic stall.Mar 31, 2012 · N7276D · Substantial damageNTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.Mar 24, 2012 · N605RV · Substantial damageNTSB CEN12CA202Accident · No injuriesData collectionFinal reportSmith Aerostar 601P · Casterville, TXThe pilot did not maintain control of the airplane while circling to land.Mar 24, 2012 · N602BV · Substantial damageNTSB CEN12FA188Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Mexico, MOThe pilot’s failure to maintain airplane control during takeoff, which resulted in an aerodynamic stall and subsequent collision with trees. Contributing to the accident was the pilot’s inadequate preflight performance planning before departing on the soft,…Mar 18, 2012 · N158EA · Substantial damageNTSB ANC12IA024Incident · No injuriesIncident investigationFinal reportBombardier Learjet 35A · Anchorage, AKThe flightcrew's loss of visual reference to the runway after encountering severe in-flight icing conditions, which resulted in a loss of control while landing and exceedence of the capabilities of the airplane's windscreen anti-ice systems. Contributing to…Mar 6, 2012 · N544LM · Minor damageNTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.Feb 24, 2012 · N53589 · Substantial damageNTSB CEN12FA164Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Albany, TXThe loss of flight instrumentation due to a failed vacuum pump while flying a night without a discernable horizon, which resulted in the pilot's spatial disorientation and an in-flight loss of control and impact with terrain. Contributing was the continued…Feb 21, 2012 · N7147P · Substantial damageNTSB ERA12FA149Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Rainbow City, ALAn in-flight loss of control in instrument meteorological conditions.Jan 21, 2012 · N16RZ · Substantial damageNTSB ERA12LA145Accident · 2 fatalLimited investigationFinal reportPiper PA-24-180 · Brewster, MAThe flight crew’s loss of airplane control.Jan 15, 2012 · N7648P · Substantial damageNTSB CEN12CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Angle Fire, NMThe pilot did not maintain control of the airplane during the takeoff in gusting crosswind conditions.Jan 15, 2012 · N513CW · Substantial damageNTSB CEN12LA129Accident · Minor injuriesLimited investigationFinal reportAviat A-1C-180 · Chetek, WIThe passenger’s interference with the flight controls, which resulted in the airplane’s failure to climb after an aborted landing. Contributing was the pilot's failure to maintain directional control during landing roll, which resulted in the need to abort…Jan 6, 2012 · N11HY · Substantial damageNTSB ERA12FA130Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Jacksonville, FLThe pilot's in-flight loss of control during climb after a banner pickup. Contributing to the accident was the pilot's impairment due to marijuana.Dec 31, 2011 · N7408Z · Substantial damageNTSB CEN12FA115Accident · 3 fatalField investigationFinal reportBeech 19A · McArthur, OHThe pilot’s failure to maintain airplane control during an attempted go-around.Dec 24, 2011 · N33SR · Substantial damageNTSB ERA12FA115Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Morristown, NJThe airplane’s encounter with unforecasted severe icing conditions that were characterized by high ice accretion rates and the pilot's failure to use his command authority to depart the icing conditions in an expeditious manner, which resulted in a loss of…Dec 20, 2011 · N731CA · DestroyedNTSB WPR12LA065Accident · Minor injuriesLimited investigationFinal reportBell 407 · Rock Springs, WYThe unauthorized operation of the helicopter by a non-certificated and unqualified individual who failed to maintain helicopter control.Dec 13, 2011 · N8067Z · Substantial damageNTSB ERA12FA107Accident · 1 fatalField investigationFinal reportShaw Douglas Wayne Rans S 7 · Somerville, TNThe pilot's incapacitation due to a ruptured berry aneurysm during takeoff.Dec 11, 2011 · N347DS · Substantial damageNTSB DCA12MA020Accident · 5 fatalClass 1 · MajorFinal reportEurocopter France AS350B2 · Las Vegas, NVSundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…Dec 8, 2011 · N37SH · DestroyedNTSB CEN12LA095Accident · Serious injuriesLimited investigationFinal reportBeech F90 · Midland, TXThe pilot's failure to maintain the recommended airspeed for icing conditions and his subsequent loss of airplane control while flying the airplane under autopilot control in severe icing conditions, contrary to the airplane's handbook. Contributing to the…Dec 2, 2011 · N90QL · DestroyedNTSB WPR12LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Seattle, WAThe flight instructor’s failure to maintain airplane control during a go-around.Dec 1, 2011 · N2163N · Substantial damageNTSB CEN12FA091Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Hackensack, MNThe helicopter's sudden yaw and subsequent impact with the water for reasons that could not be determined during postaccident examination of the helicopter and its systems.Nov 25, 2011 · N821JV · Substantial damageNTSB CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.Nov 17, 2011 · N7746W · Substantial damageNTSB CEN12LA053Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Noblesville, INThe hard landing the pilot performed with a quartering tailwind, leading to the helicopter's rollover. Contributing to the accident was the pilot’s reliance on a weather service that did not provide a primary weather product.Nov 3, 2011 · N130AL · Substantial damageNTSB ERA12FA052Accident · 2 fatalField investigationFinal reportInterplane S R O Skyboy · Miami, FLThe pilot’s failure to maintain control of the airplane while flying at low speed, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the outcome of the accident was the pilot’s decision to operate the airplane…Oct 29, 2011 · N58784 · Substantial damageNTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.Oct 13, 2011 · N3086X · Substantial damageNTSB WPR12CA003Accident · No injuriesData collectionFinal reportCessna 172P · AganaThe pilot's failure to avoid the jet blast while taxiing and the ground air traffic controller's failure to advise the pilot of the hazard.Oct 6, 2011 · N9853L · Substantial damageNTSB ERA12CA025Accident · No injuriesData collectionFinal reportCessna 177RG · Westerly, RIThe pilot's failure to maintain airplane control while starting the engine.Oct 6, 2011 · N177MW · Substantial damageNTSB CEN11CA679Accident · No injuriesData collectionFinal reportWaltman Theodore J Moose · Hays, KSRudder flutter due to the design changes to the airplane's horizontal stabilizer.Sep 30, 2011 · N384JP · Substantial damageNTSB ANC11CA111Accident · No injuriesData collectionFinal reportCessna 180H · Chenga Bay, AKThe pilot's failure to maintain clearance from an obstruction while landing at an off-airport site, resulting in a loss of control.Sep 27, 2011 · N9083M · Substantial damageNTSB ANC11LA108Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 BA · Juneau, AKUpslope wind conditions while the helicopter was operating at ground idle, which resulted in the helicopter rollover. Contributing to the accident was the lack of manufacturer data regarding the effect of upslope wind conditions on helicopter ground idle…Sep 26, 2011 · N230CH · Substantial damageNTSB CEN11LA415Accident · Serious injuriesLimited investigationFinal reportBins Tom Kitfox IV · Lafayette, LAThe pilot’s loss of control during a forced landing after a loss of engine power for undetermined reasons during takeoff.Sep 24, 2011 · N211KF · Substantial damageNTSB ERA11LA496Accident · 1 fatalLimited investigationFinal reportAero Adventure Zephyr II · Sylacauga, ALThe pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.Sep 18, 2011 · N3577F · Substantial damageNTSB WPR11MA454Accident · 11 fatalClass 1 · MajorFinal reportNorth American/Aero Classics P-51D · Reno, NVThe reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…Sep 16, 2011 · N79111 · Substantial damageNTSB WPR11FA450Accident · 1 fatalField investigationFinal reportCone James A RV-6A · West Jordan, UTThe pilot’s execution of an abrupt maneuver, likely to avoid birds, which resulted in a stall and spin.Sep 15, 2011 · N641JC · Substantial damageNTSB WPR11FA448Accident · 2 fatalField investigationFinal reportCessna 182H · Stanley, IDThe pilot's failure to maintain airplane control due to spatial disorientation while executing a turn to reverse his course in dark night and low-visibility conditions. Contributing to the accident was the pilot's decision to initiate the flight into an area…Sep 13, 2011 · N2404X · Substantial damageNTSB CEN11FA634Accident · 1 fatalField investigationFinal reportRiffel Jerris L RV-7A · Winfield, KSThe pilot’s in-flight loss of control. Contributing to the pilot’s fatal injury was his failure to use the available restraint systems, which resulted in him falling through the open canopy when the airplane inverted.Sep 7, 2011 · N554JR · Substantial damageNTSB WPR11LA443Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAThe flight instructor’s delayed remedial action and failure to maintain airplane control while performing a simulated aborted landing.Sep 6, 2011 · N4649L · Substantial damageNTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.Aug 29, 2011 · N73712 · Substantial damageNTSB CEN11CA638Accident · No injuriesData collectionFinal reportEnstrom F-28F · Menominee, MIThe pilot's failure to maintain control of the helicopter during a hover.Aug 29, 2011 · N228F · Substantial damageNTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.Aug 26, 2011 · N761NX · Substantial damageNTSB CEN11LA595Accident · No injuriesLimited investigationFinal reportCessna 140 · Monmouth, ILThe pilot's loss of airplane control during the landing roll.Aug 25, 2011 · N72688 · Substantial damageNTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.Aug 25, 2011 · N777BN · DestroyedNTSB CEN11CA590Accident · No injuriesData collectionFinal reportRans Designs S-7LS · Joplin, MOThe pilot's failure to maintain aircraft control during the landing.Aug 21, 2011 · N544RS · Substantial damage