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 MIA99FA267Accident · Serious injuriesField investigationFinal reportLearjet 24 · Gainesville, GAThe inadequate inspection of the main landing gear brake assemblies, which lead to operation of the aircraft with worn brakes that failed during the landing roll. Contributing factors were the descending terrain, roadway and ditch.NTSB LAX99FA317Accident · 2 fatalField investigationFinal reportKaman HH-43F · Phoenix, AZFailure of the horizontal stabilizer left outboard forward attach point because of a previously existing crack that resulted from inadequate maintenance inspection by the operator. A factor was the use of automotive parts.NTSB FTW99FA265Accident · 2 fatalField investigationFinal reportCarter Spacewalker II · Conroe, TXThe in-flight separation of the left wing due to the failure of the wing spars resulting from the builder's improper design change utilizing basswood for the spars instead of the specified spruce.NTSB MIA99LA270Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLthe pilot's failure to ensure that the landing gear was down and locked following loss of electrical power for undetermined reasons, resulting in substantial damage to the airplane when the right main landing gear collapsed upon landing.NTSB ANC99LA152Accident · Minor injuriesLimited investigationFinal reportMaule ML-4 · Anchorage, AKThe improper (reversed) connection of the elevator control cables by the owner/pilot-mechanic, and the failure to have the installation inspected by another mechanic.NTSB SEA99LA171Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Usk, WAFatigue failure of the 90-degree gearbox attachment studs, resulting in separation of the tailrotor and 90-degree gearbox from the vertical fin.NTSB IAD99LA068Accident · No injuriesLimited investigationFinal reportCessna 172P · Friendly, MDThe pilot's misjudgment of speed during the landing approach. The inoperative airspeed indicator was a contributing factor.NTSB LAX99FA315Accident · Serious injuriesField investigationFinal reportBoeing 757-2S7 · Agua Caliente, AZthe systemic failure of the airline's maintenance department to identify and correct the long standing history of intermittent faults, nuisance warnings, and erratic behavior in this airplane's GPWS system. Also causal is the airline's failure to perform the…NTSB LAX99FA311Accident · 1 fatalField investigationFinal reportNo American/Rogers B L P-51R · Reno, NVThe onset of a flutter event and the resultant separation of the rudder and empennage from the aircraft. The precipitating cause for the flutter could not be determined.NTSB ANC99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Delta Junction, AKCorrosion and a fatigue failure of the lower end of the landing gear strut. Factors in the accident were the manufacturer's and the FAA's insufficient standards/requirements for life limits and inspection procedures.NTSB FTW99LA267Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Van Horn, TXA restriction within the auxiliary fuel supply system and the rough terrain during the subsequent precautionary landing resulting on main gear collapse.NTSB MIA99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Naples, FLThe pilot's failure to perform manual gear extension procedures with a suspected unsafe landing gear indication which resulted in a collapse of the main landing gear on landing rollout. A factor in the accident was the pilot's lack of total experience in kind…NTSB ATL99LA124Accident · No injuriesLimited investigationFinal reportCessna 190 · Enterprise, ALThe fatigue failure of the main landing gear spring.NTSB MIA99LA242Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fort Lauderdale, FLan in-flight failure of the right aileron due to fatigue cracking in the attachment structure of the right inboard aerodynamic compensator, which resulted in a loss of control, a forced landing, and subsequent impact with the ground.NTSB LAX99LA283Accident · No injuriesLimited investigationFinal reportBell UH-1B · Lost Hills, CAFailure and separation of the 90-degree gearbox as a result of the disengagement of the pinion and gear teeth. The cause(s) of the pinion and gear disengagement were undetermined.NTSB IAD99IA059Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCThe inadequate lubrication of the landing gear side strut assembly by company maintenance personnel. A factor in the accident was the inadequate design of the assembly that trapped water and prevented adequate lubrication.NTSB MIA99LA233Accident · No injuriesLimited investigationFinal reportCessna 172RG · Miami, FLThe delay by the pilot-in-command to extend the gear resulting in collapse of the main landing gear after touchdown. Factors in the accident were the inoperative gear warning system associated with the throttle due to the broken wire at the throttle…NTSB LAX99FA272Accident · No injuriesField investigationFinal reportBeech BH 125-600A · Las Vegas, NVthe complete failure of all hydraulic systems due to the effects of a main gear tire disintegration on takeoff. Also causal was the manufacturer's inadequate design of the wheel wells, which did not comply with applicable certification regulations, and the…NTSB LAX99LA271Accident · No injuriesLimited investigationFinal reportCessna TU 206G · Clear Lake, CAThe fracture and separation of the front left pontoon attach point due to corrosion. The inability of the area to be inspected was a factor in the accident.NTSB SEA99LA143Accident · No injuriesLimited investigationFinal reportCessna 210B · Port Angeles, WAThe failure of maintenance personnel to detect cracked main landing gear saddles during required inspection, and subsequent fatigue fracture of the left main landing gear saddle resulting in separation of the saddle and disabling of the left main gear.NTSB FTW99LA228Accident · No injuriesLimited investigationFinal reportAviat S1-11B · Katy, TXThe pilot's inability to maintain directional control of the tailwheel equipped biplane following the failure of the left brake master cylinder.NTSB NYC99LA200Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Hillsborough, NHan inadequate auxiliary fuel tank installation which resulted in a leak of undetermined origin.NTSB DEN99LA144Accident · No injuriesLimited investigationFinal reportColeman Lancair IV P · Aspen, COA failure of the right landing gear's brake system. Factors were the improper touchdown point attained by the pilot, the existing weather conditions that included a tailwind and high density altitude, and the rocky ditch.NTSB DEN99IA154Incident · No injuriesIncident investigationFinal reportBalloon Works Firefly 9 · Hartsel, COTotal failure of the deflation line due to heat damage (as evidenced by glazing), most likely caused by the improper use of the flight controls (burner system) by person(s) unknown.NTSB MIA99LA220Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-10F · Memphis, TNThe inadequate design by the airplane manufacturer for using bolts to secure the inboard trailing edge flap that are susceptible to stress corrosion cracking. Also, the stress corrosion cracking failure of the four H-11 bolts that secure the left inboard…NTSB MIA99LA210Accident · No injuriesLimited investigationFinal reportWilderoder Great Lakes 2TIA · Pensacola, FLThe pilot's failure to check the brake hydraulic fluid reservoir prior to flight resulting in a low fluid level going undetected and failure of the brakes during landing rollout, which resulted in the aircraft overrunning the runway, colliding with a fence,…NTSB MIA99TA206Accident · No injuriesFinal reportHughes OH-6A · Aguadilla, PRAn unidentified foreign object passing through the oil cooler blower assembly resulting in fracture and seizure of the oil cooler blower, and slowing of the main transmission and main rotor, which resulted in the pilot being unable to arrest the descent…NTSB FTW99LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Victoria, TXThe separation of the engine cowling due to a fractured support bracket, which resulted in the cowling striking and bending four engine push rods causing a loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA129Accident · No injuriesLimited investigationFinal reportBoeing A-75-N1 (Stearman) · Tooele, UTThe failure of the right main landing gear tire's inner tube, and the subsequent inadvertent ground loop by the pilot.NTSB CHI99LA261Accident · Serious injuriesLimited investigationFinal reportHodre-Buull-Kolb Mark III · Plymouth, MNThe failure of the airplane's rudder control pulley due to corrosion and inadequate maintenance inspection of the airplane by the owner/pilot mechanic of the airplane.NTSB ATL99LA115Accident · No injuriesLimited investigationFinal reportBeech 55 · Nashville, TNThe total failure of the nose gear extension and retraction assembly that resulted in the collapse of the nose gear during landing.NTSB CHI99LA243Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marshall, MNthe inadvertent stall and the checklist not followed by the pilot. Contributing factors were the baggage door not secured and the precautionary landing attempt by the pilot.NTSB DEN00LA033Accident · No injuriesLimited investigationFinal reportCessna T210M · Cedar City, UTThe pilot's failure to follow alternate landing gear extension procedures. Factors were the main landing gear failure to extend and a loss of electrical power.NTSB NYC99IA175Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Belmar, NJThe failure of the turbocharger clamp, resulting from improper welding settings during manufacture.NTSB ATL99LA107Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Camden, ALThe failure of the cyclic control rod due to an overstress separation resulting from a material defect (inadequate quality of material) by the manufacturer.NTSB CHI99LA241Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aitkin, MNthe right spring in the tailwheel assembly's separation. Factors were the fatigue in the landing gear, the maintenance personnel not identifying the fatigue during the annual inspection, and the right main gear's separation.NTSB SEA99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Snohomish, WABrake system failure due to the presence of air bubbles in the hydraulic fluid.NTSB MIA99LA195Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Lake City, FLthe improper maintenance and inspection of the propeller system, which resulted in loose and improperly torqued bolts, causing the subsequent failure of a propeller blade.NTSB MIA99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Jasper, ALthe pilot inadvertently became disoriented and misjudged his position on the runway/airport, which resulted in him turning the airplane too soon, and subsequently impacting with a tree. Factors in this accident were a loss of electrical power for undetermined…NTSB NYC99LA151Accident · No injuriesLimited investigationFinal reportLearjet 60 · Hyannis, MAThe flightcrew's inadequate coordination and their failure to utilize checklists. Also causal was the captain's improper decision to continue the approach to a runway with insufficient length. A factor in the accident was the improper maintenance.NTSB SEA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Billings, MTThe separation of the left main landing gear shock strut for undetermined reasons.NTSB MIA99LA191Accident · No injuriesLimited investigationFinal reportMooney M20F · Liberty, NCImproper inspection of the muffler assembly resulting in erosion going undetected and the rupture of the muffler and shroud while in cruise flight. The condition caused melting of portions of the air induction system, loss of engine power, and the pilot's…NTSB LAX99LA221Accident · Serious injuriesLimited investigationFinal reportCessna 172M · San Diego, CAThe mechanic's improper installation of nonapproved automotive electrical system parts, and his failure to ensure that all electrical connections were secure during the reinstallation, which resulted in the failure of the electrical system. The pilot's…NTSB FTW99LA170Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Basile, LAThe separation of the right wing forward spar lower attachment fitting due to a fatigue fracture, which emanated from corrosion as a result of maintenance not being performed.NTSB MIA99LA183Accident · Serious injuriesLimited investigationFinal reportSouth Mississippi Light Aircra Buccaneer II · Panacea, FLThe intentional continued operation of the airplane by the pilot-in-command with known deficiencies with the pitot system after takeoff, resulting in erroneous airspeed indications, and inadvertent stall by the pilot resulting in the uncontrolled descent into…NTSB LAX99LA215Accident · 1 fatalLimited investigationFinal reportAB Sportine Aviacija Genesis 2 · Minden, NVThe flight control stabilator becoming disconnected during the initial ground tow. Factors in the accident were the inadequate preflight by the pilot and communications with the pilot not possible.NTSB NYC99LA139Accident · No injuriesLimited investigationFinal reportAero Commander 500S · Windsor Locks, CTHydraulic system contamination which prevented normal landing gear extension. A factor was the misjudged landing flare by the flying pilot.NTSB MIA99LA181Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Sevierville, TNThe induced fatigue fracture of a component in the engine-to-transmission rotor drive system resulting in a disconnection of the drive system during cruise flight caused by inadequate inspection processes by the manufacturer and the subsequent autorotative…NTSB CHI99FA177Accident · 2 fatalField investigationFinal reportCessna 340A · Phillipsburg, KSthe pilot not maintaining flying speed. Factors to the accident were the fuel transfer problem of unknown origin.NTSB LAX99LA253Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The removal of the tail rotor blade abrasion strips by the use of an unapproved method by the maintenance personnel which resulted in the imbalance of the tail rotor blade assembly and subsequent separation of the 90-degree gear box; the pilot/mechanic's…