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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR19FA150Accident · 1 fatalClass 3 · FieldFinal reportBeech 35 · Melba, IDThe pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.NTSB WPR19FA148Accident · 2 fatalClass 3 · FieldFinal reportRobinson R44 · Alpine, UTThe noninstrument-rated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control. Contributing to the accident was hypoxia due to the high altitude at which…NTSB CEN19MA141Accident · 6 fatalClass 1 · MajorFinal reportDe Havilland DHC-2 · Ketchikan, AKThe inherent limitations of the see-and-avoid concept, which prevented the two pilots from seeing the other airplane before the collision, and the absence of visual and aural alerts from both airplanes’ traffic display systems, while operating in a geographic…NTSB WPR19FA143Accident · 1 fatalClass 3 · FieldFinal reportTop Dog TopDog Ultralight · Creswell, ORThe non-certificated pilot's loss of control while maneuvering. Contributing to the accident was his lack of training in the aircraft and his impairment from illicit drugs.NTSB ERA19FA170Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 30 · Naples, FLIncapacitation of the pilot due to a birdstrike through the windshield in front of the pilot's position, while on approach to land.NTSB ANC19FA018Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, NMThe pilot's loss of airplane control due to his failure to maintain appropriate control inputs and airspeed after shutting down an engine because of a progressive failure of the pressure relief valve in the fuel pump, which resulted in variable fuel pressure…NTSB ERA19FA155Accident · 2 fatalClass 2 · FieldFinal reportBellanca 1730 · Henderson, KYThe student pilot's failure to maintain proper airspeed, which resulted in the exceedance of the airplane's critical angle of attack at a low altitude, in the airport traffic pattern, following a total loss of engine power due to fuel exhaustion. Contributing…NTSB CEN19FA120Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Lake, MSThe noninstrument-rated pilot’s loss of control while flying in dark night instrument meteorological weather conditions with convective activity, which resulted in the airplane exceeding its structural limitations and experiencing an in-flight breakup.…NTSB CEN19FA117Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT 502 · Harlingen, TXThe pilot’s failure to maintain clearance from power transmission lines during low altitude flight operations. Contributing to the accident was the pilot’s impairment due to a sedating medication.NTSB WPR19FA106Accident · 2 fatalClass 3 · FieldFinal reportTecnam P2002 · Santa Fe, NMThe flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.NTSB CEN19LA092Accident · Minor injuriesLimited investigationFinal reportBell 407 · Union Center, SDThe ambulance driver’s failure to see the helicopter’s rotating main rotor blades in dark night conditions, which resulted in the ambulance’s inadvertent collision with the helicopter. Contributing to the accident was the ambulance driver's failure to follow…NTSB WPR19FA077Accident · 1 fatalClass 2 · FieldFinal reportRockwell 112 · Mt Hood, ORThe pilot's decision to fly the airplane in close proximity to mountainous terrain in an area of mountain wave activity that exceeded the performance capabilities of the airplane. Contributing to the accident was the pilot's degraded decision making and…NTSB CEN19LA056Accident · 2 fatalLimited investigationFinal reportDouglas DC3C · Kidron, OHThe loss of airplane control after an engine flameout and auto-feather system interruption during the takeoff climb, which resulted in an impact with terrain.NTSB CEN19LA053Accident · 1 fatalLimited investigationFinal reportPiper PA28 · Salem, SDThe incapacitating effects of an acute myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.NTSB GAA19CA083Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Rock Hill, SCThe pilot's improper decision to fly with an air cast boot on his foot, which led him to rely on the passenger to apply brakes and rudder, which was performed improperly and led to a loss of directional control.NTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…NTSB WPR19FA022Accident · 4 fatalClass 2 · FieldFinal reportPiper PA28 · Guthrie Center, IAPilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.NTSB WPR19LA013Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Kaneohe, HIThe pilot’s sudden incapacitation from an undiagnosed heart condition during flight, which resulted in a hard landing.NTSB ERA19LA014Accident · Serious injuriesClass 3 · LimitedFinal reportHargrove Hummel Ultra Cruiser · Zephyrhills, FLThe pilot's failure to activate the airplane’s auxiliary fuel pump, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were the impairing effects of the pilot’s medication on his performance.NTSB ERA19LA012Accident · 3 fatalLimited investigationFinal reportPiper PA34 · Westhampton Beach, NYThe instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…NTSB ERA19FA003Accident · 1 fatalField investigationFinal reportPiper J3C · Fancy Gap, VAThe non-instrument-rated pilot's improper decision to undertake a flight into forecast instrument meteorological conditions (IMC) and his subsequent decision to continue the flight after encountering IMC, which resulted in controlled flight into terrain.…NTSB GAA18CA577Accident · No injuriesData collectionFinal reportAviat A1 · Grand Island, NEThe pilot’s failure to maintain directional control during the landing roll in tailwind and crosswind conditions. Contributing to the accident was the pilot’s fatigue.NTSB WPR18FA244Accident · 1 fatalField investigationFinal reportCessna 150 · Redding, CAThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's failure to properly configure the wing flaps for…NTSB ERA18FA235Accident · 1 fatalField investigationFinal reportAirtime Cygnet · Pensacola, FLThe student pilot's loss of aircraft control for undetermined reasons.NTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…NTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.NTSB CEN18LA274Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lakeview, ARThe student pilot’s impairment by alcohol and multiple medications, which led to his failure to maintain obstacle clearance during takeoff and the subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and…NTSB ERA18FA187Accident · 2 fatalField investigationFinal reportRobinson R44 · Williamsburg, VAThe pilot's failure to safely operate the helicopter due to his impaired cognitive and physical abilities, which resulted in a loss of control.NTSB CEN18LA245Accident · 1 fatalLimited investigationFinal reportKubicek BB30 · Ashland, OHThe pilot's failure to ensure that he was secure in the balloon's basket after landing, which resulted in him falling and striking his head on the burners when the wind caught the envelope and tipped the basket over. Contributing to the accident was the…NTSB CEN18FA242Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Arthur, NEThe pilot's failure to recover from a spin for reasons that could not be determined based on the available information.NTSB WPR18LA163Accident · 1 fatalLimited investigationFinal reportNorth Wing Pulse · Mountain Home, IDThe hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…NTSB CEN18LA205Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Union, ILThe pilot’s medical impairment at the time of the accident, which resulted in a collision with power lines off the end of the runway.NTSB CEN18FA149Accident · 3 fatalField investigationFinal reportEurocopter AS 350 B2 · Hazelhurst, WIThe pilot's loss of helicopter control as a result of fatigue during cruise flight at night.NTSB ERA18FA127Accident · 1 fatalField investigationFinal reportCessna 525 · Crozet, VAThe pilot's loss of control while operating in night instrument meteorological conditions as a result of spatial disorientation. Contributing to the accident was the pilot's decision to operate an airplane after consuming alcohol and his resulting…NTSB ERA18LA087Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander Callair A 9 · Bunn, NCThe glider instructor's delayed remedial action when the glider became out of position during aerotow, which resulted in excessive side-loading of the release hook and a delay in the glider's release from tow, which resulted in the towplane’s descent and…NTSB GAA18CA174Accident · No injuriesData collectionFinal reportCessna P210 · Jacksonville, FLThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were pilot fatigue and his failure to use the before landing checklist.NTSB WPR18FA091Accident · 1 fatalField investigationFinal reportPiper PA34 · Minden, NVThe pilot's loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot's impairment from the use of a sedating antihistamine.NTSB ERA18FA064Accident · 1 fatalField investigationFinal reportVans RV-12 · Bonita Springs, FLThe pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.NTSB CEN18FA400Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22T · Gulf of Mexico (Gulf of Mexico)The pilot's incapacitation resulted in impact with the Gulf of Mexico. The reason the hypoxia recognition system did not descend the airplane as designed could not be determined as the airplane was not located.NTSB WPR18FA063Accident · 2 fatalField investigationFinal reportCessna 172M · Ogden, UTThe pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.NTSB CEN18FA060Accident · 1 fatalField investigationFinal reportX-Air XA85 · Oskaloosa, IAThe pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.NTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…NTSB ANC18FA007Accident · 1 fatalField investigationFinal reportIcon A5 · Clearwater, FLThe pilot's improper decision to perform aggressive, low-altitude maneuvers due to his impairment from the use of multiple psychoactive substances, which resulted in a loss of control.NTSB ANC18LA005Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Anchorage, AKThe pilot's failure to extend the landing gear before landing, which resulted in a gear-up landing. Contributing to the accident was the pilot's fatigue and complacency.NTSB ERA18FA006Accident · 1 fatalField investigationFinal reportPiper PA 25-235 · Front Royal, VAThe tow plane pilot's loss of airplane control for reasons that could not be determined based on the available evidence. Contributing to the accident was the glider instructor's diversion of attention away from the tow airplane which resulted in his delay in…NTSB ERA18FA005Accident · 1 fatalField investigationFinal reportBryant C Crosby BC Ultra PUP · Bardstown, KYThe pilot's improper decision to initiate a flight in an airplane he had never flown and with no currency in any airplane nor a medical certificate, which resulted in his loss of airplane control. Contributing to the accident was the pilot's psychiatric…NTSB ERA18FA004Accident · 2 fatalField investigationFinal reportCessna 401 · Salters, SCThe pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…NTSB ERA17LA269Accident · Serious injuriesLimited investigationFinal reportRose Herbert D Pietenpol AIR Camper · Tower City, PAThe pilot's incapacitation due to fainting as a result of complications from a previously undiagnosed heart condition.NTSB CEN17FA315Accident · 1 fatalField investigationFinal reportPiper PA 22-150 · Las Vegas, NMThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to land, which resulted in an accelerated stall and the pilot’s subsequent loss of control. Contributing to the accident was the gap in the pilot’s flight experience, his…