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 NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.Sep 27, 2008 · N770CA · DestroyedNTSB MIA08LA199Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Linden, NJThe flight instructor’s delayed remedial action (flight control inputs) during a practice autorotation/run-on landing resulting in fracture damage to the main rotor system Starflex.Sep 19, 2008 · N906BA · Substantial damageNTSB DFW08FA233Accident · 2 fatalField investigationFinal reportPiper Aerostar PA-60-602P · Kremmling, COThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall and spin.Sep 19, 2008 · N97TS · DestroyedNTSB DEN08FA155Accident · 2 fatalField investigationFinal reportCessna 172L · York, NEThe student pilot's failure to maintain aircraft control, and the flight instructor's failure to take remedial action, for undetermined reasons.Sep 19, 2008 · N4380Q · Substantial damageNTSB DFW08FA234Accident · No injuriesField investigationFinal reportCessna E162 · Douglas, KSThe airplane's inability to recover from an intentional spin, despite proper control inputs by the flight test pilot. Contributing to the accident was the failure of the airplane's ballistic parachute system to properly deploy.Sep 18, 2008 · N162XP · Substantial damageNTSB DFW08TA225Accident · Serious injuriesFinal reportDiamond Aircraft Industries DA-20-C-1 · Pueblo, COThe student pilot's inability to maintain aircraft control due to an encounter with wake turbulence from a preceding larger aircraft. Contributing to the accident was the instructor pilot's failure to intervene.Sep 8, 2008 · N939DA · Substantial damageNTSB NYC08CA305Accident · No injuriesData collectionFinal reportRobinson R44 II · Marathon, FLThe pilot's failure to control the helicopter while maneuvering, resulting in loss of tail rotor effectiveness.Sep 6, 2008 · N144SA · Substantial damageNTSB CHI08LA272Accident · 1 fatalLimited investigationFinal reportSocata TB-20 Trinidad · Cassville, WIThe left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.Sep 3, 2008 · N597TB · Substantial damageNTSB DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.Aug 31, 2008 · N30WK · Substantial damageNTSB DFW08FA218Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ridgedale, MOAn in-flight loss of control for undetermined reasons.Aug 29, 2008 · N41411 · DestroyedNTSB DFW08TA224Accident · Minor injuriesFinal reportAir Tractor AT-802A · Meeker, COThe pilot's improper decision to continue an aerial application following an uncommanded opening of the cabin door in flight, and his subsequent failure to maintain control of the airplane.Aug 27, 2008 · N189LA · Substantial damageNTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.Aug 24, 2008 · N5476P · Substantial damageNTSB NYC08LA287Accident · Serious injuriesLimited investigationFinal reportBell 206A · Barnesville, PAThe pilot's failure to maintain control of the helicopter during the low-speed, low-altitude maneuver which resulted in a loss of tail rotor effectiveness.Aug 22, 2008 · N67AR · Substantial damageNTSB LAX08LA272Accident · 1 fatalLimited investigationFinal reportSocata Rallye 235E · San Martin, CAThe pilot's incapacitation due to severe unrecognized coronary artery disease that resulted in a loss of aircraft control.Aug 21, 2008 · N711BZ · DestroyedNTSB SEA08TA188Accident · No injuriesFinal reportHughes 369D · Bonners Ferry, IDThe pilot's inadequate preflight planning for the takeoff and the helicopter loading that exceeded the lift performance capability of the helicopter.Aug 18, 2008 · N622PB · Substantial damageNTSB DEN08FA141Accident · 4 fatalField investigationFinal reportCessna 182T · Georgia Pass, COThe pilot's failure to maintain aircraft control after inadvertantly encountering instrument meteorological conditions. Contributing to the accident were the pilot's failure to obtain a weather brief and the severe weather conditions.Aug 15, 2008 · N487TC · DestroyedNTSB ANC08CA105Accident · Minor injuriesData collectionFinal reportWalker AK Bush Flyer · Deadhorse, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor contributing to the accident was a tailwind.Aug 14, 2008 · N799CC · Substantial damageNTSB MIA08FA163Accident · 3 fatalField investigationFinal reportBeech G35 · South Easton, MAThe pilot's failure to maintain control of the airplane while attempting to execute an instrument approach in instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument currency.Aug 12, 2008 · N4615D · DestroyedNTSB DEN08LA139Accident · 1 fatalLimited investigationFinal reportDickey RV-6A · Muskogee, OKThe pilot's improper decision to continue flight under visual flight rules into an area of reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and subsequent loss of aircraft control. Contributing to the accident was…Aug 11, 2008 · N22163 · DestroyedNTSB MIA08LA162Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache CLA · Boynton Beach, FLThe failure of the pilot to maintain control of the aircraft.Aug 9, 2008 · N3880A · Substantial damageNTSB MIA08CA165Accident · No injuriesData collectionFinal reportCessna 172S · Monroeville, ALThe pilot's inadequate compensation for winds during landing. Contributing to the accident was a wind gust.Aug 9, 2008 · N1600U · Substantial damageNTSB NYC08CA272Accident · No injuriesData collectionFinal reportPiper PA32 · Charleston, SCThe pilot's failure to maintain aircraft control while landing. Contributing to the accident was the crosswind condition and a wind gust, as reported by the pilot.Aug 3, 2008 · N4376X · Substantial damageNTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.Aug 2, 2008 · N6026A · Substantial damageNTSB LAX08LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Honolulu, HIThe flight's encounter with the jet wash from a parked commercial airplane while taxiing for takeoff.Jul 30, 2008 · N5329L · Substantial damageNTSB DEN08LA127Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus A · Midlothian, TXThe pilot's inability to maintain aircraft control due to an incapacitating cardiac event. Contributing to the accident was the pilot's poor decision to fly with known serious medical issues.Jul 23, 2008 · N47JD · DestroyedNTSB LAX08FA233Accident · 3 fatalField investigationFinal reportHughes 369D · Price, UTThe pilot's inadequate preflight performance planning for the takeoff and the loading that exceeded the lift performance capability of the helicopter.Jul 19, 2008 · N400BE · DestroyedNTSB DEN08LA124Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · Cleveland, TXthe pilot's failure to maintain aircraft control during his attempted performance of aerobatic maneuvers shortly after takeoff.Jul 19, 2008 · N80053 · DestroyedNTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.Jul 7, 2008 · N488SD · Substantial damageNTSB DFW08CA177Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Canyon Lake, TXA total loss of tail rotor effectiveness. Contributing to the accident was the pilot's improper decision to operate inside the height velocity curve.Jul 5, 2008 · N804DF · Substantial damageNTSB NYC08LA235Accident · 1 fatalLimited investigationFinal reportLanier James A Talon XP · Cleveland, GAAn inadvertent stall during the initial climb.Jul 2, 2008 · N1974L · DestroyedNTSB NYC08CA233Accident · No injuriesData collectionFinal reportCessna T182T · Lincoln Park, NJThe pilot's failure to maintain aircraft control while landing. Contributing to the accident was the wet runway and hydroplaning conditions.Jun 29, 2008 · N357TG · Substantial damageNTSB LAX08LA191Accident · 2 fatalLimited investigationFinal reportCessna 172S · Oceanside, CAFailure of the pilot to regain airplane control during an intentional stall/spin maneuver.Jun 23, 2008 · N2436F · DestroyedNTSB NYC08LA221Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Lake Placid, FLThe pilot’s performance of a nonstandard abrupt maneuver at low altitude, which resulted in a loss of aircraft control.Jun 20, 2008 · N988PC · Substantial damageNTSB DEN08LA113Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachutes Condor · Brookfield, MOthe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of familiarity and experience in the accident aircraft.Jun 20, 2008 · N3150U · Substantial damageNTSB MIA08LA121Accident · 1 fatalLimited investigationFinal reportMckeehan James F Acroduster II SA750 · Panama City, FLThe pilot's inability to recover from an intentional aerobatic maneuver due to loss of aileron control. Contributing to the accident was the installation of an inadequate aileron secondary stop block against the main spar of both lower wings.Jun 16, 2008 · N363J · Substantial damageNTSB LAX08LA181Accident · 1 fatalLimited investigationFinal reportAirborne Edge · Dunn, NCThe student pilot's failure to maintain control of the airplane during a go-around.Jun 14, 2008 · N9393S · Substantial damageNTSB NYC08FA211Accident · Serious injuriesField investigationFinal reportAvid Mark IV Aerobat · Niceville, FLThe pilot's loss of control during landing for undetermined reasons.Jun 9, 2008 · N652DM · Substantial damageNTSB CHI08FA156Accident · 6 fatalField investigationFinal reportCessna U206C · Fremont, OHThe pilot’s failure to maintain airplane control for an undetermined reason, which resulted in an inadvertent stall. Contributing to the accident was the pilot's poor judgment in continuing to fly with his severe visual deficiency. Also contributing to the…Jun 8, 2008 · N29122 · Substantial damageNTSB DEN08FA100Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Gothenburg, NEThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…Jun 5, 2008 · N12XT · DestroyedNTSB CHI08CA147Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dixon, ILThe student pilot improperly raised the flaps during the go-around, did not maintain airspeed, and stalled the airplane. The trees were a factor.Jun 2, 2008 · N2108N · Substantial damageNTSB SEA08LA149Accident · 1 fatalLimited investigationFinal reportVan Heeswyk Lightning · Marana, AZThe insufficient clamping force resulting in a fatigue fracture of the propeller extension attachment bolts and subsequent separation of the propeller assembly in flight. Contributing to the accident was the pilot's failure to maintain sufficient airspeed to…Jun 1, 2008 · N62JV · Substantial damageNTSB DFW08LA157Accident · 1 fatalLimited investigationFinal reportLucas D E/ Lucas K A AcroSport II · St Charles, MOThe pilot's failure to maintain control during an attempted low pass maneuver.Jun 1, 2008 · N114KT · Substantial damageNTSB LAX08LA160Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger LSS · Moses Lake, WAThe pilot's inability to maintain control due to an in-flight separation of the vertical fin as a result of the failure of the airplane's builder to properly secure the vertical fin to the fuselage.May 31, 2008 · N95478 · Substantial damageNTSB SEA08CA144Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Reno, NVThe student pilot's failure to maintain translational lift airspeed while approaching the pinnacle and the certificated flight instructor's delayed remedial action and inadequate supervision of the flight.May 29, 2008 · N2024Z · Substantial damageNTSB SEA08LA128Accident · Serious injuriesLimited investigationFinal reportMoravan Zlin 50LX · Modesto, CAThe pilot failed to maintain clearance from terrain during a low-altitude maneuver at an airshow. Contributing to the accident was the task overload in the increased frequency congestion.May 10, 2008 · N6660K · Substantial damageNTSB LAX08FA134Accident · 2 fatalField investigationFinal reportExtra Flugzeugproduktions-GMBH EA-300/L · Queen Creek, AZThe loss of aircraft control due to an undetermined rudder malfunction.May 9, 2008 · N133EE · Substantial damageNTSB NYC08LA176Accident · 2 fatalLimited investigationFinal reportDesalvatore Al Lancair IV-P · Snow Hill, NCAn inadvertent encounter with icing conditions, resulting in a loss of aircraft control. Contributing to the accident was the pilot's inadequate preflight and in-flight decision making.May 8, 2008 · N101BX · DestroyedNTSB NYC08FA174Accident · 3 fatalField investigationFinal reportBeech A35 · Americus, GAThe pilot's failure to maintain control during the initial climb for undetermined reasons.May 3, 2008 · N546B · Substantial damageNTSB CHI08CA122Accident · No injuriesData collectionFinal reportEvektor Aerotechnik SportStar Plus · Greenwood, INThe student pilot's failure to maintain control of the airplane during engine run-up.Apr 29, 2008 · N930LA · Substantial damageNTSB DFW08LA121Accident · 1 fatalLimited investigationFinal reportTromsness Enterprises Turbine LE · Miami, OKThe pilot's failure to maintain control of the airplane for undetermined reasons. Contributing to the accident included his extensive use of medications and/or his multiple medical conditions and the failure of the FAA to follow up on his reported medication…Apr 28, 2008 · N747CT · Destroyed