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 NYC06IA229Incident · No injuriesIncident investigationFinal reportAmerican Blimp A-60+ · Manchester, MAA malfunction of the rudder control system, and the pilot's inadequate preflight inspection. Contributing to the incident was the inadequate design of the chain keeper guards.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 CHI06CA270Accident · No injuriesData collectionFinal reportDevereux Mustang II · Auburn, INThe failure of the left main landing gear attachment weld which resulted in the pilot's inablility to maintain directional control of the airplane during the landing roll.NTSB LAX06LA298Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Auburn, CAthe fatigue failure of the elevator's control rod due to inadequate lubrication. Contributing factors were the inadequate maintenance and the owner-pilot's failure to comply with an airworthiness directive.NTSB NYC06LA224Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · East Bridgewate, MAThe completion center's installation of the incorrect (shorter) release cable, and the ground crewmember's improper movement under the flight path during a bin transfer.NTSB CHI06CA267Accident · No injuriesData collectionFinal reportColumbia 350 · Bloomington, INThe pilot did not comply with the pilot operating handbook warning when he intentionally opened the cabin door during flight.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 CHI06LA260Accident · No injuriesLimited investigationFinal reportEndless Skies L164 · Durand, MIThe kit builder's improper installation of the aileron bracket leading to the aileron flutter during cruise that resulted in the wing spars' failure.NTSB LAX06LA290Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Van Nuys, CAInadequate maintenance adjustment and missing mixture spring, which resulted in a loss of engine power during approach.NTSB SEA06LA175Accident · Serious injuriesLimited investigationFinal reportStraw T-Bird II · Leamington, UTThe pilot's loss of aircraft control (control not possible) due to the failure of the left elevator control surface which was the result of a missing inboard bolt (for undetermined reason) which holds the left elevator bow in place.NTSB NYC06CA218Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Farmingdale, NCAn inadequate annual inspection of the airplane, which resulted in a total failure of the elevator cable during flight, and subsequent uncontrolled descent into terrain.NTSB ATL06CA125Accident · No injuriesData collectionFinal reportBrown Floyd L Christen Eagle II · Topsail Beach, NCThe in-flight separation of the engine and propeller from the airframe for undetermined reasons, which resulted in the airplane's uncontrolled impact with water.NTSB ANC06LA143Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fairbanks, AKThe fracture of the aluminum alloy landing gear adapter assembly, which resulted in a loss of control during the landing roll.NTSB DEN06LA116Accident · 1 fatalLimited investigationFinal reportBaker RV-3AB · Laramie, WYThe in-flight failure of the right wing spar during aerobatic flight. Contributing to the accident was the owner/operator's failure to comply with the service bulletin issued by the kit manufacturer.NTSB LAX06IA301Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-83 · Long Beach, CAThe over wing heater blanket wiring installation that had chaffed and arced, which produced an electrical smell in the cabin area.NTSB SEA06LA166Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Auburn, WAThe failure of the landing gear's normal retraction/extension assembly due to an overload condition.NTSB LAX06LA270Accident · No injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G109 · Glendale, AZThe failure and separation of one propeller blade for undetermined reasons.NTSB SEA06CA157Accident · No injuriesData collectionFinal reportPiggott Bearhawk · Port Angeles, WAThe loss of directional control as a result of the disconnected tail wheel steering system, which led to an inadvertent ground loop during the landing roll.NTSB LAX06GA254Accident · 2 fatalFinal reportAviation International Rotors CH-54A · Happy Camp, CAThe fatigue failure of tail rotor blade spindle, which resulted in the separation of the blade and tail rotor gearbox.NTSB LAX06CA276Accident · No injuriesData collectionFinal reportInterstate S-1A · Buckeye, AZthe in-flight separation of the control stick. A contributing factor was the rough terrain for the forced landing, which resulted in a collapsed landing gear.NTSB CHI06CA221Accident · No injuriesData collectionFinal reportAir Tractor AT-400 · Springfield, MNThe pilot's inability to maintain directional control of the airplane as a result of the partial failure of the tail wheel assembly. A factor associated with the accident was the crop that the airplane contacted.NTSB NYC06FA184Accident · Minor injuriesField investigationFinal reportBoeing 737-300 · Pittsburgh, PAThe airplane tug driver's inadvertent movement of the tug gear shift lever from forward to reverse, which resulted in the nose landing gear collapse. Contributing to the accident was the defective gear shift lever.NTSB SEA06CA149Accident · No injuriesData collectionFinal reportMaule M-7-235C · Auburn, WAThe loss of directional control [not possible] during landing roll as a result of the disconnected tail wheel steering assembly [for undetermined reasons], which led to an inadvertent ground loop during the landing roll.NTSB SEA06FA146Accident · 2 fatalField investigationFinal reportSpectrum Aeronautical 33 · Spanish Fork, UTIncorrect installation by company maintenance personnel of the aft upper torque tube bell crank resulting in roll control that was opposite to that commanded in the cockpit. Contributing factors were the lack of maintenance documentation detailing the…NTSB LAX06LA242Accident · No injuriesLimited investigationFinal reportCessna 182P · Hemet, CAthe shaking and backfiring of the engine for undetermined reasons.NTSB CHI06LA207Accident · Serious injuriesLimited investigationFinal reportSchlei Avid Flyer Speed Win · Fergus Falls, MNthe fractured aileron bell crank and elevator clevis rod end.NTSB LAX06LA236Accident · Serious injuriesLimited investigationFinal reportHammack Air Command Elite · Hilo, HIan in-flight separation of a control rod joint assembly, which resulted in the pilot's loss of control. The underlying reason for the separation could not be determined.NTSB NYC06IA176Incident · No injuriesIncident investigationFinal reportEurocopter AS-350 BA · Philadelphia, PAA loss of hydraulic boost for undetermined reasons.NTSB MIA06LA123Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pompano Beach, FLThe pilot's improper landing flare during a precautionary landing. A factor in the accident was the unusual noise as a result of an improper repaired air conditioner compressor system.NTSB ATL06IA108Incident · No injuriesIncident investigationFinal reportDassault Mystere Falcon 900 · Greenville, SCThe malfunction of the anti-skid system SPAD controller during the landing roll, which resulted in failure of the anti-skid braking system, and a runway overrun.NTSB NYC06LA175Accident · Minor injuriesLimited investigationFinal reportEnstrom 280C · Danville, WVA partial failure of the override clutch assembly. A contributing factor to the accident was the manufacturer's inadequate inspection procedures of the override clutch assembly following a tail rotor strike.NTSB CHI06LA190Accident · 1 fatalLimited investigationFinal reportArmpriest Breezy · South Haven, MIThe inadvertent stall by pilot during climb following propeller blade damage from the compartment door separation after takeoff. The low altitude and airspeed not maintained by the pilot were additional causes. Contributing factors were the compartment door…NTSB LAX06LA228Accident · No injuriesLimited investigationFinal reportPalmer Seawind 3000 · Havasu Lake, CAan electrical fire due to improper wiring of the electrical system by other maintenance personnel.NTSB DFW06CA178Accident · No injuriesData collectionFinal reportCessna 180 · Downsville, TXThe malfunction in the braking system which caused the parking brake to engage and lock the right main wheel resulting in a loss of directional control.NTSB DFW06CA175Accident · No injuriesData collectionFinal reportCessna C340A · San Antonio, TXThe collapse of the left main landing gear as result of the failure of the gear pivot bolt for undetermined reasons.NTSB SEA06LA133Accident · No injuriesLimited investigationFinal reportNanchang China CJ-6 · Brewster, WAThe failure of the engine's three planetary gears for undetermined reasons. A factor contributing to the accident was the tree orchard.NTSB SEA06LA135Accident · No injuriesLimited investigationFinal reportHughes 369D · Moab, UTThe failure of the collective bungee support bracket due to non-compliance with a service information notice, which resulted in the pilot executing a precautionary autorotative landing. A contributing factor was the lack of suitable terrain for the landing.NTSB CHI06GA174Accident · Minor injuriesFinal reportBell UH-1H · Chicago, ILThe in-flight separation of a tail rotor driveshaft hanger bearing due to inadequate maintenance performed by maintenance personnel. Contributing to the accident was the inability to maintain directional control due to the lack of tail rotor thrust.NTSB LAX06CA217Accident · No injuriesData collectionFinal reportBeech 76 · El Cajon, CAthe failure of the "A" frame tube, which caused the left main landing gear to collapse.NTSB MIA06FA120Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Fort Pierce, FLthe pilot’s loss of aircraft control during the initial climb which was precipitated by the sudden loss of thrust and increase in drag from the right engine, and the pilot’s failure to adhere to the published emergency procedures regarding the position of the…NTSB ATL06CA097Accident · No injuriesData collectionFinal reportCessna R182 · Lebanon, TNImproper maintenance by other maintenance personnel resulting in the puncture of the landing gear hydraulic down line and the failure of the main landing gear to extended on landing.NTSB CHI06FA158Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-83 · Chicago, ILThe jammed nose landing gear due to a failure of the nose landing gear spray deflector for undetermined reasons.NTSB MIA06FA117Accident · 1 fatalField investigationFinal reportBeech 65-A90-1 · Tampa, FLThe poor in-flight planning decision by the captain for his failure to establish the airplane on a stabilized approach for a forced landing, resulting in the airplane landing on a taxiway near the departure end of the runway. Contributing to the accident were…NTSB DFW06CA157Accident · Serious injuriesData collectionFinal reportCaproni Vizzola Cos. Aero. Calif A-21 · San Antonio, TXThe pilot/owner's failure to properly secure the right wing, which resulted in the in-flight separation of the right wing.NTSB DEN06IA083Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Denver, COa brake fire for reasons undetermined. A contributing factor was the inadequate inspection by the maintenance crew.NTSB MIA06LA126Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Navarre, FLThe inadequate manufacturing of the plates of the tail rotor tension-torsion bar assembly resulting in fatigue failure.NTSB LAX06LA190Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Antioch, CAThe loss of oil pressure due to metal pieces from the number 5 piston skirt in the oil system, which prevented the oil valve top ball valve from seating. The muddy terrain was a factor.NTSB ANC06LA070Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Birchwood, AKThe pilot's improper servicing/adjustment of the main landing gear brakes, which resulted in a locked brake and a loss of control while taxiing.NTSB DFW06CA158Accident · No injuriesData collectionFinal reportAyres S2R-600 · Childress, TXThe pilot's inability to maintain directional control while landing due to the failure of the rudder horn due to corrosion.NTSB NYC06FA128Accident · Serious injuriesField investigationFinal reportEmbraer EMB-170 · Dulles, VAImproper servicing of the nose landing gear strut and the operator's inadequate maintenance procedure. A factor was the inadequate checklist provided to the flight crew by the operator.