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 NYC08LA253Accident · Serious injuriesLimited investigationFinal reportCarrithers Carl L VP1 · Starkville, MSThe pilot's failure to maintain clearance from trees during takeoff. Contributing to the accident was the pilot's impairment by alcohol.Jul 22, 2008 · N822CB · Substantial damageNTSB LAX08LA231Accident · 1 fatalLimited investigationFinal reportNichols Rans S-14 · Benson, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot's impairment from recent marijuana use.Jul 18, 2008 · N923GN · Substantial damageNTSB ANC08LA085Accident · No injuriesLimited investigationFinal reportCessna 185 · McCarthy, AKThe pilot's improper fuel management which resulted in fuel starvation and a loss of engine power during cruise flight. Contributing to the accident was an aerodynamic stall during the emergency landing, the pilot's fatigue, and his unfamiliarity with the…Jul 4, 2008 · N80596 · Substantial damageNTSB NYC08FA237Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Middletown, RIThe flight instructor's failure to initiate a go-around during a high approach, and his inadequate remedial action during an attempted touch-and-go.Jul 3, 2008 · N9888K · Substantial damageNTSB NYC08LA235Accident · 1 fatalLimited investigationFinal reportLanier James A Talon XP · Cleveland, GAAn inadvertent stall during the initial climb.Jul 2, 2008 · N1974L · DestroyedNTSB DFW08FA170Accident · 5 fatalField investigationFinal reportCessna U206F · Santa Rosa, NMThe pilot's failure to maintain safe flying airspeed for undetermined reasons resulting in an inadvertent stall.Jun 29, 2008 · N2905Q · DestroyedNTSB DFW08LA166Accident · 1 fatalLimited investigationFinal reportBeech 99 · Bowling Green, MOThe parachutist's failure to follow procedures/directives by not waiting to jump until the green jump light was illuminated, resulting in his collision with the airplane's tail. Contributing to the accident was the parachutist's impairment by the use of…Jun 21, 2008 · N99NN · 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 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 DFW08FA153Accident · 2 fatalField investigationFinal reportCessna 310Q · Steamboat, COThe pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.May 25, 2008 · N8187Q · DestroyedNTSB DEN08LA096Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Roanoke, TXThe pilot's physiologic impairment and failure to attain the proper touchdown point during an intentional off airport landing. Contributing to the accident was the pilot's improper in-flight planning.May 24, 2008 · N33384 · Substantial damageNTSB NYC08FA184Accident · 2 fatalField investigationFinal reportCessna 337A · West Creek, NJThe pilot's departure with insufficient fuel for the planned flight, and his improper in-flight fuel management, which resulted in a total loss of power in both engines due to fuel starvation. Contributing to the accident was the pilot's fatigue, which was…May 17, 2008 · N5382S · Substantial damageNTSB LAX08FA144Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 MK I · Stehekin, WAThe pilot's failure to retract the landing gear wheels prior to performing a water landing. Contributing to the accident were the pilot's disabling of the landing gear warning/advisory system and possible fatigue due to his work schedule.May 17, 2008 · N9558Q · Substantial damageNTSB LAX08LA140Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Maria, CAThe pilot's impairment from alcohol and his improper flare, which resulted in a bounced landing. Contributing to the accident was the FAA's failure to obtain additional information about the pilot's alcohol use history to verify that he met the requirements…May 15, 2008 · N4660K · 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 · DestroyedNTSB DFW08FA111Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Hemphill, TXA loss of control for undetermined reasons.Apr 22, 2008 · N729SR · DestroyedNTSB CHI08LA101Accident · 2 fatalLimited investigationFinal reportCessna 172K · Roseglen, NDThe pilot failed to maintain obstacle clearance from the TV antenna during a low altitude maneuver. Contributing factors were the antenna, the night conditions, and pilot impairment due to alcohol.Apr 11, 2008 · N7490G · Substantial damageNTSB DEN08FA059Accident · 2 fatalField investigationFinal reportCessna 414A · Benton, KSThe pilot's failure to maintain clearance from the trees. Contributing to the accident was the pilot's flight into known adverse weather conditions and the low clouds and visibility.Feb 17, 2008 · N41LP · DestroyedNTSB SEA08IA080Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Hilo, HIThe captain and first officer inadvertently falling asleep during the cruise phase of flight. Contributing to the incident were the captain's undiagnosed obstructive sleep apnea and the flight crew’s recent work schedules, which included several consecutive…Feb 13, 2008 · N651BR · No damageNTSB NYC08MA090Accident · 6 fatalMajor investigationFinal reportRaytheon C90A · Mount Airy, NCThe pilot's failure to maintain control of the airplane in instrument meteorological conditions. Contributing to the accident were the pilot's improper decision to descend below the minimum descent altitude, and failure to follow the published missed approach…Feb 1, 2008 · N57WR · Substantial damageNTSB LAX08FA047Accident · 1 fatalField investigationFinal reportBeechcraft V35B · Selma, CAThe pilot's failure to maintain control resulting in the in-flight break-up of the airplane due to aerodynamic overload. Contributing factors included the pilot's impairment due to multiple medical conditions and due to recent use of alcohol.Jan 18, 2008 · N4662M · Substantial damageNTSB DFW08FA057Accident · 1 fatalField investigationFinal reportPiper PA46-500TP · San Antonio, TXThe pilot's failure to execute an instrument approach. Contributing to the accident was the pilot's impairment due to recent use of over-the-counter medication.Jan 18, 2008 · N169CA · DestroyedNTSB CHI08FA066Accident · 1 fatalField investigationFinal reportHawker Beechcraft 58 · Cleveland, OHThe pilot experienced spatial disorientation during the inital climb causing him to lose control of the airplane.Jan 17, 2008 · N3217L · Substantial damage