NTSB investigations

674 cases where NTSB found Physical.

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\", '0201'))
  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 CEN09LA488Accident · Serious injuriesLimited investigationFinal reportPiontkowski Challenger · Kankakee, ILThe pilot's failure to maintain clearance from the telephone line and his poor judgment to fly while under the influence of alcohol. Contributing to the accident was the pilot's impairment due to the alcohol consumption.Aug 3, 2009 · N4526G · Substantial damageNTSB ERA09FA429Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Ravenswood, WVThe pilot's improper modification of the certified, on-board oxygen system, which resulted in incapacitation due to hypoxia, and the airplane's subsequent uncontrolled descent into terrain.Jul 31, 2009 · N581DS · DestroyedNTSB CEN09IA606Incident · No injuriesIncident investigationFinal reportSaab 340B · Traverse City, MIThe flight attendant's incapacitation due to an anxiety attack.Jul 31, 2009 · N452XJ · No damageNTSB CEN09FA462Accident · 1 fatalField investigationFinal reportBeech V35 · Oklahoma City, OKThe pilot’s decision to operate an airplane with known deficiencies, and the loss of engine power during climb for undetermined reasons.Jul 25, 2009 · N9112S · 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 CEN09CA372Accident · No injuriesData collectionFinal reportCessna 177 RG · Albuquerque, NMThe pilot's failure to maintain adequate airspeed while landing, resulting in an aerodynamic stall.Jun 22, 2009 · N1876Q · Substantial damageNTSB CEN09FA363Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Crystal, MNThe pilot's failure to maintain airspeed which resulted in a loss of aircraft control during a go-around. Factors associated with the accident were the dark night lighting conditions, moderate to heavy rain, and fatigue.Jun 17, 2009 · N214BN · DestroyedNTSB ERA09FA343Accident · 1 fatalField investigationFinal reportCessna 177 RG · Gilford, NHA loss of engine power due to oil exhaustion from the fracture of the nipple for the engine oil cooler return line. Contributing to the accident was the mechanic's signoff and release of the airplane without performing the required engine run-up following an…Jun 13, 2009 · N52670 · Substantial damageNTSB CEN09LA350Accident · 1 fatalLimited investigationFinal reportPeterson Allen L Dragonfly II · Arthur, NEThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's impairment due to the use of a over-the-counter medication with sedative effects and spatial disorientation.Jun 11, 2009 · N360KK · DestroyedNTSB CEN09PA348Accident · 2 fatalClass 1Final reportAgusta A109E · Santa Fe, NMThe pilot's decision to take off from a remote, mountainous landing site in dark (moonless) night, windy, instrument meteorological conditions. Contributing to the accident were an organizational culture that prioritized mission execution over aviation safety…Jun 10, 2009 · N606SP · DestroyedNTSB CEN09LA311Accident · 2 fatalLimited investigationFinal reportThornton RV-6A · Plainwell, MIThe pilot's failure to maintain aircraft control for undetermined reasons.May 21, 2009 · N39JT · DestroyedNTSB DCA09FA048Accident · Serious injuriesField investigationFinal reportBoeing DC-10 · Baltimore, MDthe captain’s inappropriate control inputs following a firm landing, resulting in two hard nose-gear impacts before executing a go-around. Contributing to the inappropriate control inputs was the captain’s fatigue and physical discomfort; and a possible lack…May 6, 2009 · N139WA · Substantial damageNTSB CEN09LA263Accident · 1 fatalLimited investigationFinal reportLaseure Sonerai II · Grantsburg, WIThe pilot's failure to maintain airspeed during initial climb which resulted in a stall/spin. Contributing to the accident was the degraded engine performance.Apr 22, 2009 · N232PE · DestroyedNTSB ERA09IA240Incident · 1 fatalIncident investigationFinal reportBeech B200 · Fort Myers, FLThe pilot’s abnormal heart rhythm resulting in incapacitation.Apr 12, 2009 · N559DW · No damageNTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.Apr 6, 2009 · N610RJ · Substantial damageNTSB ERA09LA229Accident · 1 fatalLimited investigationFinal reportGaynor Donald J RV6A · Englewood, FLThe pilot's operation of the airplane while impaired (alcohol) and his decision to attempt aerobatic maneuvers at a low altitude resulting in the loss of aircraft control and subsequent collision with trees.Apr 4, 2009 · N88WG · Substantial damageNTSB ERA09LA222Accident · Serious injuriesLimited investigationFinal reportRogers Kenneth J Flaglor Scooter · Griffin, GAA total loss of engine power due to the failure of the engine-driven fuel pump. Contributing to the accident was unsuitable terrain for a forced landing and the pilot’s preexisting medical condition.Mar 30, 2009 · N3248Q · Substantial damageNTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.Mar 14, 2009 · N5098L · Substantial damageNTSB 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 CEN09FA195Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Golden, NMThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of alcohol and his subsequent impairment.Mar 9, 2009 · N9646L · DestroyedNTSB WPR09FA146Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA-40 · Arcata, CAThe pilot's failure to maintain proper altitude and glidepath while executing a night instrument approach. Contributing to the accident was the pilot's fatigue.Mar 2, 2009 · N521DS · DestroyedNTSB DCA09MA027Accident · 50 fatalClass 1 · MajorFinal reportBombardier DHC-8-402 · Clarence Center, NYThe captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…Feb 13, 2009 · N200WQ · DestroyedNTSB CEN09MA142Accident · Serious injuriesClass 1 · MajorFinal reportAerospatiale Alenia ATR 42-320 · Lubbock, TXThe flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…Jan 27, 2009 · N902FX · Substantial damageNTSB ERA09LA132Accident · 1 fatalLimited investigationFinal reportCessna 172 · Hardin, KYThe pilot's failure to maintain aircraft control and his impairment from illegal drug use.Jan 9, 2009 · N28RP · Substantial damageNTSB CEN09FA099Accident · 1 fatalField investigationFinal reportPiper PA-32R · North Canton, OHThe pilot’s inappropriate control inputs as a result of spatial disorientation, which led to an aerodynamic stall and loss of control. Contributing to the accident were the pilot's decision to conduct flight into known icing conditions, ice accumulation that…Dec 19, 2008 · N9299N · DestroyedNTSB CEN09FA087Accident · 1 fatalField investigationFinal reportBeech C90 · Rocksprings, TXThe pilot's failure to properly configure the pressurization controls, resulting in his impairment and subsequent incapacitation due to hypoxia.Dec 14, 2008 · N43KM · Substantial damageNTSB CEN09FA070Accident · 3 fatalField investigationFinal reportPiper PA46-500TP · Marshfield, WIThe pilot's failure to maintain control of the airplane during final approach for landing in night, visual meteorological conditions for undetermined reasons.Nov 23, 2008 · N67TE · DestroyedNTSB CEN09LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Downers Grove, ILThe pilot's failure to maintain a proper glidepath while on final approach in night conditions, due to his impairment from recent use of alcohol, cocaine, and over-the-counter and prescription medications.Nov 16, 2008 · N759HF · Substantial damageNTSB CEN09LA054Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Mena, ARThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's continued flight into deteriorating weather conditions.Nov 11, 2008 · N2526V · Substantial damageNTSB WPR09LA032Accident · 1 fatalLimited investigationFinal reportUniversal Globe · Wallace, CAThe pilot's incapacitation during cruise for unknown reasons that resulted in a loss of aircraft control.Nov 7, 2008 · N80715 · DestroyedNTSB ERA09LA043Accident · 1 fatalLimited investigationFinal reportMiller J Kirtley RV-6 · Martinsville, VAThe pilot's failure to maintain aircraft control during the initial climb after an aborted landing. Contributing to the accident was the pilot's impairment from an over-the-counter sedating antihistamine.Nov 7, 2008 · N8LK · Substantial damageNTSB ERA09CA034Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Bridgeport, CTThe pilot's loss of directional control during landing and while suffering symptoms of vertigo.Nov 1, 2008 · N4540L · Substantial damageNTSB CEN09FA043Accident · 1 fatalField investigationFinal reportCessna 175 · Mt. Dora, NMThe pilot's failure to maintain clearance from rising terrain for undetermined reasons.Oct 29, 2008 · N175JG · DestroyedNTSB ERA09FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Selmer, TNThe pilot's failure to avoid terrain during night instrument meteorological conditions.Oct 24, 2008 · N7510Y · Substantial damageNTSB WPR09LA016Accident · 1 fatalLimited investigationFinal reportHeisler Lancair Legacy · Parowan, UTThe pilot failed to secure the canopy prior to takeoff, resulting in his inability to control the aircraft during the takeoff. Contributing to the accident was the pilot’s impairment from prescription medications and possible obstructive sleep apnea.Oct 18, 2008 · N151HT · Substantial damageNTSB ERA09LA019Accident · 1 fatalLimited investigationFinal reportHargett Sky Ranger II · Rock Hill, SCThe non-certificated pilot's failure to maintain airspeed, which resulted in an inadvertent stall and a subsequent impact with the ground. Contributing to the accident were the pilot's lack of training and his impairment due to recent use of marijuana.Oct 16, 2008 · N75684 · Substantial damageNTSB ERA09FA022Accident · 1 fatalField investigationFinal reportRobinson R22 · Dryden, NYThe pilot's continued visual flight into instrument meteorological conditions which resulted in controlled flight into terrain.Oct 16, 2008 · N943MH · Substantial damageNTSB CEN09FA012Accident · 2 fatalField investigationFinal reportBell 206 · Conroe, TXA loss of control for undetermined reasons.Oct 13, 2008 · N6ZV · DestroyedNTSB ERA09LA013Accident · 1 fatalLimited investigationFinal reportSabre Tukan · Mohawk, TNThe pilot's loss of control in flight due to a lack of flight experience or instruction. Contributing to the accident was the pilot's impairment due to the recent use of marijuana and a prescription painkiller.Oct 12, 2008 · N75604 · Substantial damageNTSB DEN08FA162Accident · 1 fatalField investigationFinal reportPilatus PC-12/47E · Santa Fe, NMThe pilot's incapacitation due to fatigue resulting in an in-flight collision with terrain.Sep 30, 2008 · N606SL · DestroyedNTSB DFW08FA237Accident · 2 fatalField investigationFinal reportCessna 320D · Collinsville, OKThe crews' failure to maintain adequate airspeed, which resulted in an aerodynamic stall close to the ground.Sep 28, 2008 · N4165T · Substantial damageNTSB 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 MIA08FA177Accident · 1 fatalField investigationFinal reportCessna T310R · Latrobe, PAThe pilot's impairment/incapacitation (cardiovascular) resulting in the pilot being unable to control the airplane.Aug 31, 2008 · N3180M · 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 SEA08FA185Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Olalla, WAThe complete loss of engine power due to the accumulation of ice in the carburetor as a result of the pilot's failure to use carburetor heat.Aug 17, 2008 · N301MA · DestroyedNTSB LAX08FA261Accident · 1 fatalField investigationFinal reportCessna 172S · Incline Village, NVThe pilot's decision to initiate a flight for which he was neither approved nor qualified and his failure to maintain terrain clearance during the flight. Contributing to the accident were the dark night, the mountainous terrain, and the pilot's medical…Aug 8, 2008 · N15963 · Substantial damageNTSB MIA08LA161Accident · 1 fatalLimited investigationFinal reportGT Ultralights Airborne Edge X · Franklin, METhe pilot's improper decision to perform low-altitude maneuvers and his failure to maintain clearance from the surface of the bay. Contributing to the accident was the pilot's impairment due to alcohol.Aug 5, 2008 · UNREG · Substantial damageNTSB DCA08MA085Accident · 8 fatalClass 1 · MajorFinal reportRaytheon Corporate Jets BAE 125-800A · Owatonna, MNThe captain’s decision to attempt a go-around late in the landing roll with insufficient runway remaining. Contributing to the accident were (1) the pilots’ poor crew coordination and lack of cockpit discipline; (2) fatigue, which likely impaired both pilots’…Jul 31, 2008 · N818MV · DestroyedNTSB 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 · Destroyed