NTSB investigations, OH
76 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 7 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 3 |
| 1989 | 5 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 3 |
| 2001 | 2 |
| 2002 | 6 |
| 2004 | 2 |
| 2006 | 3 |
| 2007 | 3 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 CHI08CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Alliance, OHThe pilot's inadvertent activation of the parking brake which resulted in the toe brakes becoming ineffective. Contributing to the accident was the airport perimeter fence, the ditch, and the vehicle.NTSB CHI08CA012Accident · No injuriesData collectionFinal reportCessna 210C · Columbus, OHThe hydraulic system pump leak which resulted in the failure of the emergency landing gear system to extend and lock the landing gear for landing and the flap system.NTSB CHI07CA058Accident · No injuriesData collectionFinal reportLearjet 35A · Columbus, OHThe pilot's failure to maintain aircraft control during an inflight maneuver which resulted in the design stress limits of the airplane being exceeded. A factor was the excessive airspeed encountered during recovery.NTSB CHI07LA043Accident · No injuriesLimited investigationFinal reportCessna 560 · North Canton, OHThe rupture of the hydraulic pressure hose assembly, which was caused by internal wear between the hose's fire sleeve and stainless steel braid, and the failure of the emergency landing gear assembly to deploy the right main landing gear during approach.…NTSB CHI07CA023Accident · Minor injuriesData collectionFinal reportMooney M20J · Akron, OHThe pilot's failure to maintain sufficient airspeed during final approach resulting in an inadvertent stall. Contributing factors were the airplane's low altitude at the time of the stall and the asymmetric flap configuration.NTSB CHI06LA124Accident · No injuriesLimited investigationFinal reportHughes 269B · Sullivan, OHFatigue failure of the fuselage-to-tail boom cluster fitting, and the secondary failure of the tail rotor drive shaft. An additional cause was the incomplete compliance with an applicable Airworthiness Directive. A factor was the ditch.NTSB NYC04LA140Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Hamilton, OHThe pilot's failure to maintain directional control after experiencing a brake system malfunction during landing. Factors related to the accident were the malfunction of a landing gear brake as reported by the pilot, and the crosswind conditions.NTSB NYC04LA079Accident · Serious injuriesLimited investigationFinal reportGeoffrion Rotorway Exec 162 · Medina, OHA failure of the helicopter's tail rotor drive system for undetermined reasons.NTSB IAD03LA021Accident · No injuriesLimited investigationFinal reportCessna 210M · Cincinnati, OHRupture of the left side, landing gear down hydraulic line due to repeated contact with the aileron cable, which resulted in a loss of hydraulic pressure, a partial extension of the main landing gear, and the inability to utilize the landing gear hand pump.NTSB NYC03LA026Accident · No injuriesLimited investigationFinal reportCessna TR182 · Willoughby, OHThe pilot's failure to select the alternator to the "ON" position before initiating the flight. A factor in the accident was the tailwind which resulted in the overrun.NTSB IAD03TA003Accident · Minor injuriesFinal reportBeech A200 · Cleveland, OHInadequate operating clearance between the ring gear and pinion gear during the manufacturing process resulting in the failure of the landing gear actuator gear ring.NTSB IAD02LA087Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman E75L300 · Fostoria, OHA missing flight control sealed bearing, which resulted in a loss of control in flight.NTSB IAD02LA065Accident · Minor injuriesLimited investigationFinal reportWaco ASO · Mt. Vernon, OHFailure of the left main landing gear attach fitting due to fatigue.NTSB IAD02IA057Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · Cinncinnati, OHThe partial loss of flight displays for undetermined reasons.NTSB IAD01LA035Accident · No injuriesLimited investigationFinal reportCessna 210 · Newark, OHImproper maintenance, which resulted in the failure of the instrument panel shock mounts.NTSB IAD01LA031Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Napoleon, OHThe fatigue failure in the fillet radius of the mast, which resulted in the separation of the main rotor system.NTSB IAD00LA002Accident · Minor injuriesLimited investigationFinal reportLoral GZ-22 · Mogadore, OHThe failure of the flight control system manufacturer to meet design (hardness) specifications that resulted in stripped splines.NTSB NYC99LA113Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Grafton, OHInadequate maintenance which resulted in the failure of the mercury clutch assembly.NTSB NYC99IA062Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Columbus, OHa failure of the external o-rings in the nose landing gear steering module.NTSB NYC98LA076Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Blue Ash, OHThe failure of a cooling fan blade and the pilot's improper flare.NTSB NYC97LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Leroy, OHa lack of fluid in the brake reservoir, and the pilot's decision to operate the airplane with defective brakes, which led to an overrun during landing and a collision with trees.NTSB IAD97LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Defiance, OHThe failure of a wheel rim due to overstress separation with no clear evidence initiating event.NTSB NYC97LA085Accident · 1 fatalLimited investigationFinal reportMarsh-Turner BG-12A · Marion, OHDisconnection of the elevator control rod which resulted in the loss of elevator control. A factor was failure to complete the required maintenance inspection.NTSB IAD97IA018Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Dayton, OHFailure of the output drive unit shear pin due to lack of lubrication to the screw actuator assemblies. Contributing to the cause was the aircraft manufacturer's production and inspection personnel failing to lubricate the screw assemblies after initial…NTSB IAD96LA153Accident · No injuriesLimited investigationFinal reportCessna 188 · Pataskala, OHdeterioration and fuel leakage from an engine fuel hose (with a service life that had been exceed, due to inadequate maintenance), which resulted in an engine compartment fire and subsequent damage to the airplane.NTSB BFO95LA094Accident · Minor injuriesLimited investigationFinal reportCessna 310K · Columbiana, OHThe improper maintenance installation and the subsequent separation of the torque links on the left main landing gear during the landing roll.NTSB BFO95LA021Accident · Minor injuriesLimited investigationFinal reportElvin N. Kier Varieze · Cleveland, OHA fatigue crack in the right elevator torque tube resulting in the disconnection of the elevator torque tubes and subsequent loss of airplane control.NTSB BFO94LA099Accident · 2 fatalLimited investigationFinal reportUpton Mustang II · Churchtown, OHThe pilot's performance of a maneuver that exceeded the design stress limits of the airplane.NTSB BFO93IA176Incident · No injuriesIncident investigationFinal reportDouglas DC-8-63 · Toledo, OHThe operator maintenance personnel's failure to perform an adequate inspection of the airplane, which led to a worn aileron cable which separated in flight and caused a loss of control.NTSB BFO92LA154Accident · No injuriesLimited investigationFinal reportCessna 305A · Waynesville, OHThe chaffing of a landing gear brake line which caused the loss of hydraulic fluid and subsequent loss of braking action.NTSB NYC92LA163Accident · No injuriesLimited investigationFinal reportPiper J-3 · Portsmouth, OHThe failure of the propeller leading edge as the result of corrosion and the subsequent forced landing on unsuitable terrain.NTSB NYC92LA076Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-32 · Dayton, OHA failed wheel rim following an inadvertent over inflation by the mechanic. Additional causes were the failure of the mechanic to be aware of the pressure being used and his failure to follow procedures. A factor related to the accident was the failure of the…NTSB NYC92DEG01Accident · Minor injuriesFinal reportDevenport EAA Biplane · Wilksville, OHThe restricted visibility of the pilot due to oil on the windshield and his goggles, which resulted in a tree strike and uncontrolled touchdown, during the execution of a precautionary landing. Factors related to the accident were a clogged crankcase breather…NTSB NYC91LA232Accident · No injuriesLimited investigationFinal reportPiper PA46-350P · Dayton, OHA malfunction of the elevator trim indicator and incorrect position of the trim tab which resulted in the pilot aborting the takeoff and a loss of directional control on the ground.NTSB NYC91LA062Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Cleveland, OHFatigue failure of the number two propeller blade actuating pin, due to improper installation of the pins and non-compliance with an airworthiness directive (AD 77-13-77).NTSB NYC90LA191Accident · No injuriesLimited investigationFinal reportCessna 150 · Salem, OHThe airplane overran the end of the runway into a corn field after an aborted takeoff, due to the engine cowling door opening. Contributing to the accident was pilot's delay in aborting the takeoff.NTSB CHI89DEK02Accident · No injuriesFinal reportKeener Rotorway/Exec · Circleville, OHMaterial failure of an oil line allowing oil to escape and ignite as it touched hot exhaust manifold surfaces.NTSB CHI89MA132Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC8-63F · Vandalia, OHFailure of the left main landing gear, bogie trim cylinder, and malfunction of the emergency airbrake control valve.NTSB CHI89FA114Accident · 2 fatalField investigationFinal reportMcculloch J-2 · Oxford, OHThe failure of the pilot operator to replace the main rotor thrust bearing. The expired service life of the main rotor thrust bearing is a factor in the accident.NTSB ATL89LA101Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Steubenville, OHThe rudder control cable failed which rendered the control surface inoperative. The loss of rudder precluded the pilot from maintaining directional control after landing.NTSB ATL89MA070Accident · 2 fatalMajor investigationFinal reportSwearingen SX-300 · Wilmington, OHFatigue and resulting failure of the right wing's lower attachment fitting and inadequate quality control by the Swearingen SX-300 production/design personnel.NTSB CHI88FA226Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Toledo, OHFatigue fracture, for reasons undetermined, which lead to the loss of a propeller blade from the right engine. This in turn lead to the marginal controllability of the aircraft.NTSB CHI88FA205Accident · Minor injuriesField investigationFinal reportFairchild SA-226-TC · Cleveland, OHThe captain's late decision to abort after a propeller linkage failure on the right engine and the co-pilot's failure to relinquish engine and braking authority to the captain resulting in confusion and inadequate braking to stop on the runway after the abort.NTSB CHI88LA166Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-21-G · Elyria, OHNTSB ATL88IA037Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Cleveland, OHWhile descending into Cleveland from 25,000 feet the pilot, experienced a violent lurch in the airframe. The flight continued and landed without incident. An aircraft examination disclosed that the right upper thrust reverser drive link was broken. Further…NTSB ATL87DEI12Accident · No injuriesFinal reportTomishin W-8 · Painesville, OHThe plt/owner of the homebuilt aircraft was making a local flight to determine the flt characteristics with a larger wing installed on the acft. The plt reported that while in flight an oil leak developed from the area of the propeller. The oil coated the…NTSB ATL87LA247Accident · No injuriesLimited investigationFinal reportMooney M20F · Put In Bay, OHThe plt heard a loud 'snap' while taxiing to the rwy, and the ldg gear collapsed immediately thereafter. The plt observed that the gear handle was still in the down-and-locked position and that the green 'gear down' light remained illuminated. FAA exam of the…NTSB ATL87LA220Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Columbus, OHThe plt experienced a loss of directional control on ldg as the tailwheel touched down, and he executed a go-around. On the 2nd ldg attempt, the airplane veered off the rwy, traveled across a grassy area, and impacted a parked C-172. Post-crash exam of the…NTSB ATL87DEI06Accident · 2 fatalFinal reportSteen Skybolt · Wadsworth, OHThe accident occurred when the pilot was practicing aerobatics. The investigation disclosed that linkage control rods between the pilot's stick and the pitch elevator was broken. The evidence indicated that the failure was caused by a combination of…NTSB ATL87IA166Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Columbus, OHFlt attendant rpted smoke in cabin and pungent odor which dissipated. After descent for landing was begun smoke and odor returned. Pax informed flt crew of smoke intensity and precautionalry landing was made at divert field. Subsequent exam revealed that the…