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 CEN11FA467Accident · 1 fatalField investigationFinal reportRans S-12 · Scott, ARThe pilot’s loss of airplane control, likely due to a cardiac event.Jul 9, 2011 · N3266R · Substantial damageNTSB ERA11FA369Accident · 2 fatalField investigationFinal reportCessna 172M · Poughkeepsie, NYThe pilot’s loss of airplane control due to impairment or incapacitation as a result of coronary artery disease in combination with atrial fibrillation. Contributing to the accident was the pilot's failure to report his paroxysmal atrial fibrillation to the…Jun 28, 2011 · N61579 · Substantial damageNTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Jun 21, 2011 · N3661B · Substantial damageNTSB WPR11FA268Accident · 1 fatalField investigationFinal reportTrusty Thorp T-18 · Tehachapi, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.Jun 20, 2011 · N851LT · Substantial damageNTSB WPR11LA260Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Buttonwillow, CAThe pilot's misjudgment of the landing approach and subsequent long landing and overrun of the runway resulting in a collision with ground obstacles. Contributing to the accident was the pilot's likely fatigue and dehydration.Jun 14, 2011 · N5286 · Substantial damageNTSB ANC11LA041Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Nome, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's decision to fly the airplane with an inoperative wing flap system.Jun 2, 2011 · N168TT · Substantial damageNTSB WPR11FA241Accident · 3 fatalField investigationFinal reportCessna R172K · Cold Springs, NVThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a controlled collision with terrain.May 29, 2011 · N9831V · Substantial damageNTSB CEN11LA365Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Freemont, MIThe pilot’s failure to attain a positive climb rate following takeoff for reasons that could not be determined because the propeller was not provided for further examination. Contributing to the accident was the pilot's impairment from alcohol.May 27, 2011 · N60147 · Substantial damageNTSB ERA11CA322Accident · No injuriesData collectionFinal reportCessna 140A · Quincy, FLThe private pilot's inability to maintain directional control of the airplane during the takeoff roll.May 26, 2011 · N1137D · Substantial damageNTSB CEN11FA346Accident · 1 fatalField investigationFinal reportHansen IB C Cassutt III M · Erie, COThe pilot's incapacitation due to a cardiac event.May 22, 2011 · N420FH · Substantial damageNTSB ANC11TA031Accident · Minor injuriesFinal reportBeech B200 · Atqasuk, AKThe pilot did not maintain sufficient airspeed during an instrument approach in icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident were the pilot’s fatigue, the operator’s decision to initiate the flight…May 16, 2011 · N786SR · Substantial damageNTSB WPR11LA223Accident · 1 fatalLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Arlington, WAThe pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.May 14, 2011 · N282SC · Substantial damageNTSB ERA11LA300Accident · Serious injuriesLimited investigationFinal reportCarothers Zenith CH701 · Tidioute, PAThe pilot's impairment due to alcohol and failure to maintain altitude on approach to landing, resulting in an in-flight collision with a tree.May 13, 2011 · N433UB · Substantial damageNTSB ERA11LA266Accident · Serious injuriesLimited investigationFinal reportAirbus A330-323 · New York, NYThe flight attendant's inadvertent fall, which resulted in a serious injury.Apr 25, 2011 · N807NW · No damageNTSB ERA11CA238Accident · No injuriesData collectionFinal reportMooney M20K · Augusta, GAThe pilot's failure to extend the landing gear prior to landing. Contributing to the accident was the pilot’s reported fatigue.Apr 11, 2011 · N777CV · Substantial damageNTSB ERA11LA234Accident · 1 fatalLimited investigationFinal reportLet L 33 Solo · New Castle, VAPilot incapacitation shortly after takeoff for unknown reasons.Apr 10, 2011 · N286BA · Substantial damageNTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.Apr 10, 2011 · N100TK · Substantial damageNTSB WPR11FA188Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Laramie, WYThe pilot’s failure to maintain airplane control and to recover from an aerodynamic stall, which resulted in a spin.Apr 6, 2011 · N28WY · Substantial damageNTSB CEN11FA259Accident · 1 fatalField investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Boulder, COThe pilot's incapacitation for undetermined reasons, which resulted in a loss of control.Apr 1, 2011 · N633BG · Substantial damageNTSB ERA11FA218Accident · 2 fatalField investigationFinal reportCessna 310R · Pikeville, KYThe pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…Mar 30, 2011 · N1914G · Substantial damageNTSB CEN11FA253Accident · 3 fatalField investigationFinal reportPiper PA46-350P · Monroe, MIThe pilot's demonstration of poor judgment by attempting a high-speed pass several feet above the runway and his subsequent failure to maintain clearance from the runway.Mar 29, 2011 · N619VH · Substantial damageNTSB OPS11IA401Incident · No injuriesIncident investigationFinal reportArlington, VAThe tower controller's loss of consciousness induced by lack of sleep, fatigue resulting from working successive midnight shifts, and air traffic control scheduling practices.Mar 23, 2011 · No damageNTSB CEN11LA239Accident · 1 fatalLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COThe pilot's loss of glider control due to impairment or incapacitation caused by an episode of ventricular tachycardia.Mar 20, 2011 · N99AE · Substantial damageNTSB ERA11CA180Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Weston, FLThe pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.Mar 5, 2011 · N4168W · Substantial damageNTSB ERA11FA151Accident · 1 fatalField investigationFinal reportCessna 150E · Ware Shoals, SCThe non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.Feb 19, 2011 · N3022J · Substantial damageNTSB ERA11LA135Accident · Serious injuriesLimited investigationFinal reportBelcher William B II Firestar · West Blocton, ALThe student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Feb 6, 2011 · N43341 · Substantial damageNTSB WPR11FA103Accident · 1 fatalField investigationFinal reportCessna T206H · Stanwood, WAThe pilot did not confirm retraction of the landing gear before landing on water as a result of distraction. Contributing to the accident was the pilot coping with the death of a close family member in the days before the accident, which resulted in a…Jan 22, 2011 · N142HF · Substantial damageNTSB WPR11FA090Accident · 2 fatalField investigationFinal reportBeech S35 · Chester, CAThe pilot's loss of control while maneuvering to land, most likely due to spatial disorientation.Jan 7, 2011 · N5866S · Substantial damageNTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.Jan 4, 2011 · N1416F · Substantial damageNTSB CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…Dec 30, 2010 · N9103N · Substantial damageNTSB ERA11LA106Accident · No injuriesLimited investigationFinal reportEurocopter MBB-BK · Cherry Point, NCThe pilot's impairment during cruise flight due to a recurring stroke. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of the pilot's known medical condition.Dec 29, 2010 · N854EC · Substantial damageNTSB ERA11CA082Accident · Serious injuriesData collectionFinal reportBell 206L-3 · Canal Point, FLThe pilot's failure to maintain clearance from the ground while maneuvering at a low altitude. Contributing to the accident was the pilot’s fatigue.Dec 8, 2010 · N955GT · Substantial damageNTSB ERA11CA080Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Canal Point, FLPilot fatigue due to lack of sleep resulting in incapacitation (falling asleep) and ground contact while maneuvering at a low altitude.Dec 8, 2010 · N451DB · Substantial damageNTSB WPR11LA064Accident · 1 fatalLimited investigationFinal reportKennedy Lancair 320 · Hubbard, ORThe loss of control during takeoff for undetermined reasons. Contributing to the accident was the pilot's impairment from an over-the-counter sedating medication.Nov 29, 2010 · N42BK · Substantial damageNTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.Nov 18, 2010 · N273MA · Substantial damageNTSB WPR11FA046Accident · 1 fatalField investigationFinal reportCessna 150J · Tucson, AZThe pilot's inability to maintain airplane control while on final approach due to undiagnosed cardiac disease, which caused a medical emergency and subsequent pilot incapacitation.Nov 14, 2010 · N60858 · Substantial damageNTSB WPR11LA044Accident · No injuriesLimited investigationFinal reportPiper PA30 · Tucson, AZThe pilot's impairment by an undiagnosed medical condition, which resulted in a loss of directional control and subsequent collision with a building during the landing roll. Contributing to the accident was the pilot's decision to fly when he was not feeling…Nov 10, 2010 · N628R · Substantial damageNTSB ERA11CA046Accident · No injuriesData collectionFinal reportBombardier CL-600-2B19 · Pittsburgh, PAThe ground crew’s failure to detach the air-starter hose from the airplane before moving the cart away resulting in structural damage to a skin panel.Nov 2, 2010 · N454SW · Substantial damageNTSB CEN11LA045Accident · Serious injuriesLimited investigationFinal reportWalker Kenneth Sonex · San Angelo, TXThe pilot's loss of airplane control. Contributing to the accident was the pilot's impairment due to alcohol.Oct 29, 2010 · N234KS · Substantial damageNTSB CEN11GA020Accident · 1 fatalFinal reportBell 206B · Clarkson Valley, MOThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and decision-making, and his improper control inputs following the loss of engine power, which resulted in mast bumping and separation of the…Oct 15, 2010 · N96MP · Substantial damageNTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.Sep 16, 2010 · N2153S · Substantial damageNTSB WPR10FA448Accident · 3 fatalField investigationFinal reportBeech 65 · Redwood City, CAA loss of power in the right engine for undetermined reasons and the pilot’s subsequent failure to maintain adequate airspeed, which resulted in a loss of control. Contributing to the loss of control was the regulatory certification basis of the airplane that…Sep 2, 2010 · N832B · Substantial damageNTSB ERA10IA459Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron Canada 407 · Marion, VAThe cardiac impairment of the pilot during a positioning flight.Aug 31, 2010 · N516MT · No damageNTSB WPR10LA441Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spanish Fork, UTThe pilot did not extend the landing gear due to his impairment from alcohol.Aug 28, 2010 · N738MP · Substantial damageNTSB CEN10LA497Accident · 1 fatalLimited investigationFinal reportMiller Charles W Vans RV-7A · El Dorado, ARThe pilot's failure to maintain clearance with trees on takeoff at night. Contributing factors were fatigue and the pilot's lack of recent nighttime experience.Aug 20, 2010 · N474JM · Substantial damageNTSB WPR10LA407Accident · 1 fatalLimited investigationFinal reportClark RV-6A · Nampa, IDThe pilot's failure to maintain aircraft control, which resulted in a collision with terrain during a rejected inadvertent takeoff.Aug 16, 2010 · N621AL · Substantial damageNTSB WPR10CA394Accident · Minor injuriesData collectionFinal reportCessna 170 · Salt Lake City, UTThe pilot’s failure to maintain aircraft control during the landing roll.Aug 9, 2010 · N179MM · Substantial damageNTSB ANC10MA068Accident · 5 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Aleknagik, AKThe pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…Aug 9, 2010 · N455A · Substantial damageNTSB CEN10LA463Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Lindsay, NEThe loss of airplane control for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation and evidence was insufficient to definitively establish whether the…Aug 8, 2010 · N802BG · DestroyedNTSB CEN10LA459Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth VENTUS-2B · Batesville, TXBoth glider pilots' inability to see and avoid the other resulting in a mid-air collision.Aug 4, 2010 · N7470C · 2 aircraft · Substantial damage