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 ATL03LA151Accident · Serious injuriesLimited investigationFinal reportSheppard S-2 · Obion, TNThe failure of the elevator control pushrod, that resulted in an uncontrolled descent and subsequent in-flight collision with ground.NTSB ATL03LA150Accident · Minor injuriesLimited investigationFinal reportSherman Holie Freebird · Newnan, GAThe failure of the aileron control rod, and subsequent loss of control in-flight.NTSB DCA03IA058Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Dfw, TXThe improper maintenance of the tailcone evacuation system, which prevented the evacuation slide from inflating during an evacuation due to smoke/fumes in the cabin.NTSB DEN03LA156Accident · No injuriesLimited investigationFinal reportCessna R182 · Cedar City, UTthe nose wheel separating from the airplane during the precautionary landing. Factors contributing to the accident were the missing nose gear axle through-bolt and the missing cotter pin.NTSB CHI03LA314Accident · No injuriesLimited investigationFinal reportCessna 182S · Joliet, ILThe pilot not performing a go-around when the other airplane taxied onto the landing runway, which resulted in the pilot not attaining the proper touchdown point. Factors to the accident include the failure of the alternator, the complete loss of electrical…NTSB LAX03LA291Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Lone Pine, CAthe pilot's inadequate assembly of the glider and improper preflight inspection, which resulted in an inadvertent deployment of the spoilers. Also causal was the pilot's failure to maintain obstacle clearance. His diverted attention to the control problems…NTSB SEA03LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Anacortes, WAThe pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.NTSB ANC03LA128Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKA failure of an attaching bolt that allowed the nose wheel fork to separate from the nose gear strut, which resulted in the collapse of the nose gear during the landing roll. A factor contributing to the accident was rough/uneven terrain.NTSB SEA03LA187Accident · No injuriesLimited investigationFinal reportCessna 172RG · Blanchard, IDThe loss of engine oil as a result of the inadequate installation of the idler gear shaft set screw and the lack of a safety wire on the hex head (oil) plug. A contributing factor was the rough and uneven terrain.NTSB CHI03LA318Accident · Minor injuriesLimited investigationFinal reportDixon Glasair II · Columbia, ILThe pilot's failure to maintain directional control during an aborted takeoff. Contributing factors were the open cabin door, the grass runway and the soft terrain adjacent to the runway.NTSB CHI03IA300Incident · No injuriesIncident investigationFinal reportCessna 650 · Rapid City, SDThe in-flight failure of the right wing aileron cable during cruise.NTSB LAX03LA267Accident · 1 fatalLimited investigationFinal reportPetz Flying Boat · Tracy, CAThe inadequate design of the engine exhaust system and inappropriate selection of propeller materials by the designer/builder, which resulted in separation of the propeller blades during takeoff/initial climb, and a subsequent in-flight collision with terrain…NTSB SEA03LA180Accident · No injuriesLimited investigationFinal reportLancair LC41 · Bend, ORThe inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…NTSB MIA03IA168Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Miami, FLThe failure of maintenance personnel from the aircraft operator to identify a missing left main landing gear truck beam shield and damage to the left main landing gear truck beam which resulted in the fracture of the truck beam as a result of stress corrosion…NTSB CHI03LA265Accident · No injuriesLimited investigationFinal reportCessna 188B · Monette, ARFailure of the right brake and the pilot's inability to maintain directional control. A factor associated with the accident was the ditch.NTSB ATL03LA132Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Camilla, GAThe malfunction (locking) of the left brake piston during the landing roll, which resulted in a loss of control and subsequent nose over.NTSB CHI03FA277Accident · Serious injuriesField investigationFinal reportBell TH-13T · Light, ARThe total failure and seizure of the main rotor transmission while in cruise flight leading to the helicopter’s impact with terrain.NTSB CHI03IA293Incident · No injuriesIncident investigationFinal reportBell 230 · Wilmington, ILThe material defect during the manufacture of the tail rotor counterweight bellcrank and the bellcrank's subsequent failure due to a fatigue fracture.NTSB LAX03IA259Incident · No injuriesIncident investigationFinal reportAirbus A340-300 · Honolulu, HIthe failure of the center landing gear tires as a result of low tire pressure.NTSB DEN03LA144Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COSeparation of the landing gear tire valve stem resulting in the left main tire deflating, and the pilot's inability to maintain aircraft control.NTSB FTW03LA196Accident · No injuriesLimited investigationFinal reportHolmes Challenger II · Eldorado, TXThe loss of engine power during the takeoff/initial climb following the separation of the front cockpit throttle control cable resulting from inadequate maintenance.NTSB ATL03IA126Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Raleigh Durham, NCThe failure of a utility bus relay which resulted in an electrical fire and subsequent smoke in the cockpit.NTSB CHI03IA257Incident · No injuriesIncident investigationFinal reportCessna 650 · Chesterfield, MOA partial failure of the rudder control lock fairlead which jammed the rudder cable during takeoff.NTSB DEN03FA138Accident · 1 fatalField investigationFinal reportWright Hughes 1-B · Yellowstone Nat, WYThe in-flight loss of a propeller counterweight, followed by the pilot's loss of aircraft control during a forced landing attempt and subsequent inadvertent stall/spin to the ground.NTSB LAX03IA252Incident · No injuriesIncident investigationFinal reportBell 222 · Salinas, CAThe fatigue failure (fracture) of the right forward transmission lift link during cruise flight, which resulted in a severe vibration and an emergency landing.NTSB CHI03LA235Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Brighton, MIThe pilot's directional control not possible resulting from the rudder control assembly separation during the landing. A factor was the construction vehicle that the airplane impacted.NTSB MIA03LA150Accident · 1 fatalLimited investigationFinal reportTurkan Delta Wing Kite Trik · Odessa, FLThe pilot's improper assembly and failure to connect a bolt following an attempted modification that resulted in airframe malfunction, and uncontrolled descent, and an impact with the ground.NTSB SEA03GA153Accident · 1 fatalFinal reportKaman K-1200 · Keller, WACorrosion fatigue within the blade retention bolt bushing(s) of the main rotor blade grip resulting in fatigue, cracking and ultimate separation of the upper grip plate. The separation of the upper blade grip plate led to a dynamic imbalance within the rotor…NTSB IAD03CA068Accident · Minor injuriesData collectionFinal reportAero Commander 100 · Fulton, KYThe malfunction of the brake system and the pilot's delay in aborting the landing.NTSB CHI03LA230Accident · No injuriesLimited investigationFinal reportMurch Rotec Rally 3 · Searcy, ARThe frayed rudder cable that failed during the turn to final. A factor was the ditch the airplane encountered during the forced landing.NTSB SEA03FA147Accident · No injuriesField investigationFinal reportCessna Citation 525 · Coupeville, WAThe loss of airplane pitch control (trim runway and mistrim condition) resulting from a failure in the airplane's electric pitch trim system. Factors that contributed to the accident were the manufacturer's inadequate design of the pitch trim circuitry that…NTSB LAX03LA236Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Porterville, CAFatigue-induced failure of bolts in the helicopter's rotor drive flange, which resulted in a total loss of torque to the rotor drive shaft.NTSB CHI03LA222Accident · No injuriesLimited investigationFinal reportCessna 195 · Racine, WIThe failure of the left main landing gear axle resulting in the brake being locked and subsequent loss of directional control.NTSB FTW03LA189Accident · Serious injuriesLimited investigationFinal reportBeech 35-A33 · Fort Worth, TXThe loss of engine power due to the pilot's improper use of the mixture control. Contributing factors were the pilot's failure to select the battery/alternator circuit, resulting in a loss of battery power, the pilot's failure to follow a checklist and the…NTSB DEN03LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COthe right seat shifting aft during the take off roll, rendering aircraft control not possible by the flight instructor. Contributing factors include the inboard seat pin which did not engage fully, the outboard seat pin which was installed incorrectly, the…NTSB SEA03LA145Accident · No injuriesLimited investigationFinal reportAndelin S1E · Troutdale, ORThe pilot's inability to maintain directional control due to an obstruction of the left brake line by foreign material resulting in asymmetrical braking.NTSB LAX03FA232Accident · Serious injuriesField investigationFinal reportSikorsky S-58ET · Rancho P.Verdes, CAA total loss of antitorque control, due to the fatigue-induced failure of a gear within the drive shaft's intermediate gear box (IGB). Contributing factors were the pilot's improper on-ground decision to continue flight operations following discovery of…NTSB ANC03LA074Accident · No injuriesLimited investigationFinal reportBeech 58 · Hoonah, AKThe locking of the left brake during the landing roll, which resulted in the collapse of the left main landing gear.NTSB LAX03LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe disengagement of the left control wheel from the control column, which was due to the attaching screw backing out of the nut plate. Also causal was the manufacturer's inadequate design of the installation and the improper length of the screw.NTSB LAX03LA225Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350BA · Temple Bar, AZthe pilot's failure to follow the published electrical system emergency procedures for a hot battery, and his misjudged landing flare during the terminal phase of the autorotation maneuver at low level.NTSB SEA03LA128Accident · No injuriesLimited investigationFinal reportMooney M20-J · Renton, WAIn-flight failure of the electric landing gear motor during the initial takeoff climb.NTSB ANC03LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Seldovia, AKThe failure of company maintenance personnel to properly maintain the airplane's brake system, which resulted in a loss of the right brake during landing roll due to a chafed brake line.NTSB SEA03LA202Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Jerome, IDThe malfunction of the cooling system pressure relief valve and the pilot's failure to follow procedures. An engine over temperature, a coolant leak as a result of a relief valve failure, an obstructed windshield which was covered with coolant fluid, and an…NTSB CHI03LA191Accident · No injuriesLimited investigationFinal reportCessna 140 · Ludington, MIThe maintenance personnel's improper installation of the landing gear axle, which resulted in the separation of the axle from the landing gear.NTSB MIA03LA138Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Belle Glade, FLThe inability of the pilot to maintain directional control of the airplane following a blown right main landing gear tire during the takeoff roll, resulting in the airplane rolling into soft terrain and subsequent nose over. A factor in the accident was the…NTSB IAD03CA060Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Atlantic City, NJThe pilot's failure to properly secure an aerial advertising banner to the outside of the airplane.NTSB FTW03CA180Accident · No injuriesData collectionFinal reportSchweizer G-164B · Vega, TXThe failure of the left brake for undetermined reasons.NTSB DEN03FA113Accident · 1 fatalField investigationFinal reportMattison Starduster Too · Ellicott, COthe pilot's improper in-flight planning/decision to perform aerobatics at low altitude and the failed welds at the elevator horn and torque tube. Factors contributing to the accident were the pilot performing aerobatics at low altitude, his inability to…NTSB MIA03LA134Accident · Serious injuriesLimited investigationFinal reportJohn L. Klein Marquart ChargerMA-5 · Pierson, FLSeparation of the elevator push/pull tube from the rear cockpit's control stick for undetermined reasons, which resulted in a loss of elevator control, an uncontrolled descent, and an impact with trees.NTSB MIA03CA128Accident · Minor injuriesData collectionFinal reportKolb Mkiii · Bunnell, FLThe inadequate preflight inspection of the airplane by the pilot-in-command (pilot) for his failure to assure that the forward attachment of the right horizontal stabilizer was secured and safetied before flight resulting in rotation of the leading edge of…