NTSB investigations
484 cases where the sequence of events included Aircraft maintenance event.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '040' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '040' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA13LA327Accident · Minor injuriesLimited investigationFinal reportUnivair 108-1 · Tuftonboro, NHMaintenance personnel’s failure to remove circumferential gouges in the aft radius of the R2 rod journal on the crankshaft during its last engine overhaul, which resulted in the fatigue failure of the crankshaft and a subsequent total loss of engine power.NTSB ERA13IA326Incident · No injuriesIncident investigationFinal reportPiper PA-34 · Palm Coast, FLThe installation of an incorrect rudder trim tab control rod by unknown maintenance personnel, which resulted in the rod failing in flight due to overload and subsequent uncontrolled rudder oscillations.NTSB CEN13LA396Accident · No injuriesLimited investigationFinal reportBell 47D1 · Lake Ozark, MOThe improper rebuild and maintenance of the helicopter and inadequate subsequent inspections, which resulted in undetected fuel contamination and a subsequent total loss of engine power during cruise flight.NTSB ERA13LA285Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Oxford, NCThe failure to comply with an airworthiness directive by maintenance personnel and incorrect reinstallation of the fuel selector handle by unknown personnel, which resulted in fuel starvation.NTSB WPR13FA227Accident · No injuriesField investigationFinal reportGates Learjet 35A · McMinnville, ORFailure of maintenance personnel to reattach the landing gear squat switches following maintenance, which rendered the airplane's steering, braking, and thrust reverser systems inoperative during landing. Contributing to the accident were the failure of both…NTSB CEN13LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT-302 · Winnie, TXThe improper decision by the pilot to attempt a flight with a known fuel system-related maintenance discrepancy, which resulted in a fuel imbalance and subsequent fuel starvation during an approach to an alternate airport with a rough field. Contributing to…NTSB WPR13LA216Accident · Minor injuriesLimited investigationFinal reportRans S-17 · Fontana, CAA loss of engine power due to improper construction and inadequate maintenance of the fuel system and engine. Contributing to the accident was the airplane’s inadvertent contact with an unseen guy wire during the landing flare.NTSB ERA13LA221Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Hoosick Falls, NYThe failure of the left wing attachment bracket weld due to inadequate welding by unknown maintenance personnel.NTSB CEN13LA232Accident · No injuriesLimited investigationFinal reportCessna 172G · Reading, MIThe partial loss of engine power due to the improper securing of the throttle linkage by maintenance personnel.NTSB ERA13LA199Accident · Minor injuriesLimited investigationFinal reportMaxfly Inc/Mckay WM Searey · Polk City, FLThe improper installation of incorrect attachment hardware by maintenance personnel during an undocumented repair, which resulted in an in-flight structural failure and subsequent loss of aircraft control. Contributing to the accident was the covering of the…NTSB ERA13LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Winston Salem, NCFatigue failure of the right main landing gear attach bolts due to an unreported hard landing at an unknown time, and subsequent collapse of the landing gear.NTSB ERA13FA186Accident · 2 fatalField investigationFinal reportRobinson R44 · Miami, FLThe mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and the pilot's subsequent loss of control. Contributing to the accident was the…NTSB ERA13LA188Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe disconnection of the nose landing gear actuator, which resulted in the subsequent collapse of the nose landing gear. Contributing to the accident was the repair station’s inadequate maintenance, postmaintenance inspection process, and oversight of the…NTSB ERA13LA175Accident · No injuriesLimited investigationFinal reportMooney M20F · Leesburg, FLThe incorrect rigging of the landing gear emergency extension system by unknown maintenance personnel, which resulted in a failure of the emergency extension cable, and jamming of the normal extension gear motor.NTSB ERA13LA167Accident · Serious injuriesLimited investigationFinal reportAllen BD-5 · Mount Airy, NCA total loss of engine power due to the pilot's inadvertent closing of the engine choke. Contributing to the accident was the improper rigging of the engine choke cable.NTSB ERA13LA129Accident · No injuriesLimited investigationFinal reportBeech 58 · Winston-Salem, NCThe failure of the left main landing gear to fully extend due to improper rigging by maintenance personnel during a maintenance check.NTSB WPR13LA099Accident · No injuriesLimited investigationFinal reportGoetz Helicycle · Mesa, AZThe pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.NTSB ERA13LA116Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Ellington, CTThe separation of the collective push-pull tube and jackshaft assembly, which resulted in the total loss of helicopter control and collision with terrain. Contributing to the accident was the inadequate supervision of maintenance personnel by the operator…NTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB CEN13FA075Accident · 1 fatalField investigationFinal reportHughes 369 · Childress, TXThe improper maintenance of the helicopter fuel system that resulted in erroneous fuel gauge indications and the pilot’s inadequate fuel management, both of which resulted in fuel exhaustion during a long-line hover. Also causal was the lack of company…NTSB ERA13LA065Accident · No injuriesLimited investigationFinal reportBeech C90A · Roanoke, VAThe failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's…NTSB WPR13LA043Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Show Low, AZThe fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.NTSB CEN13IA059Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Minneapolis, MNLoose electrical connections to the hydraulic system and anomalies in the hydraulic shuttle valve and power pack, which resulted in an uncommanded gear unlock and collapse of the left main landing gear. Contributing to the accident was the operator’s failure…NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB ERA13LA048Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pahokee, FLA main landing gear wheel fire for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operations.NTSB ERA13IA036Incident · No injuriesIncident investigationFinal reportCessna 560XL · Nantucket, MAThe incorrect installation of the left main gear aft trunnion pivot pin by maintenance personnel, which resulted in separation of the aft portion of the left main gear trunnion from the aft trunnion fitting and minor damage to the airplane.NTSB WPR12CA401Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Lewiston, IDThe pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.NTSB ERA12LA524Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Riverview, FLDamage to the propeller governor gasket during installation by unknown persons, which resulted in a total loss of engine oil in flight and a subsequent forced landing.NTSB ERA12FA514Accident · 2 fatalField investigationFinal reportSocata TB 10 · Shirley, NYThe pilot/owner's operation of the airplane with known deficiencies, and the mechanic's failure to reattach the mixture control cable to the mixture control arm following maintenance of the carburetor.NTSB CEN12LA577Accident · No injuriesLimited investigationFinal reportJones Kitfox III · Rockford, ILThe pilot's improper installation of a spark plug, which led to a partial loss of engine power after takeoff and the resultant forced landing.NTSB CEN12LA558Accident · No injuriesLimited investigationFinal reportBeech A36 · Ruleton, KSThe improper installation of the wastegate controller O-ring, which resulted in a partial loss of engine power.NTSB CEN12LA530Accident · Serious injuriesLimited investigationFinal reportWilliams John T-51 Mustang · Oshkosh, WIThe separation of an engine cooling hose from the radiator.NTSB ERA12LA494Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLInadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.NTSB CEN12LA513Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor G-164A · La Salle, COThe loss of engine power due to the detached distributor rotor.NTSB ERA12LA469Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Statesboro, GAA total loss of engine power as a result of oil exhaustion due to the mechanic's failure to apply appropriate torque to the oil filter.NTSB ERA12LA441Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Auburn, ALThe airplane owner’s failure to have maintenance personnel comply with an aircraft manufacturer's service bulletin to require engine mount inspections for fatigue cracks, which resulted in an undetected fatigue crack, the engine mount failing, and the nose…NTSB CEN12FA425Accident · Minor injuriesField investigationFinal reportPiper PA-28RT-201 · Mesquite, TXThe failure of the right landing gear to fully extend, due to a combination of corrosion, inadequate lubrication, and a misadjusted gear-down limit switch. Contributing to the accident was the pilot's failure to perform the emergency landing gear extension…NTSB ERA12LA422Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Mc Kinnon, TNThe separation of the piston connecting rod from the crankshaft due to inadequate installation from a mechanic, resulting in a total loss of engine power.NTSB ERA12FA395Accident · 1 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Westminster, MDThe pilot's inadequate preflight inspection, which failed to ensure that the elevator quick-fastener was properly secured, resulting in an inflight elevator control disconnect and subsequent loss of control during the ensuing emergency landing. Contributing…NTSB WPR12CA257Accident · No injuriesData collectionFinal reportCessna 182A · Colfax, WAThe total loss of engine power during cruise flight due to the missing carburetor drain plug, which had not been secured with safety wire.NTSB CEN12LA348Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Bangor, MIThe pilot’s failure to properly service the fuel system, and subsequent decision to conduct the flight with known fuel system deficiencies, which led to the total loss of engine power.NTSB CEN12LA343Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Denver, COThe inadequately overhauled landing gear dampers that allowed initiation of a ground resonance event from which the pilot was unable to recover. Contributing to the accident was the overhaul facility's failure to identify the overcharged dampers and a lack of…NTSB ERA12LA373Accident · Minor injuriesLimited investigationFinal reportFaltin John R Rotorway Exec 162F · Smoketown, PAA loss of control during a post-maintenance test flight due to improper tracking of the helicopter’s main rotor blades by the pilot/aircraft builder.NTSB ERA12LA366Accident · No injuriesLimited investigationFinal reportBell 206B · Longboat Key, FLUnknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.NTSB WPR12IA248Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Seattle, WAFailure of maintenance personnel to ensure that the tail rotor pitch change link bolt was properly secured, which resulted in an in-flight separation of the bolt and subsequent vibration.NTSB DCA12FA076Accident · 1 fatalField investigationFinal reportHawker Hawker Hunter MK.58A · Point Mugu, CAthe pilot's decision to continue the flight with a known fuel imbalance condition that resulted in a loss of lateral control when the imbalance exceeded the known capabilities of the airplane. The fuel imbalance was due to incomplete refueling and an…NTSB CEN12LA299Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Shawnee, OKThe improper installation of the mixture cable by maintenance personnel, which allowed the mixture cable to entangle with the landing gear during gear extension and led to the subsequent loss of engine power.NTSB WPR12LA200Accident · No injuriesLimited investigationFinal reportChampion 7GC · Rexburg, IDA decrease in indicated oil pressure while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Also causal was the pilot’s failure to…NTSB CEN12LA253Accident · Serious injuriesLimited investigationFinal reportBumford-Royer Christen Eagle II · Pearland, TXA loose B nut on the fuel inlet line due to maintenance personnel’s application of insufficient torque on the nut at an unknown time, which resulted in a fuel leak and a subsequent total loss of engine power during initial climb.NTSB ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.