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 BFO90LA065Accident · No injuriesLimited investigationFinal reportRobinson R22 · Paducah, KYThe loss of tail rotor thrust due to improper part installation.NTSB MIA90IA159Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-100 · Panama City, FLFailure of seal in the hydraulic actuator for the right outboard wing spoiler panel for unknown reasons.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 ATL90FA146Accident · Minor injuriesField investigationFinal reportBoeing 737-222 · Kinston, NCFailure of the fuel pump control shaft because of improper machining by the repair facility during maintenance modification of the pump and improper procedures during overhaul of the nose landing gear.NTSB LAX90DVG13Accident · Serious injuriesFinal reportCharles T. Brietigam RV-4 · San Andreas, CAThe failure of four propeller retention bolts which required the engine to be shut down. A factor in the accident was the pilot's misjudgement of the forced landing approach.NTSB BFO90FA064Accident · Serious injuriesField investigationFinal reportPiper PA-28-200 · Baltimore, MDThe pilot failed to maintain adequate airspeed which resulted in a stall. Contributing was the loss of power for undetermined reasons.NTSB MIA90LA153Accident · No injuriesLimited investigationFinal reportLockheed L-188A · Caribbean SeaThe inflight loss of the nos 3 and 4 propellers and gearboxes for undetermined reasons. The failed components were not recovered from the Caribbean Sea.NTSB MKC90LA145Accident · Minor injuriesLimited investigationFinal reportMonnett Sonerai II · Cherokee, IAAircraft control not maintained by the pilot in command.NTSB MKC90LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Fair Oaks, ARTail rotor cable disengagement due to inadequate maintenance.NTSB SEA90FA129Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Prineville, ORThe failure of the left intermediate exhaust pipe, in-flight engine fire and smoke in the cockpit, resulting in impairment of the pilot and his subsequent loss of control.NTSB MIA90LA149Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Crowder, MSFatigue failure of a bolt which secures the mixture and throttle bellcranks to the bellcrank support assembly.NTSB NYC90LA155Accident · No injuriesLimited investigationFinal reportCessna 305A · Newburyport, MAFailure of the pilot in command to follow procedures for landing with a banner still attached, contributing to the accident was the improper modification of banner release mechanism.NTSB DEN90LA152Accident · No injuriesLimited investigationFinal reportStinson 108 · Clovis, NMImproper installation of the right main wheel assembly.NTSB MIA90IA148Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B · Tyndall Afb, FLA propeller blade fatigue failure due to improper overhaul by other maintenance personnel not performing overhaul in accordance with factory service bulletins.NTSB CHI90DEM05Accident · 1 fatalFinal reportOo-Culley Osprey · Iron Mountain, MIJamming of the rudder cable between the pulley and the pulley support bracket and the pilot's continued operation of the airplane with a known deficiency.NTSB MIA90IA144Incident · No injuriesIncident investigationFinal reportCessna 210L · Fort Lauderdale, FLIncorrect placement of the retaining ring in the left main landing gear door actuator by the mechanic resulting in the loss of hydraulic fluid. This prevented the gear from extending resulting in the gear up landing.NTSB ATL90IA136Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAInadequate maintenance inspection of the airplane which resulted in operation of the tire while under inflated and its subsequent failure. A factor in the incident was the inadequate quality control by the tire recapping facility which failed to repair a…NTSB ATL90FA135Accident · Serious injuriesField investigationFinal reportBoeing 727-281 · Charleston, SCImproper utilization of the emergency equipment.NTSB NYC90LA134Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Pittstown, NJGround resonance due to inadequate servicing and maintenance of the landing gear dampers.NTSB NYC90DNE03Accident · 2 fatalFinal reportAerodyne Vector 727 Senior · Berlin, MAIn-flight failure of the wings for undetermined reason(s).NTSB NYC90FHD01Accident · 1 fatalFinal reportMason Hummel Bird · Lumberton, NJFailure of the rudder attach bolt, which resulted in a loss of aircraft control and an uncontrolled descent to the ground.NTSB FTW90DPA05Accident · 1 fatalFinal reportGyroflug SC01B160 · Mineral Wells, TXTotal propeller blade retention failure, the resultant separation of one propeller blade, and the improper installation of the propeller by unknown maintenance personnel.NTSB ATL90IA126Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAInadequate maintenance inspection by operator personnel which resulted in operation of the tire while under-inflated.NTSB NYC90LA125Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Brookville, PAWorn tail rotor pitch control assembly, due to improper maintenance/installation, and subsequent fatigue failure of the tail rotor swashplate.NTSB ATL90IA124Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAFailure of the ac cross tie relay, which prevented the generators from being reconnected to the electrical system. A factor in the incident was the loss of the left generator in flight. Factors include inadvertently disconnecting the left generator while…NTSB MKC90LA116Accident · 1 fatalLimited investigationFinal reportRollins-Bowers FLY Baby 1A · Bemidji, MNThe wing attachment bolts were not installed resulting in inflight wing separation.NTSB NYC90LA116Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Athens, NYInflight loss of control due to loss of airspeed and subsequent stall when the pilot's seat back failed and the pilot hung onto the control wheel, resulting in an excessive nose high attitude.NTSB MIA90FA135Accident · Minor injuriesField investigationFinal reportCessna T303 · Deland, FLThe chafed and shorted electrical wiring between bus bars, which caused a partial electrical failure, resulted in a false fire warning indication, and prevented the restart of the right engine.NTSB ATL90DKJ04Accident · No injuriesFinal report67 Flying Dutchman D1/LFD-13 · Tuscaloosa, ALMaintenance personnel who performed an improper modification of the propeller blade.NTSB NYC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lyons, NYA worn out brake on the left main gear. Factors related to the accident were: the owner's decision not to repair the left brake after the right brake had a similar failure 4 hours earlier.NTSB MIA90LA134Accident · Minor injuriesLimited investigationFinal reportAyres S2R-600 · Vero Beach, FLThe operation of the airplane with an unairworthy propeller by the operator.NTSB LAX90FA202Accident · No injuriesField investigationFinal reportRobinson R22B · Payson, AZControl interference which the CFI encountered during landing flare. Contributing factors related to the student not understanding communications from the CFI, the unclear language and the operator's inadequate certification of the airman.NTSB LAX90DUG06Accident · No injuriesFinal reportSabelino KR-2 · Chino, CAFailure of the brake system for undetermined reasons resulting in the pilot losing directional control during landing and veering off the runway.NTSB SEA90IA085Incident · Minor injuriesIncident investigationFinal reportFairchild SA227 · Olympia, WADue to an ice build-up departing the propeller and striking the cabin window.NTSB LAX90LA187Accident · No injuriesLimited investigationFinal reportHughes 269C · Rialto, CAImproper maintenance procedure by maintenance personnel to troubleshoot a reported deficiency and the pilot's decision to demonstrate the vibration, exceeding the design limits of the helicopter and inducing ground resonance. Contributing to the accident was…NTSB SEA90LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Bremerton, WAFailure of the tail rotor control for an undetermined reason.NTSB SEA90LA083Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58D · Juneau, AKThe failure of the number 3 segment of the tail rotor drive shaft assembly.NTSB MKC90FA107Accident · No injuriesField investigationFinal reportBeech A35 · Washington, MOImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.NTSB MIA90LA120Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Marathon, FLFailure of the input drive gear of the tail rotor gear box for undetermined reasons because the drive gear was not recovered from the ocean.NTSB MKC90LA102Accident · No injuriesLimited investigationFinal reportLightcap PITTS-S-1D · Larned, KSFailure of the main landing gear attachment strut, due to fatigue.NTSB DEN90FA104Accident · 2 fatalField investigationFinal reportCanadair CT-133 · Roswell, NMThe pilot-in-command's performance of aerobatic maneuvers that exceeded the design stress limits of the aircraft, resulting in catastrophic failure of the wing.NTSB NYC90LA095Accident · No injuriesLimited investigationFinal reportBeech Baron 58 · Danbury, CTPilot factor in that the pilot elected to abort the takeoff with insufficient r/w remaining to stop the aircraft on the runway and collided with a fence, car & van.NTSB CHI90FA117Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · West Bend, WIInflight failure of the right wing strut-to-spar attachment fitting due to fatigue initiated by improper welding techniques involving inadequate post-weld cooling control.NTSB DEN90LA098Accident · No injuriesLimited investigationFinal reportCessna 310B · Elizabeth, COThe pilot's attempt to takeoff with a known deficiency and the partial failure of the propeller feathering system.NTSB ATL90FA100Accident · 1 fatalField investigationFinal reportBell 205A-1 · Moncks Corner, SCThe in-flight separation of the main rotor because of the failure of a pillow block bolt, and the failure of the operator/repair station to follow the overhaul procedures.NTSB MKC90LA088Accident · Serious injuriesLimited investigationFinal reportBell 47 · Oakdale, MNA slipping rotor drive clutch assembly due to improper maintenance by company personnel. Contributing factors were static wires in the path.NTSB ANC90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Deadhorse, AKInadequate maintenance and inspection of the nose baggage door.NTSB FTW90DPJ05Accident · Minor injuriesFinal reportBell 47G-4A · Bixby, OKLoss of control due to undetermined mechanical failure.NTSB MKC90LA083Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Harrisburg, ARFailure of the generator, and failure of the pilot to maintain rotor RPM.NTSB MIA90LA103Accident · No injuriesLimited investigationFinal reportSwing Velocity RG · Wimauma, FLDelamination of a portion of one of the wooden propeller blades at a knot, resulting in severe vibration and necessitating a forced landing.