NTSB investigations, OH
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA' 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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' 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 CEN18LA301Accident · Serious injuriesLimited investigationFinal reportFlightstar SC II · Painesville, OHThe student pilot’s failure to maintain an airspeed below flight speed during a practice taxi run, which resulted in the airplane inadvertently becoming airborne. Once airborne, the reduced engine power due to an improper propeller pitch setting and…NTSB CEN18LA284Accident · No injuriesLimited investigationFinal reportToomey Quickie · Zanesville, OHThe failure of the exhaust manifold and a loose mixture screw, which resulted in a partial loss of engine power.NTSB GAA18CA426Accident · No injuriesData collectionFinal reportPiper PA 20 · Dayton, OHThe pilot's inadequate compensation for variable crosswind conditions during landing, which resulted in a runway excursion.NTSB GAA18CA425Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN18LA275Accident · No injuriesLimited investigationFinal reportWhittman Tailwind · Orient, OHThe pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…NTSB CEN18IA273Incident · No injuriesIncident investigationFinal reportCessna A188B · Rockford, OHThe total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.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 CEN18LA239Accident · Serious injuriesLimited investigationFinal reportSibila MH-1 · Beach City, OHThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA295Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Batavia, OHThe student pilot’s use of an improper engine hand-propping procedure, which resulted in the airplane’s unexpected movement.NTSB CEN18LA173Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Hamilton, OHThe loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Orrville, OHThe pilot's failure to attain adequate airspeed during the soft field takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB GAA18CA276Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…NTSB GAA18CA249Accident · No injuriesData collectionFinal reportHughes 369 · Newark, OHThe pilot’s failure to maintain adequate clearance from transmission power wires, which resulted in a tail rotor strike.NTSB CEN18FA143Accident · 2 fatalField investigationFinal reportBeech G33 · Warsaw, OHThe pilot's decision to continue flight in known icing conditions, which resulted in structural icing, degraded airplane performance, and a subsequent loss of control. Contributing to the accident was the pilot's failure to obtain an official weather briefing…NTSB GAA18CA150Accident · No injuriesData collectionFinal reportCessna 172 · Kent, OHA deer collided with aircraft during landing at night.NTSB GAA18CA144Accident · No injuriesData collectionFinal reportPiper PA 22 · Ashland, OHThe pilot’s failure to maintain directional control during the landing roll resulting in a ground loop.NTSB CEN18LA094Accident · No injuriesLimited investigationFinal reportRaytheon 400A · Cleveland, OHThe airplane's reduced braking performance due to an ice-covered runway, which resulted in a runway excursion. Contributing to the accident was the crew's selection of a runway with a tailwind.NTSB CEN18FA074Accident · 2 fatalField investigationFinal reportMD Helicopters 369HM · Perrysburg, OHA loss of engine power due to snow or ice ingestion at an altitude that was insufficient to allow for engine re-ignition. Contributing to the accident were conditions, including altitude and flat light conditions, that precluded a successful autorotation to…NTSB CEN18LA073Accident · No injuriesLimited investigationFinal reportS.O.C.A.T.A. MS893E · Wadsworth, OHThe pilot’s failure to apply carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.NTSB CEN18LA064Accident · No injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Paulding, OHThe loss of engine power while the motor-powered glider was maneuvering due to the fuel unporting in its fuel tank, which resulted in fuel starvation and a subsequent forced landing on unsuitable terrain.NTSB GAA18CA089Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Newark, OHThe pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in dynamic rollover.NTSB CEN18FA045Accident · 1 fatalField investigationFinal reportPiper Titan Tornado II D · Ravenna, OHThe pilot's failure to maintain adequate airspeed following a loss of engine power during final approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.NTSB CEN18LA036Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Carroll, OHThe total loss of engine power due to carburetor icing.NTSB GAA18CA038Accident · Minor injuriesData collectionFinal reportPiper PA28 · Batavia, OHThe pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing.NTSB GAA18CA019Accident · No injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Dayton, OHThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN18LA014Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Gustavus, OHThe pilot’s geographic disorientation while maneuvering in the airport traffic pattern in dark night conditions, which resulted in the airplane descending below a normal approach path and a collision with trees. Contributing to the accident was the pilot's…NTSB GAA18CA008Accident · No injuriesData collectionFinal reportCessna 150 · Medina, OHThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB CEN17LA376Accident · No injuriesLimited investigationFinal reportCessna 182M · Piqua, OHThe accumulation of carburetor ice while operating at a reduced engine power setting, which resulted in a total loss of engine power on approach and a subsequent forced landing on unsuitable terrain.NTSB CEN17LA358Accident · No injuriesLimited investigationFinal reportCessna 177B · London, OHThe flight instructor's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.NTSB CEN17LA311Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Wellston, OHThe failure of a connecting rod small end bushing, which resulted in a loss of engine power.NTSB CEN17LA305Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Marion, OHThe pilot’s failure to follow the before takeoff checklist, which resulted in an improper takeoff configuration and subsequent uncontrolled descent into terrain during a departure climb.NTSB CEN17LA295Accident · Minor injuriesLimited investigationFinal reportSteele Acro Sport II · Loudonville, OHA partial loss of engine power due to carburetor icing.NTSB GAA17CA425Accident · No injuriesData collectionFinal reportPiper PA28R · Bowling Green, OHThe pilot’s and flight instructor’s failure to extend the landing gear.NTSB CEN17FA258Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Waterford, OHThe pilot's loss of airplane control due to spatial disorientation in instrument meteorological conditions.NTSB CEN17LA322Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Hamilton, OHThe pilot's loss of directional control after landing for reasons that could not be determined because an examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB CEN17LA261Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Wauseon, OHThe flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA234Accident · 1 fatalLimited investigationFinal reportAeronca 65 CA · Mount Vernon, OHThe pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.NTSB GAA17CA335Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot’s rudder overcorrection during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA337Accident · No injuriesData collectionFinal reportCessna 172 · Ravenna, OHThe flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…NTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.NTSB CEN17FA207Accident · 1 fatalField investigationFinal reportVarga 2150A · Bowling Green, OHThe pilot's loss of control due to impairment from carbon monoxide poisoning. Contributing to the accident was the corrosion of the heat exchanger and the failure of maintenance personnel to adequately inspect and repair or replace the exchanger during the…NTSB GAA17CA297Accident · Minor injuriesData collectionFinal reportCGS Hawk · Findlay, OHThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA17CA282Accident · No injuriesData collectionFinal reportPiper PA23 · Fremont, OHThe pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.NTSB GAA17CA266Accident · No injuriesData collectionFinal reportCessna T182 · Portage County Airport, OHThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.NTSB ENG17IA017Incident · No injuriesIncident investigationFinal reportDouglas DC 9 83 · Dayton, OHThe probable cause of the No. 2 (right) engine fire was an uncontained generator failure. Deformed rotating generator components and/or metal fragments radially released by the generator severed the constant speed drive-to-oil cooler return line located…NTSB CEN17FA108Accident · 1 fatalField investigationFinal reportMacleod Homebuilt · Springfield, OHThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control at an altitude too low for a safe recovery.