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 LAX06IA011Incident · No injuriesIncident investigationFinal reportHughes 369D · Kahului, HIThe fatigue cracking and failure of the tail rotor control rod during cruise flight, which resulted in a hard landing during the precautionary landing.NTSB LAX06CA008Accident · No injuriesData collectionFinal reportBellanca 17-30A · Riverside, CAThe failure of the steering control rod during an unknown phase of the accident flight that resulted in the unavailability of steering control upon landing.NTSB SEA06LA004Accident · No injuriesLimited investigationFinal reportBeech G35 · Longview, WARuddervator flutter which resulted in the buckling of the empennage. The reason for the ruddervator flutter was undetermined.NTSB NYC06CA053Accident · No injuriesData collectionFinal reportBeech E-55 · Providence, RIThe pilot's failure to verify landing gear extension after a landing gear malfunction, which resulted in a wheels up landing.NTSB MIA06LA002Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Destin, FLThe inadequate design of the engine mount which led to cracking of the mount resulting in a loss of directional control and collapse of the nose landing gear. A contributing factor was the failure of maintenance personnel to comply with a service bulletin to…NTSB DEN05LA150Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COthe failure of the left rudder cable resulting in a loss of directional control by the pilot. Contributing to the accident was the improper repair procedures on the seat frame.NTSB CHI05FA272Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · West Memphis, ARThe pilot's improper in-flight decision not to land at the departure runway or other available airports during the emergency descent, and his failure to maintain clearance from a vehicle and terrain. Contributing factors were a false engine fire warning…NTSB LAX05IA312Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320 · Los Angeles, CAThe fatigue failure of two anti-rotation lugs due to repeated cyclic pre-landing tests, which allowed the nosewheels to deviate from the 0-degree position on landing gear retraction. A contributing factor was the design of the Brake Steering Control Unit…NTSB SEA05CA195Accident · Minor injuriesData collectionFinal reportEiland RAF-200 Gyro · Bend, ORThe malfunction of the flight controls for an undetermined reason, which resulted in a loss of control and in-flight collision with terrain.NTSB DFW05FA242Accident · 1 fatalField investigationFinal reportAkro Tech Aviation Inc. Giles G-300 · Yukon, OKThe catastrophic separation of the canopy as result of the failure of the forward canopy hinge while performing aerobatics and the subsequent incapacitation of the pilot.NTSB DEN05LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Rock Springs, WYthe pilot's failure to maintain control of the helicopter during the attempted autorotation after he experienced an engine overspeed that occurred for reasons undetermined.NTSB SEA05CA191Accident · No injuriesData collectionFinal reportGleason Sky Star Kitfox · Klamath Falls, ORThe binding of the flaperon push pull tube due to deformation of the front seat, which resulted in a loss of control on takeoff initial climb and collision with the runway.NTSB LAX05CA294Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Peoria, AZthe pilot's encounter with obstacles and unsuitable terrain in the landing area during the pilot's attempted precautionary landing. A factor in the accident was the loose wing root gap seal fairing.NTSB ANC05LA143Accident · No injuriesLimited investigationFinal reportCessna 180C · Igiugig, AKThe failure of the airplane's starter to disengage, which resulted in an overheated starter, smoke in the cockpit, and an emergency landing. A factor associated with the accident was soft terrain encountered during the emergency landing.NTSB LAX05LA288Accident · Minor injuriesLimited investigationFinal reportGoodlett Safari · Trona, CAthe in-flight fatigue failure of a control system connecting rod, which resulted in a loss of helicopter control.NTSB CHI05CA267Accident · No injuriesData collectionFinal reportWest Revolution Mini 500 · Ida, MIThe pilot's abrupt (improper) control action which resulted in the main rotor contacting the tail boom. Contributing factors were the false indication provided by the engine tachometer, the pilot's decision to immediately initiate an autorotation instead of…NTSB SEA05LA188Accident · 1 fatalLimited investigationFinal reportKirner Fisher FP404 · Prineville, ORThe design stress limits of the aircraft were exceeded resulting in a wing separation while the pilot was accomplishing maneuvers of hard banking turns, spins and steep descents.NTSB ANC05LA136Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKThe failure of the nose gear steering mechanism during the landing roll, which resulted in a loss of control and subsequent encounter with the runway.NTSB CHI05LA243Accident · 1 fatalLimited investigationFinal reportAllensworth Baby Belle · El Dara, ILThe manufacturer failed to specify a relief radius on the tail rotor spindle drawings, which resulted in the spindle being manufactured with an inadequate relief radius at the point of fatigue failure.NTSB SEA05CA183Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Chiloquin, ORThe failure of the left chain link which permits the pilot to control the tailwheel, and the subsequent inability of the pilot to control the airplane during the landing roll.NTSB LAX05CA280Accident · No injuriesData collectionFinal reportPiper PA-28-236 · San Martin, CAthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the spongy brakes.NTSB SEA05LA179Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Richland, WAThe oil pressure gauge line fitting coming loose from the engine, resulting in the loss of oil to the point where internal engine components were starved for oil, leading to extensive internal damage and seizing of the engine. Factors include a set of eight…NTSB ANC05LA128Accident · No injuriesLimited investigationFinal reportGardner SR3500 · Anchorage, AKThe malfunction of the propeller reversing system during landing, which allowed the propeller to reverse pitch in-flight, resulting in an uncontrolled descent and impact with terrain.NTSB DFW05CA219Accident · No injuriesData collectionFinal reportCessna 172R · Springtown, TXThe pilot's improper decision to shut down the engine. Contributing factors were the failure of the oil pressure switch and the lack of a suitable landing area.NTSB CHI05CA240Accident · No injuriesData collectionFinal reportPiper PA-12 · Boscobel, WIThe separation of the right main landing gear attachment bracket bolt during the landing and the pilot's aircraft control not possible with the collapsed gear.NTSB LAX05LA270Accident · Serious injuriesLimited investigationFinal reportPrescott Aeronautical Pusher · Redding, CAthe in-flight separation of the propeller for undetermined reasons.NTSB SEA05LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Challis, IDThe installation of an improper oil gasket by maintenance personnel, which resulted in a loss of engine oil and subsequent loss of engine power during the emergency descent.NTSB LAX05LA266Accident · No injuriesLimited investigationFinal reportAgusta SF 260D · Redding, CAthe company maintenance personnel's failure to follow a prescribed canopy installation procedures.NTSB CHI05LA225Accident · No injuriesLimited investigationFinal reportCessna 210 · Rapid City, SDThe landing gear extension not possible and inoperative flap system due to fatigue failure of a hydraulic system tube during approach. An additional cause was the improper rebuild/remanufacture of the hydraulic tube. Contributing factors were the dependency…NTSB DEN05LA123Accident · No injuriesLimited investigationFinal reportForbes Rutan Long EZE · Albuquerque, NMa total electrical failure due to a short in the master relay, causing the main fuse to open. Contributing factors included an inadequate electrical design by the airplane's builder, a low-output alternator, a cement wall, and unsuitable terrain on which to…NTSB DEN05TA119Accident · Serious injuriesFinal reportHughes 369HS · Albuquerque, NMthe bullet(s), which severed the helicopter's left tail rotor pedal. Contributing factors were the severed anti-torque pedal and the unsuitable terrain for landing.NTSB SEA05LA163Accident · No injuriesLimited investigationFinal reportSteele Safari · Leavenworth, WAThe failure of the tail rotor drive shaft during cruise flight. Factors include soft, grassy terrain at the location where the pilot executed the autorotational landing.NTSB MIA05LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Orlando, FLThe manufacturer's defective wheel brake assembly design and a leaking wheel brake, resulting in an overheated brake assembly and a wheel fire during an aborted takeoff.NTSB NYC05IA128Incident · No injuriesIncident investigationFinal reportBeech 1900D · Rockland, MEA loose elevator attachment, which resulted in a partial elevator binding during takeoff and uncommanded elevator movement during cruise.NTSB LAX05LA253Accident · Serious injuriesLimited investigationFinal reportMalechek Q-200 · Delano, CAthe in-flight delamination and separation of a propeller blade for undetermined reasons.NTSB DFW05CA194Accident · No injuriesData collectionFinal reportCessna 175A · Graham, OKThe impending loss of engine power as result of the failure of the generator mounting gasket resulting in engine oil starvation. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB LAX05LA237Accident · No injuriesLimited investigationFinal reportCessna A188B · Bishop, CAthe failure of the tailwheel mount during the landing roll, which resulted in a ground loop.NTSB DFW05CA181Accident · No injuriesData collectionFinal reportMesserschmitt BK-117 B-2 · Houston, TXThe separation of the left passenger door due to worn attaching hardware.NTSB CHI05FA192Accident · No injuriesField investigationFinal reportAerospatiale AS365N · Valparaiso, INThe loose tail rotor drive shaft coupling due to its improper installation by the operator's maintenance personnel, which resulted in the failure of the tail rotor drive shaft. An additional cause was the inability of the pilot to maintain control of the…NTSB ANC05LA097Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKA fracture failure of the main landing gear leg during the landing roll, which resulted in the collapse of the main landing gear.NTSB MIA05IA132Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Titusville, FLThe pilot's continued operation of the airplane with known intermittent deficiencies of the electric pitch trim switch, resulting in a mis-trim condition of the airplane (nose-up), and subsequent hard landing on the nose landing gear causing it to collapse. A…NTSB LAX05LA221Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Honolulu, HIthe flight crew's failure to ensure that the landing gear lever was in the full down position prior to utilizing the hand pump, and the certified flight instructor's failure to utilize the blow down emergency landing gear system. The instructor's inadequate…NTSB DEN05CA105Accident · No injuriesData collectionFinal reportNavion Navion G · Parowan, UTThe jammed left main landing gear and the wheels up landing. Factors contributing to the accident were the misaligned left landing light and that landing gear extension was not possible.NTSB SEA05FA124Accident · Serious injuriesField investigationFinal reportCessna 320E · Missoula, MTTerrain clearance was not possible as a result of a right engine failure. Factors contributing to the accident included the rising terrain, foreign material being ingested into the engine's turbocharger, which obstructed the turbocharger's impeller, the…NTSB DFW05LA167Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Carizzo Springs, TXThe failure of the stabilator trim control rod due to internal corrosion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05LA154Accident · No injuriesLimited investigationFinal reportCessna A188B · Washburn, NDThe separation of the tailwheel assembly, the pilot's directional control of the airplane not possible during the takeoff, and the unsuitable terrain the pilot encountered.NTSB CHI05LA143Accident · No injuriesLimited investigationFinal reportThomas Zenith CH701 · Redford, MIThe total loss of engine thrust was the result of the propeller blades overstress separation from the propeller hub for an undetermined reason. An additional cause was the unsuitable terrain encountered during the forced landing.NTSB ANC05LA087Accident · No injuriesLimited investigationFinal reportCessna U206F · Homer, AKThe fracture of the airplane's nose gear scissor during landing, which resulted in a loss of control during the landing roll, and a nose down. A factor associated with the accident was the loss of nosewheel steering control.NTSB LAX05FA202Accident · No injuriesField investigationFinal reportBombardier Aerospace CL-600-2B19 · Los Angeles, CAfailure of the nose landing gear to extend to the down and locked position for undetermined reasons.NTSB NYC05LA096Accident · 1 fatalLimited investigationFinal reportHall Maxair Drifter · Gloucester, VAThe in-flight separation of the empennage, which resulted in a loss of control and subsequent impact with the ground.