NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
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 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."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 MIA94LA105Accident · 1 fatalLimited investigationFinal reportWallace Thorp T-18 · Boynton Beach, FLThe pilot in command's exceeding the designed stress limits of the aircraft resulting in overload failure of the left wing outboard attach fitting. This resulted in inflight separation of the outboard left wing, and subsequent inflight collision with the…NTSB MIA94LA100Accident · Serious injuriesLimited investigationFinal reportBell 206L · Orlando, FLThe pilot's failure to cross-check a faulty engine speed indication with other engine performance indications to verify whether an engine malfunction had actually occurred, and his failure to maintain adequate rotor RPM during an emergency landing. The…NTSB ATL94LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Muscle Shoals, ALWas the loose throttle cable, and the pilot's failure to abort the takeoff when the engine did not produce full power. A factor was the inadequate maintenance inspection of the engine.NTSB CHI94IA111Incident · No injuriesIncident investigationFinal reportBeech BE200 · Rochester, INthe airplane painter/refinishers' failure to follow appropriate procedures/directives pertinent to the masking, stripping, painting and cleaning of the airplane cabin windows, which resulted in the in-flight failure of the right aft cabin window. A related…NTSB LAX94LA163Accident · No injuriesLimited investigationFinal reportRockwell 681 · Phoenix, AZthe failure of the hydraulic and nitrogen system pressure lines, due to an inadequate maintenance inspection program, which failed to detect the corrosion condition of the lines.NTSB LAX94LA162Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9-118 · Sedona, AZthe failure of the pilot lights and burners to relight in flight once extinguished due to the installation of an incorrect gas pressure regulator.NTSB LAX94FA159Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Los Angeles, CAthe failure of the upper engine compartment cowl to remain attached to the lower cowl during initial climb as a result of inadequate maintenance and replacement practices by the aircraft owner.NTSB SEA94LA080Accident · No injuriesLimited investigationFinal reportUnrein 80-P51D · Scapp00se, ORThe inadvertent unlocking of the tailwheel lock. Factors include the manufacturer's inadequate tailwheel lock.NTSB SEA94LA076Accident · Minor injuriesLimited investigationFinal reportTucker Kitfox IV · Vancouver, WAAileron flight controls that were jammed by the pilot's seat slipping from its mount. Factors include inadequate seat installation by the manufacturer.NTSB MIA94FA085Accident · 1 fatalField investigationFinal reportDaffron, Harold C. Varieze · Oxford, MSPoor planning/decision by the pilot-in-command for failure to perform high and low speed taxi tests before the flight after repairs and modification of the airplane. Additionally, failure or malfunction of the flight control system for undetermined reasons,…NTSB MIA94LA083Accident · Minor injuriesLimited investigationFinal reportHarper, Jack M. Mustang II · Lake City, FLThe failure of the bolts which secure the right main landing gear wheel assembly to the strut assembly.NTSB FTW94FA091Accident · 4 fatalField investigationFinal reportCessna 310K · Wichita Falls, TXWas the loss of control due to the pilot's spatial disorientation following a complete electrical system failure. Factors were the dark night and the electrical failure as result of burned out wiring terminal.NTSB ATL94IA055Incident · No injuriesIncident investigationFinal reportCessna 421B · Lagrange, GAThe pilot's intentional swerve off the taxiway to avoid a ground collision. A factor in the incident was an undetermined malfunction of the airplane's normal brake system.NTSB FTW94LA087Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Almyra, ARThe partial failure of the brake master cylinder assembly for undetermined reasons. A factor was the soft terrain adjacent to the runway.NTSB LAX94LA132Accident · Minor injuriesLimited investigationFinal reportBell TH-1L · Etna, CAThe faituge of the gear tooth which caused the failure of the 42-degree gear box.NTSB ATL94LA050Accident · Serious injuriesLimited investigationFinal reportArgo Minimax · Franklin, TNThe pilot's failure to secure cargo in the cockpit.NTSB LAX94LA135Accident · No injuriesLimited investigationFinal reportCessna 340A · Dunsmuir, CAThe mechanics improper maintenance of the airplane's left brake system by failing to service its hydraulic reservoir. The lack of hydraulic fluid in the left brake reservoir which precipitated the left brake failure is a factor in this accident.NTSB MIA94GA099Incident · No injuriesFinal reportCessna 172N · Opa-Locka, FLInadequate maintenance inspection and lubrication of the flap rollers which resulted in the left flap inboard roller becoming jammed in the track during flap retraction.NTSB FTW94IA077Incident · No injuriesIncident investigationFinal reportFokker F28 MK O100 · Amarillo, TXThe failure of the outer bearing due to a lack of lubrication.NTSB CHI94MA072Accident · 2 fatalMajor investigationFinal reportCessna 421C · Mccook, NEImproper in-flight planning/decision by the pilot, and the accumulation of airframe ice, which resulted in an inadvertent stall. Factors associated with the accident were: partial failure of both alternators, which resulted in a subsequent electrical system…NTSB LAX94LA104Accident · No injuriesLimited investigationFinal reportBeech 58 · Modesto, CAThe pilot's failure to perform the emergency landing gear extension and other maintenance personnel's inadequate 100-hour inspection. The partial electrical failure and the pilot apprehension/anxiety due to a possible electrical fire were factors in this…NTSB MIA94FA057Accident · 3 fatalField investigationFinal reportCessna 421C · Titusville, FLFailure of the pilot-in-command to maintain VMC resulting in the inflight loss of control. Contributing to the accident was the fatigue failure of a section of pipe adjacent to a flange which connects to the turbocharger oil outlet of the left engine assembly.NTSB FTW94IA070Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Little Rock, ARWas the landing gear separation due to an undetermined cause.NTSB MIA94LA054Accident · No injuriesLimited investigationFinal reportRobinson R22B · Gurabo, PRComplete separation of one of the two vee-belts, and complete separation of 1/2 of the remaining belt. Contributing to the accident was the dark night condition and unsuitable terrain encountered during the autorotative landing.NTSB CHI94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Highland, INAn electrical system failure due to a fractured alternator mounting lug. Factors related to the accident were the rough terrain, and decreasing visibility due to snow and darkness.NTSB MIA94MA048Accident · 10 fatalMajor investigationFinal reportBeech B90 · Okeechobee, FLThe pilot's improper remedial action concerning a right engine power anomaly, and his failure to maintain adequate airspeed during go-around from an aborted precautionary landing, which resulted in a loss of aircraft control and an uncontrolled descent.…NTSB MIA94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vicksburg, MSThe pilot did not maintain the proper glidepath. Failure of the electrical system and inadequate maintenance by company maintenance personnel were factors in the accident.NTSB FTW94LA055Accident · No injuriesLimited investigationFinal reportEbershoff Steen Skybolt · Erie, COWas flutter of the flight controls.NTSB CHI94LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lacon, ILThe pilot misjudged the landing flare. Factors related to the accident were: the dark night, the pilot's lack of recent night experience, and the failure of the airplane's electrical system.NTSB LAX94LA075Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flagstaff, AZThe pilot's improper initiation of an emergency autorotation into unsuitable terrain and subsequent hard landing and rollover. A false annunciator indication, a failure of the N1 tach generator, the pilot's continued flight with a known aircraft defect, and…NTSB ATL94FA029Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Covington, GASpatial disorientation experienced by the pilot, resulting in his failure to maintain aircraft control. Factors were the total failure of the engine driven vacuum pump, and the night, cloud conditions prevailing at the time of the accident.NTSB ATL94FA028Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Lagrange, GAWas the pilot's failure to correct a known low battery condition before departing, which resulted in a loss of electrical power during an instrument approach. Factors were the dark night and the low scattered cloud layer.NTSB NYC94IA035Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 · Newark, NJThe separation of the right outboard translating cowl on the #2 engine thrust reverser as a result of inadequate bonding material.NTSB FTW94FA044Accident · 1 fatalField investigationFinal reportUpton Mustang M-II · Guthrie, OKWas the in flight failure of the left aileron for reasons undetermined.NTSB NYC94LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Haven, METhe pilot's use of excessive speed and altitude during the approach which resulted in a landing overrun of the runway. Factors were a precautionary landing and a ravine.NTSB LAX94LA054Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAa fatigue failure of the torsion-tension bar pin due to fretting corrosion. A factor in this accident was an inadequate quality of material utilized in the manufacture of the pin.NTSB BFO94FA008Accident · 2 fatalField investigationFinal reportMooney MO-20J · Seekonk, MAThe pilot's inadequate in flight planning/decision to continue flight into known adverse weather conditions after the engine's dry air vacuum pump failed and the pilot's failure to maintain airplane control during approach. A factor in the accident was the…NTSB LAX94LA043Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAThe pilot's improper handling of the helicopter which resulted in overloading of the rotor system in a maneuvering turn during aerial application of chemical, and subsequent failure of the main rotor paddle assembly.NTSB SEA94LA030Accident · Minor injuriesLimited investigationFinal reportHawkins & Powers UH-1B · North Bend, WATotal failure of the intermediate gearbox. The lack of suitable terrain for an autorotation was a factor.NTSB SEA94LA029Accident · No injuriesLimited investigationFinal reportBell 47G3B2 · Toledo, WATransmission shear bolts failed causing a loss of power to the rotor system, and the pilot encountered unsuitable terrain during his autorotation attempt.NTSB LAX94LA030Accident · No injuriesLimited investigationFinal reportBeech 200 · Reno, NVThe improper overhaul of the right main landing gear actuator by maintenance personnel, and the operator's failure to assure that the airplane manufacturer's mandatory service bulletin requiring modification of the gear motor circuit protection was…NTSB LAX94LA024Accident · No injuriesLimited investigationFinal reportCessna 150K · California City, CAFailure of maintenance personnel to assure that the nose wheel axle was properly secured during previous maintenance.NTSB LAX94LA017Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315 · Beckwourth, CAwas the worn collective servo causing a hydraulic lock and not allowing the pilot to lower the collective. This condition caused the main rotor blades rpm to decay.NTSB FTW94LA013Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's failure to follow proper emergency procedures to troubleshoot the electrical system. A factor was an electrical system irregularity of an undetermined nature.NTSB CHI94IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Thief Rvr Falls, MNFatigue failure of the propeller blade, originating from a corrosion pit.NTSB CHI94LA013Accident · No injuriesLimited investigationFinal reportHughes 269A · Coldwater, MIthe fatigue failure of the tailboom support strut attachment lug.NTSB MIA94LA003Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · San Juan, PRPartial failure of a wing rib due to exfoliation corrosion and inadequate inspection of the aircraft by company maintenance personnel.NTSB FTW94LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · San Angelo, TXWas malfunction of the throttle control push/pull rod and cable. A factor was unsuitable terrain for the forced landing.NTSB MIA94FA001Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-83 · Miami, FLThe failure of the water heater relay and the overpressure relief valve to operate properly. In addition, the design of the relief valve was inadequate in that it allowed the o-ring to migrate from its normal position preventing the valve from opening.NTSB CHI94FA001Accident · 1 fatalField investigationFinal reportBeech G35 · Webster, WIIn-flight breakup of the airplane for an undetermined reason.