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 WPR09LA264Accident · 1 fatalLimited investigationFinal reportPolit Kitfox Ser 5 Outback · Apple Valley, CAThe pilot's loss of aircraft control for undetermined reasons while maneuvering at low altitude.May 23, 2009 · N781VP · Substantial damageNTSB WPR09FA258Accident · 4 fatalField investigationFinal reportCessna 320D · Fallon, NVThe pilot’s inadequate airspeed, which resulted in an aerodynamic stall.May 23, 2009 · N320KP · Substantial damageNTSB CEN09LA311Accident · 2 fatalLimited investigationFinal reportThornton RV-6A · Plainwell, MIThe pilot's failure to maintain aircraft control for undetermined reasons.May 21, 2009 · N39JT · DestroyedNTSB CEN09CA303Accident · No injuriesData collectionFinal reportAirborne XT912 · Newark, ILThe pilot's inadequate preflight preparation, which led to the inability to accelerate to takeoff speed after encountering wet and soft runway conditions.May 17, 2009 · N912LM · Substantial damageNTSB ANC09LA047Accident · No injuriesLimited investigationFinal reportHelio H-295 · Kaktovic, AKThe pilot’s failure to maintain control of the airplane after an in-flight encounter with a downdraft while landing in mountainous terrain, and her decision to fly at an altitude where such an encounter made a successful recovery unlikely.May 16, 2009 · N295SC · Substantial damageNTSB CEN09CA316Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Charleston, MOThe pilot's failure to abort the takeoff resulting in a runway overrun and impact with terrain.May 15, 2009 · N85115 · Substantial damageNTSB WPR09CA243Accident · No injuriesData collectionFinal reportART Lee Delano CH701 · Oakdale, CAThe pilot's inadequate compensation for the gusty crosswind conditions while landing.May 13, 2009 · N701LD · Substantial damageNTSB CEN09IA294Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Houston, TXThe pilot's inadvertent application of excessive braking after touchdown, which caused the right wheels to lock and several tires to blow and resulted in a subsequent brake fire.May 13, 2009 · N371SW · Minor damageNTSB CEN09CA290Accident · No injuriesData collectionFinal reportBolton Ricky D Rotorway E · Brookeland, TXThe pilot failed to maintain control while hovering in gusty conditions.May 10, 2009 · N602DB · Substantial damageNTSB ERA09CA285Accident · No injuriesData collectionFinal reportRichard Rank KitFox 4 · Madison, MSThe pilot’s failure to maintain aircraft control during an aborted formation takeoff.May 9, 2009 · N248DR · Substantial damageNTSB CEN09LA288Accident · 1 fatalLimited investigationFinal reportSmysor Kevin Velocity · Katy, TXThe pilot's loss of control following an in-flight failure of the propeller.May 9, 2009 · N45YV · Substantial damageNTSB CEN09LA276Accident · Serious injuriesLimited investigationFinal reportHawkins August E Aventura II · Griffith, INThe pilot's failure to maintain control of the airplane due to an inadvertent stall. Contributing to the accident was the failure of the airspeed indicator due to separation of the pitot-static line at the left wing root.May 2, 2009 · N20GH · Substantial damageNTSB CEN09CA271Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Harlingen, TXThe pilot's decision to leave the helicopter unattended with the engine running in gusty wind conditions.Apr 29, 2009 · N2560Q · Substantial damageNTSB ERA09CA274Accident · No injuriesData collectionFinal reportCessna 150K · Waycross, GAThe student pilot's failure to maintain aircraft control during approach in gusty conditions. Contributing to the accident was the student pilot's misunderstanding of the airspeed indicator.Apr 27, 2009 · N6213G · Substantial damageNTSB ANC09LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe non-certificated pilot’s decision to attempt to "ski" atop a water-covered tidal area in an airplane equipped with over-sized main landing gear tires, resulting in a loss of control and a nose over.Apr 26, 2009 · N3256B · Substantial damageNTSB CEN09CA270Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Kent, TXThe pilot's failure to maintain control of the helicopter.Apr 23, 2009 · N518SJ · Substantial damageNTSB CEN09CA258Accident · No injuriesData collectionFinal reportMarlin Varieze · Santa Teresa, NMThe pilot's failure to maintain control of the airplane, his failure to latch the canopy prior to takeoff, and his failure to complete the pretakeoff checklist due to his diverted attention.Apr 20, 2009 · N77JM · Substantial damageNTSB ERA09CA251Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Southbridge, MAThe pilot's inadequate compensation for the gusting wind conditions.Apr 18, 2009 · N96552 · Substantial damageNTSB WPR09LA201Accident · No injuriesLimited investigationFinal reportBrinker / Garner BI-PLANE · Caldwell, IDLoss of control during the landing roll for undetermined reasons.Apr 17, 2009 · N375CB · Substantial damageNTSB ERA09FA248Accident · 1 fatalField investigationFinal reportCessna 421B · Oakland Park, FLThe pilot's failure to maintain aircraft control and secure the right engine during an emergency return to the airport after takeoff. Contributing to the accident was an in-flight fire of the right engine for undetermined reasons.Apr 17, 2009 · N1935G · Substantial damageNTSB ERA09CA249Accident · No injuriesData collectionFinal reportBell 206 · West Palm Beach, FLThe pilot’s failure to maintain aircraft control during taxi, which resulted in a dynamic rollover.Apr 17, 2009 · N25PM · Substantial damageNTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.Apr 16, 2009 · N7802F · Substantial damageNTSB CEN09CA251Accident · Minor injuriesData collectionFinal reportAviat A-1B · Great Bend, KSThe pilot's failure to maintain control of the airplane during takeoff in gusting wind conditions.Apr 15, 2009 · N84DT · Substantial damageNTSB ANC09LA032Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's inability to maintain directional control due to the pilot's seat sliding back during takeoff as a result of maintenance personnel's incorrect installation of the seat's forward track stop.Apr 15, 2009 · N4246H · Substantial damageNTSB WPR09LA195Accident · Serious injuriesLimited investigationFinal reportSungkwon Kim LONG-EZE · Dunsmuir, 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.Apr 14, 2009 · N342MS · Substantial damageNTSB ERA09CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Bessemer, ALThe pilot's failure to maintain aircraft control while landing with a crosswind.Apr 14, 2009 · N269WB · Substantial damageNTSB WPR09FA192Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Diego, CAThe pilot's failure to maintain control during an en route cruise descent through multiple cloud layers, resulting in an in-flight breakup.Apr 11, 2009 · N7690P · DestroyedNTSB ERA09CA246Accident · No injuriesData collectionFinal reportPiper PA20 · Scranton, PAThe pilot’s inadequate compensation for wind conditions during landing. Contributing to the accident was the distraction of smoke in the cockpit.Apr 9, 2009 · N7653K · Substantial damageNTSB CEN09LA247Accident · Serious injuriesLimited investigationFinal reportCessna 182T · Stigler, OKThe loss of directional control during takeoff. Contributing to the accident was the pilot's decision to take off with 40-degrees of flaps and with a tailwind.Apr 9, 2009 · N1491D · Substantial damageNTSB CEN09LA252Accident · No injuriesLimited investigationFinal reportBell 222B · Gulf of Mexico, TXThe pilot's failure to maintain clearance from obstructions while landing on a shipboard helipad.Apr 8, 2009 · N309CH · Substantial damageNTSB WPR09CA178Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Monterey, CAThe pilot's inadequate compensation for the wind conditions and failure to attain/maintain an adequate airspeed, which resulted in an aerodynamic stall.Apr 4, 2009 · N224RA · Substantial damageNTSB ERA09LA230Accident · 1 fatalLimited investigationFinal reportChampion 7HC · Centre, ALThe pilot's inability to maintain aircraft control during climb due to an improperly installed rudder pedal control tube.Apr 4, 2009 · N8560E · Substantial damageNTSB WPR09FA176Accident · 1 fatalField investigationFinal reportMaule M-4-220C · Hungry Horse, MTThe pilot's improper decision to continue flight into an area of reduced visibility and snow showers during cruise flight, which resulted in the pilot's spatial disorientation and subsequent loss of aircraft control.Apr 1, 2009 · N2007U · DestroyedNTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.Mar 30, 2009 · N74815 · Substantial damageNTSB ERA09CA219Accident · Minor injuriesData collectionFinal reportParks Jerry R Lancair · Milton, FLThe pilot's failure to maintain aircraft control during landing.Mar 28, 2009 · N320J · Substantial damageNTSB ERA09FA215Accident · 1 fatalField investigationFinal reportCessna 182Q · Lexington, KYThe pilot's failure to maintain control of the airplane for undetermined reasons.Mar 26, 2009 · N4871N · Substantial damageNTSB WPR09MA159Accident · 14 fatalClass 1 · MajorFinal reportPilatus PC-12/45 · Butte, MT(1) the pilot's failure to ensure that a fuel system icing inhibitor was added to the fuel before the flights on the day of the accident; (2) his failure to take appropriate remedial actions after a low fuel pressure state (resulting from icing within the…Mar 22, 2009 · N128CM · Substantial damageNTSB WPR09FA158Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Corona, CAThe pilot did not maintain airplane control during climb due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument flying experience.Mar 20, 2009 · N55962 · Substantial damageNTSB WPR09FA150Accident · 2 fatalField investigationFinal reportPiper PA28-236 · Pomona, CAThe pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.Mar 14, 2009 · N129AB · DestroyedNTSB CEN09LA202Accident · Serious injuriesLimited investigationFinal reportHughes 269C · El Indio, TXThe pilot's failure to maintain control of the helicopter while attempting to land on a transport trailer in heavy rain and gusting winds.Mar 11, 2009 · N64731 · Substantial damageNTSB ERA09LA193Accident · 2 fatalLimited investigationFinal reportBurkholder Jimmy C Zodiac 601HD · Live Oak, FLThe pilot's loss of control of the airplane for undetermined reasons.Mar 10, 2009 · N601DE · DestroyedNTSB ERA09LA188Accident · 2 fatalLimited investigationFinal reportMXR Technologies MX2 · Dade City, FLAn in-flight loss of aircraft control for an undetermined reason.Mar 9, 2009 · N262MX · Substantial damageNTSB ERA09FA185Accident · 3 fatalField investigationFinal reportCessna 182P · Carrollton, GAThe pilot's decision to continue visual flight rules flight into an area of reduced visibility weather conditions, which resulted in disorientation and subsequent loss of aircraft control.Mar 8, 2009 · N1913M · DestroyedNTSB CEN09LA196Accident · 1 fatalLimited investigationFinal reportFritz RV3-A · Greencastle, INA partial loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control during the emergency descent.Mar 7, 2009 · N933WF · Substantial damageNTSB CEN09CA186Accident · Minor injuriesData collectionFinal reportBeech A36 · Athens, TXThe non-certificated pilot's failure to maintain control during his unauthorized use of the airplane.Mar 4, 2009 · N5470V · Substantial damageNTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.Mar 2, 2009 · N2262D · Substantial damageNTSB WPR09CA132Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Fallbrook, CAThe pilot's improper use of the brakes and his failure to maintain control of the airplane during landing rollout.Feb 28, 2009 · N4290T · Substantial damageNTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…Feb 28, 2009 · N91593 · Substantial damageNTSB WPR09LA130Accident · 1 fatalLimited investigationFinal reportToland S/Thornburgh J Twin 503SL · Torrance, CAThe passenger’s inadvertent activation of the engine throttle.Feb 27, 2009 · N426MT · Substantial damageNTSB CEN09CA180Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · O'Donnell, TXThe pilot's failure to maintain control while performing a quick stop maneuver to an out of ground effect (OGE) hover. Contributing to the accident was the high density altitude and near calm wind condition.Feb 25, 2009 · N387AC · Substantial damage