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 FTW98FA325Accident · 1 fatalField investigationFinal reportCommander 114TC · West Jordan, UTA brittle fracture of the clamp that joins the exhaust pipe to the turbocharger. The pipe separated and hot exhaust gases escaped into the engine compartment. The engine lost power due to the high heat vaporizing fuel in the fuel line. Factors were inadequate…NTSB CHI98LA263Accident · No injuriesLimited investigationFinal reportCessna 150H · Frankfort, INthe improper maintenance installation by other maintenance personnel. Factors were a missing lubricating oil drain plug, the safety wire for the plug and the roadway.NTSB ANC98LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bethel, AKThe fracture of the flap handle position locking pin, which resulted in an uncommanded raising of the flaps during takeoff. A factor was the pilot's decision to takeoff with a suspected problem in the flap system.NTSB ANC98LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Big Lake, AKThe pilot's inadequate preflight procedure of failing to ensure his seat was engaged, which resulted in the seat slipping aft during takeoff.NTSB MIA98LA198Accident · Serious injuriesLimited investigationFinal reportVelocity Standard RG · Sebastian, FLA loss of power control due to a disconnected throttle linkage. Also causal was the inadequate maintenance by the owner/builder.NTSB CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.NTSB SEA98LA128Accident · 1 fatalLimited investigationFinal reportHughes 369D · Raymond, WAThe use of the improper long-line cable by the ground crew, and its subsequent separation from the helicopter.NTSB SEA98LA125Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pasco, WASeparation of the throttle linkage which resulted in the loss of power. Factors include worn throttle linkage parts and the furrows in the plowed field which was the available field for the forced landing.NTSB FTW98LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Beaumont, TXThe pilot's failure to maintain control of the airplane while attempting to return to the airport. Factors were the open baggage compartment door and the pilot's diverted attention to the open door.NTSB LAX98LA220Accident · Serious injuriesLimited investigationFinal reportBushby Mustang II · Livermore, CAAn inadequate inspection of the flight control system during the condition inspection by the check pilot/mechanic.NTSB SEA98LA111Accident · No injuriesLimited investigationFinal reportKoster Murphy Rebel · Arlington, WAThe pilot/builder's attachment inadequate installation of the aileron control pushrods to the control stick assembly, resulting in the ailerons deflecting in a direction opposite of the input applied by the pilot. Also causal was the pilot's inadequate…NTSB SEA98LA106Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Oakdale, WAA fatigue failure of the number three cylinder exhaust rocker box assembly, compromising the ability of the exhaust valve to operate. Factors include a ditch at the end of the runway.NTSB NYC98LA198Accident · No injuriesLimited investigationFinal reportCessna CE-500 · Fishers Island, NYAn intermittent short in the right wheel anti-skid system which caused a loss of braking and subsequent overrun.NTSB FTW98FA276Accident · 2 fatalField investigationFinal reportBeech A36 · Nephi, UTThe improper installation of the turbocharger exhaust stack by unknown maintenance personnel and the subsequent fire in the engine compartment due to the exhaust gas leak from the turbocharger. Factors were the total loss of engine power due to fuel line…NTSB CHI98LA213Accident · No injuriesLimited investigationFinal reportCessna 310N · Janesville, WIother maintenance personnel not installing nose landing gear door linkage. Factors were the unsecured landing gear door, the nose landing gear becoming jammed and the gear extension not possible by the pilot.NTSB ANC98LA082Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe rotation/slippage of the right main tire on the wheel rim, resulting in shearing of the tire tube valve stem, and subsequent tire deflation. Factors in the accident were oversize, tundra tires operated on a dry, asphalt runway surface.NTSB LAX98LA229Accident · No injuriesLimited investigationFinal reportCessna 310K · Calexico, CAThe pilot's continued operation of the aircraft with known deficiencies in the landing gear indicating system. A contributing factor to the accident was the pilot's expectation that the gear would be extended and locked irrespective of the indicator lights…NTSB FTW98LA280Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Shreveport, LAThe collapsed nose gear as a result of failure of the nose gear locking mechanism.NTSB LAX98LA204Accident · No injuriesLimited investigationFinal reportFife Lancair 320 · Palm Springs, CAA failure of the electrical system for undetermined reasons. The pilot's decision to continue flight with a suspected electrical system anomaly is a factor in the accident.NTSB ANC98FA069Accident · No injuriesField investigationFinal reportCessna 207A · Juneau, AKThe failure of company maintenance personnel to properly install a wire bundle clamp; chafing, electrical arcing, and subsequent leaking of a fuel line, which resulted in an in-flight fire. A factor associated with the accident was company maintenance…NTSB SEA98FA089Accident · 1 fatalField investigationFinal reportMooney M20A · Canyon Creek, MTThe design stress limits of the aircraft was exceeded. The pilot's inadequate preflight planning/preparation, lack of an instrument rating, poor weather evaluation and low ceilings and mountain obscuration were factors.NTSB FTW98LA260Accident · No injuriesLimited investigationFinal reportBell 206B · Corpus Christi, TXThe failure of the tail rotor drive shaft due to the separation of a bolt at one of the drive shaft disc couplings for an undetermined reason, which resulted in the pilot's inability to maintain directional control during landing.NTSB LAX98LA184Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Burbank, CAThe separation of the tail rotor pitch link due to a fatigue fracture, which resulted in the separation of the tailboom.NTSB FTW98LA253Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Delaplaine, ARThe failure of maintenance personnel to comply with and airworthiness directive, which resulted in failure of the planetary gear due to lack of lubrication. A contributing factors was the lack of suitable terrain for the pilot to execute a forced landing.NTSB FTW98LA252Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Coy, ARfailure of the left main tire, which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.NTSB MIA98LA168Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Jacksonville, FLthe left main landing gear failed to extend due to a jammed link assembly.NTSB FTW98LA241Accident · No injuriesLimited investigationFinal reportMader WAG-AERO 2+2 · Hurricane, UTAn encounter with high vegetation and unsuitable terrain during a forced landing. A factor was a partial failure of the engine's exhaust stack during flight.NTSB FTW98LA234Accident · Minor injuriesLimited investigationFinal reportHarding Revolution MINI-500B · Grove, OKThe improper alignment of the main drive belt by the owner/pilot/mechanic, which resulted in the failure of the main drive belt. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98IA164Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Minneapolis, MNthe open shielding on the #2 VHF transceiver coax connector which resulted in electromagnetic interference with the yaw damper system.NTSB MIA98LA165Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roberta, GAThe pilot's inadequate compliance with the emergency procedures for his failure to completely pump the main landing gear into the down and locked position. Contributing to the accident was the reported loss of electrical power for undetermined reasons.NTSB MIA98LA164Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Myers, FLThe pilot's inadequate inflight decision and her selection of unsuitable terrain to conduct a precautionary landing.NTSB ATL98FA076Accident · Serious injuriesField investigationFinal reportBeech BE-45-T-34B · Montgomery, ALThe installation of an incorrect engine nose seal that subsequently dislodged from the normally installed position, and resulted in the loss of engine power. A factor was the loss of engine oil.NTSB CHI98LA151Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Monroe, MIthe pilot-in-command's inability to rotate during takeoff due to restricted movement of the elevator controls for undetermined reasons.NTSB CHI98LA146Accident · No injuriesLimited investigationFinal reportDangremond Challenger II · Wayland, MIthe pilot's improper installation of the right wing forward strut attachment bolt.NTSB SEA98LA073Accident · No injuriesLimited investigationFinal reportAero Commander 500-A · Billings, MTFailure of the main landing gear strut outer-body to inner-body needle bearing from the lack of lubrication and the development of corrosion. An inadequate manufacturer's inspection program was a factor.NTSB FTW98LA211Accident · Serious injuriesLimited investigationFinal reportEller BD-5B · Falcon, COThe vibration induced overload failure of the canopy holdback fitting resulting in reduced control capability. A factor was partial failure of one propeller blade for unknown reasons.NTSB LAX98FA154Accident · 1 fatalField investigationFinal reportMooney M20K · Bakersfield, CAThe pilot's operation of the airplane at a speed well in excess of it's designed never exceed speed that resulted in elevator flutter and in-flight failure of the airplane. Turbulence and icing conditions were factors in the accident.NTSB FTW98LA201Accident · No injuriesLimited investigationFinal reportCessna 320D · Greybull, WYStress overload failure of the bellcrank assembly of the left landing gear.NTSB CHI98IA169Incident · No injuriesIncident investigationFinal reportDouglas DC-9-34 · St. Louis, MOthe yaw rate gyro of the Stab Aug Computer had been installed in a reverse position that was 180 degrees opposite from the correct position.NTSB LAX98LA144Accident · Minor injuriesLimited investigationFinal reportSchweizer G164D · Robbins, CAAircraft rudder post failure due to extensive rusting which resulted in a partial loss of aircraft control.NTSB CHI98IA136Incident · No injuriesIncident investigationFinal reportRobinson R22 Beta · Franklin, WIThe mechanic's failure to follow the manufacturer's maintenance rebuilding instructions.NTSB FTW98LA197Accident · No injuriesLimited investigationFinal reportRockwell 690B · Broomfield, COFailure of the flight instructor to maintain adequate supervision, and failure of the pilot receiving instruction to maintain directional control that was lost for reasons undetermined. A factor was the concrete culvert.NTSB MIA98LA137Accident · No injuriesLimited investigationFinal reportBennett M-500A · Lakeland, FLa hex nut on the cyclic flight control pushrod bolt had backed off for undetermined reason(s) and allowed the bolt to become disconnected from the control yoke teeter block, resulting in a loss of cyclic control and subsequent roll over during an emergency…NTSB DCA98IA035Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300-600 · Atlantic Ocean (Atlantic Ocean)Malfunction of the primary navigation system for undetermined reasons.NTSB CHI98LA128Accident · Minor injuriesLimited investigationFinal reportJaeger Sonerai II-L · Bicknell, INThe pilot misjudged his altitude and airspeed during an emergency landing attempt. Factors associated with this accident were a manufacturing defect in the magneto drive coupling and a total failure of the ignition system.NTSB CHI98LA125Accident · No injuriesLimited investigationFinal reportBeech B35 · Bentonville, ARthe damage to the empennage was due to flutter.NTSB CHI98IA167Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD82 · Washington, DCThe failure of the Dual Axis Accelerometer.NTSB MIA98LA120Accident · No injuriesLimited investigationFinal reportBell 205 · Wewahitchka, FLThe pilot's loss of control as a result of erratic flight control movement due to a surge in hydraulic pressure for undetermined reasons.NTSB FTW98FA170Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · New Orleans, LAThe pilot's inability to maintain control of the airplane after experiencing spatial disorientation. Factors were the total failure of the vacuum pump, fog, drizzle, and night conditions.NTSB SEA98LA058Accident · No injuriesLimited investigationFinal reportCessna 195A · Bend, ORSeparation by fracture of the left main gear leg, as the result of fatigue cracks that initiated in corrosion pits on the gear leg surface.