NTSB investigations, MO
87 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 11 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 3 |
| 2007 | 2 |
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\" = 'MO' 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" = 'MO' 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 CHI07CA229Accident · Serious injuriesData collectionFinal reportNetz KIS TR2 · Willow Springs, MOThe improper installation of the aileron control pushrod which led to a separation of the pushrod and subsequent loss of aircraft control. A factor was the pilot not being able to control the airplane after the pushrod separation.NTSB CHI07LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Ava, MOThe failure of the aileron cable eye splice during cruise flight. Contributing to the accident were improper installation and service of the crimped cable sleeve, which rendered the airplane uncontrollable.NTSB CHI06LA268Accident · 1 fatalLimited investigationFinal reportWindler Tri Q2 · Branson, MOFatigue failure, originating in an area of surface corrosion, of the right elevator mid span hinge pin and the subsequent failure of the elevator torque tube. Additional causes are the separation of the elevator from the airframe due to the hinge pin and…NTSB CHI06LA262Accident · No injuriesLimited investigationFinal reportCessna 310P · Kennett, MOSeparation of the left main landing gear torque link during landing resulting in a loss of control and runway excursion. Contributing factors were a failure to comply with the airframe manufacturer's service bulletin, and the pilot's inability to maintain…NTSB CHI06CA125Accident · No injuriesData collectionFinal reportBangham Barracuda · Monett, MORupture of the hydraulic hose and deformation of the hydraulic cylinder piston rods for undetermined reasons, which resulted in a failure of the landing gear extension system. Contributing factors were the pilot's premature shutdown of the engine on short…NTSB CHI05CA025Accident · No injuriesData collectionFinal reportJabat Avid Flyer · Cleveland, MOThe separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.NTSB CHI04LA009Accident · No injuriesLimited investigationFinal reportBeech A33 · Grandview, MOSeparation of the fuel selector handle which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was the hay bale that the airplane contacted during the forced landing.NTSB CHI03IA257Incident · No injuriesIncident investigationFinal reportCessna 650 · Chesterfield, MOA partial failure of the rudder control lock fairlead which jammed the rudder cable during takeoff.NTSB CHI03IA033Incident · No injuriesIncident investigationFinal reportHughes OH-6 · Moberly, MOThe loss of tail rotor effectiveness during cruise flight due to the bellcrank pivot pin becoming separated from the non-rotational swashplate. The plain brass liner of the non-rotating swashplate and the bellcrank pivot pin were worn.NTSB CHI02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Vandalia, MOThe student pilot's inadequate directional control on the previous landing resulting in the overload failure of the nose landing gear fork. Factors were the overload of the nose landing gear fork, and the student pilot's lack of total experience.NTSB CHI02LA028Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Nevada, MOThe inadequate fuel consumtion calculations by the pilot resulting in fuel starvation during the aborted landing, and the overloaded steering link for undetermined reasons resulting in the lack of directional control during landing. Factors were the…NTSB CHI01FA128Accident · 2 fatalField investigationFinal reportCessna 210L · Farmington, MOThe fracture of the crankshaft due to fatigue, the propeller separating from the airplane while in-flight, which resulted in the propeller striking the empennage structure and flight controls, yielding the airplane uncontrollable. Contributing factors to the…NTSB CHI01MA011Accident · 3 fatalClass 1 · MajorFinal reportCessna 335 · Hillsboro, MOThe pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.NTSB CHI00LA238Accident · No injuriesLimited investigationFinal reportBeech BE-A35 · Poplar Bluff, MOthe pilot exceeded the VNE speed restriction of 144 MPH. Factors included the ruddervator flutter and the out of balance ruddervators.NTSB CHI99FA079Accident · 1 fatalField investigationFinal reportCessna U-206G · Salem, MOthe spatial disorientation and loss of control by the pilot after a reported vacuum failure. Factors were instrument flight conditions and icing conditions.NTSB CHI98LA326Accident · No injuriesLimited investigationFinal reportCessna 150B · Lamar, MOinadequate lubrication of the torque plate holes and torque pins by the mechanic who performed the airplane's last annual inspection.NTSB CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.NTSB CHI98IA169Incident · No injuriesIncident investigationFinal reportDouglas DC-9-34 · St. Louis, MOthe yaw rate gyro of the Stab Aug Computer had been installed in a reverse position that was 180 degrees opposite from the correct position.NTSB CHI98LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · St Charles, MOfailure of the alternator's front bearing, depletion of battery power, and failure of the emergency landing gear extension handcrank to engage during the pilot's attempt to perform the emergency procedure.NTSB CHI97LA201Accident · Serious injuriesLimited investigationFinal reportWeber RV-4 · Hermann, MOthe pilot's inadequate in-flight planning/decision and encounter with a stall. Related factors were the chafed throttle cable, which became jammed; and failure of the pilot to perform an engine shut down in order to land on the runway.NTSB CHI97LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Benton, MOthe pilot's inadequate preflight by failing to insure that the secondary flight control lock was stowed properly, and subsequently the secondary flight control lock becoming engaged during the takeoff run. A factor relating to the accident was: inadequate…NTSB CHI97IA134Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Saint Louis, MOfailure of company maintenance personnel to properly install a mounting eyebolt (and associated cotter pin, washer, spacer and castellated nut) on the lower forward bracket of the left main landing gear strut door.NTSB CHI96FA353Accident · 4 fatalField investigationFinal reportCessna 195 · Greenville, MOthe pilot's decision to fly into known adverse weather which resulted in an overload failure and separation of the left wing.NTSB CHI96LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · New Melle, MOthe pilot's selection of an unsuitable area for an emergency/precautionary landing. Factors relating to the accident were: the pilot's continual operation of the airplane with a known deficiency (broken trim switch); an uncommanded activation of the elevator…NTSB CHI96LA235Accident · No injuriesLimited investigationFinal reportBeech B35 · Chesterfield, MOimproperly balanced ruddervators and improperly installed ruddervator (elevator) trim tabs, due to improper maintenance, which resulted in ruddervator flutter and substantial damage in the area of the aft fuselage. Factors relating to the accident were:…NTSB CHI96LA010Accident · No injuriesLimited investigationFinal reportCrowley/Zenair Zodiac CH-600 · Columbia, MOA loss of elevator control as a result of the top elevator control cable working its way out of a fitting.NTSB CHI95LA093Accident · No injuriesLimited investigationFinal reportBell 206L · Maryland Hts, MOFatigue failure of two attachment bolts that connected the driveshaft to the geared portion of a driveshaft coupling. Factors relating to the accident were: inadequate maintenance, uneven terrain in the touchdown area for the forced landing, and the…NTSB CHI95IA052Incident · No injuriesIncident investigationFinal reportCessna 402 · Saint Louis, MOimproper maintenance installation (fuel line fitting)by other maintenance personnel. A factor was the cross threaded fuel line fitting.NTSB FTW95IA049Incident · No injuriesIncident investigationFinal reportBoeing B-737-200 · Springfield, MOThe failure of either the inboard or the outboard wheel bearing assembly due to undetermined reasons.NTSB CHI95IA030Incident · Minor injuriesIncident investigationFinal reportCessna 150 · Chesterfield, MOthe cracked heater exhaust muffler which resulted from an improper repair. Factors were the physical impairment of the solo flight student as a result of her inadequate training concerning carbon monoxide hazards.NTSB CHI94LA319Accident · Serious injuriesLimited investigationFinal reportSnider CP328 Super Emeraude · Painton, MOin flight delamination and subsequent failure of the hand carved wooden propeller.NTSB CHI94LA288Accident · No injuriesLimited investigationFinal reportBede BD-10 · Chesterfield, MOthe canopy lock pin design which allowed the pilot to receive a 'closed and locked' indication without the canopy lock pin being engaged. Factors were the pilots' intentional abort above rotation speed, the lack of developed takeoff and accelerate-stop…NTSB CHI93IA354Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · St. Louis, MOa failure of the left outboard foreflap due to the loss of the bolts that hold the inboard sequencing carriage to the foreflap attach lug.NTSB CHI93IA352Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · St. Louis, MOa fatigue failure of the power transfer unit caused by a material defect which resulted in a total hydraulic system failure.NTSB CHI93IA152Incident · No injuriesIncident investigationFinal reportBoeing 767-233 · Kansas City, MOA frozen aileron control bearing after it had become worn, corroded and exposed to water, and the manufacturer's inadequate maintenance/inspection requirment of the bearing(s).NTSB CHI93FA050Accident · 1 fatalField investigationFinal reportCessna 177B · Kansas City, MOThe pilot-in-command's failure to maintain a positive rate of climb during a missed approach. Factors which contributed to the accident were: inoperative gyro instruments due to a broken vacuum pump, the dark night, adverse weather conditions, and rising…NTSB CHI93GA046Accident · 2 fatalFinal reportSchweizer 269C · Kansas City, MOThe pilot-in-command's misjudging the distance during the autorotation.NTSB CHI92LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Bates City, MOTotal failure of the airplane windshield.NTSB CHI92DCG02Accident · No injuriesFinal reportA. H. Gettings Glassair SH2 · Marshall, MOThe pilot's inadequate pre-takeoff flight control check.NTSB CHI92DCA01Accident · No injuriesFinal reportGrumman G-164 · Malden, MOThe pilot could not maintain directional control after one of the main landing gear brakes jammed during a landing roll. The operator did not comply with an airworthiness directive issued to prevent a possible braking system malfunction.NTSB CHI91MA260Accident · No injuriesMajor investigationFinal reportBritish Aerospace 3201 · St Louis, MOFailure of the pilot(s) to follow the correct emergency procedure. Factors related to this accident were: inadequate system design by the manufacturer, which allowed hydraulic line vibration, fatigue failure of the line, and loss of fluid from the normal…NTSB CHI91LA257Accident · No injuriesLimited investigationFinal reportBell 47G · Lake Ozark, MOFailure of the rotorcraft's tail boom in flight. Factors related to the accident were reduced aircraft control available to the pilot.NTSB CHI91FA140Accident · 1 fatalField investigationFinal reportCessna P210 · Kansas City, MOThe pilot in command's intentional flight with known mechanical deficiencies in the aircraft which resulted in a fire & forced landing in unsuitable terrain. A factor contributing to the accident was improper maintenance to the turbocharger waste gate by…NTSB CHI90DCG01Accident · Serious injuriesFinal reportGeorge R. Losey J6-KARATOO · Grain Valley, MOThe propeller blade separation during initial climb, and the failure of the pilot in command to maintain flying speed during the emergency descent.NTSB MKC90FA107Accident · No injuriesField investigationFinal reportBeech A35 · Washington, MOImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.NTSB MKC90LA039Accident · No injuriesLimited investigationFinal reportBeech 80 · Cape Girardeau, MOAn inoperative landing gear extension system due to failure of an electric motor and a misplaced emergency crank handle.NTSB MKC89FA104Accident · 1 fatalField investigationFinal reportCallair A-9 · Hamilton, MOThe pilots failure to maintain control and prevent the airplane from descending while in a turn.NTSB MKC89LA025Accident · No injuriesLimited investigationFinal reportCessna 310 · St. Louis, MOArriving over his destination airport, the pilot said he had an unsafe right main gear light indication. After circling about two hours to lighten the fuel load, and attempting to lower the gear by emergency procedures, a landing was attempted. After…NTSB MKC89IA012Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Springfield, MOThe a.c. generator mounted on the left engine failed and resulted in an in-flight fire. The captain elected to shut down the left engine and divert the flight to the Springfield, Missouri regional airport. A single engine precautionary landing was completed…NTSB MKC88LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. Louis, MOThe plt said that during a night takeoff roll, he noticed an inoperative airspeed indicator, and elected to abort the takeoff. Unable to stop in the remaining distance, the acft ran off the end of the runway onto the grass overrun collapsing the nose wheel.…