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 ANC89LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyac Mine, AKFailure of the left rudder pedal bar assembly and failure of the pilot to maintain control of the aircraft. Improper maintenance and the pilot's lack of total experience were considered to be contributing factors.NTSB CHI89DEP07Accident · Minor injuriesFinal reportHiller UH-12E · Blackriverfalls, WIPilot-in-command's failure to jettison the external load followed by his misjudgement of distance to avoid collision with the external load.NTSB DCA89MA063Accident · 111 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-10-10 · Sioux City, IAThe inadequate consideration given to human factors limitations in the inspection and quality control procedures used by united airlines' engine overhaul facility which resulted in the failure to detect a fatigue crack originating from a previously…NTSB LAX89LA245Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Maricopa, AZThe pilot's inability to maintain airspeed, resulting in a hard landing. Also causal to the accident was the opening of the canopy for undetermined reasons.NTSB CHI89LA136Accident · No injuriesLimited investigationFinal reportCessna 335 · Pontiac, MIFailure of the right main landing gear extension/retraction component resulting from unacceptable loads incurred due to improper adjustment.NTSB FTW89LA135Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Okmulgee, OKFailure of the nose gear extension assembly and the pilot's improper precautionary landing procedures that included securing the engines prior to a point where a safe landing was assured.NTSB CHI89MA132Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC8-63F · Vandalia, OHFailure of the left main landing gear, bogie trim cylinder, and malfunction of the emergency airbrake control valve.NTSB FTW89FA134Accident · Serious injuriesField investigationFinal reportCessna 150L · Fort Worth, TXA loss of control of the airplane due to the pilot's inability to raise the flaps which resulted in a stall. The flap failure and subsequent full flap takeoff were the result of the operator's improper maintenance of the airplane and the operator's use of a…NTSB SEA89LA130Accident · Serious injuriesLimited investigationFinal reportCushing C2 · John Day, ORThe pilot improperly changed the design of the airplane by elongating holes at the wing attachment. The change was not inspected by a qualified individual. As a result of the change, the wing separated at the spar.NTSB LAX89LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Los Angeles, CAAn undertorqued oil line fitting, due to its improper installation by maintenance personnel, which resulted in a loose oil line fitting, an oil line leak, oil exhaustion, and subsequent failure of the engine.NTSB FTW89DPJ08Accident · Serious injuriesFinal reportGrumman G-164 · Guymon, OKFailure of the upper right engine mount (firewall attach bolt) due to fatigue, and failure of the lower right mounting bolt for an unknown reason, which allowed overload failure of the two remaining mounting bolts and separation of the engine.NTSB ATL89DKJ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Goodway, ALThe in-flight separation of the left wing which failed because of a corrosion induced fatigue fracture.NTSB DEN89FA155Accident · Serious injuriesField investigationFinal reportPiper PA-16 · Minot, NDFailure of the airframe tubing (longeron) at the lower forward door frame due to corrosion. A contributing factor was failure of maintenance personnel to comply with service bulletin #819.NTSB MKC89LA150Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jonesboro, ARThe pilot's encounter with unsuitable terrain during a forced landing made necessary by the separation of three feet of one of the propeller blades.NTSB NYC89LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Southampton, MAImproper maintenance which resulted in a section of the vertical stabilizer failing inflight.NTSB SEA89FA122Accident · No injuriesField investigationFinal reportDouglas DC-3C · Petersburg, AKThe pilot's improper decision to ditch the aircraft when it could have been flown back to the airport using the right seat controls. Contributing factor(s) was: the failure & separation of a portion of the right aileron fabric, and the pilot's excessive force…NTSB BFO89IA047Incident · No injuriesIncident investigationFinal reportBritish Aerospace 3101 · Baltimore, MDFailure of maintenance personnel to properly torque the power connection at the air conditioning system fuse.NTSB FTW89DPJ07Accident · 2 fatalFinal reportBeech T-34 · Haskell, OKFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: a leak in the pitot system, failure of the pilot to obtain adequate maintenance/inspection of the pitot system, and his lack of…NTSB DEN89LA144Accident · No injuriesLimited investigationFinal reportBeauchesne/Wells Glasair TD · Moriarity, NMImproper installation of the propeller which resulted in severe vibration and failure of the propeller mounting bolts, & the separation of the propeller from the aircraft. Rough/uneven desert terrain contributed to the accident.NTSB ANC89IA099Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-3 · Palmer, AKInadequate lubrication which resulted in the failure of the horizontal stabilizer's trim actuator.NTSB CHI89FA114Accident · 2 fatalField investigationFinal reportMcculloch J-2 · Oxford, OHThe failure of the pilot operator to replace the main rotor thrust bearing. The expired service life of the main rotor thrust bearing is a factor in the accident.NTSB LAX89LA223Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Herlong, CAFuel starvation, after the pilot diverted his attention to an electrical problem, and his failure to reposition the fuel selector switch, either before the engine lost power or during emergency procedures. Factors related to the accident were: the tripped…NTSB DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.NTSB SEA89FA111Accident · Serious injuriesField investigationFinal reportOregon Helicopters UH-1L · Baring, WAFatigue failure of the tail rotor 42 degree gear box due to pilot induced overstress. Navy data and FAA type certificate limitations were not adhered to.NTSB FTW89LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Austin, TXThe failure of the aircraft brake system. Factors include high tail wind.NTSB ANC89LA106Accident · No injuriesLimited investigationFinal reportHelio H-295 · King Salmon, AKAn undetermined problem related to the engine, propeller, and/or failed tailwheel assembly.NTSB SEA89FA099Accident · 2 fatalField investigationFinal reportCushing 4 · Mansfield, WAFailure of the left wing main spar due to overload for undetermined reasons.NTSB MIA89LA165Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Keystone Hgts., FLThe tail rotor drive system became disconnected due to a bent tail rotor drive shaft. The trees contributed to the helicopter damage.NTSB SEA89LA096Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Hermiston, ORFailure and separation of the left main landing wheel.NTSB CHI89DEP04Accident · No injuriesFinal reportHiller UH-12E · Waterford, WIThe pilot's inability to maintain control during an autorotational landing attempt following the failure of the main rotor drive train torsional coupling.NTSB LAX89LA198Accident · No injuriesLimited investigationFinal reportCessna 140 · Placerville, CATotal failure of the landing gear tire. A major factor was the unsuitability of the terrain at the side of the runway.NTSB CHI89FA092Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Marion, ILFailure of the pilot to maintain directional control of the aircraft. Contributing to the accident was lack of crew coordination and inappropriate remedial action on the part of the aircrew, and improper maintenance modification by the operator.NTSB MIA89LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Gainesville, FLPilot's inability to properly flare due to a high sink rate as a result of insufficient airspeed which resulted in a hard landing short of and off of the runway.NTSB ATL89DLT03Accident · No injuriesFinal reportBell 47 · Shelbyville, TNFailure in the rotor drive system for unknown reasons. Contributing to the accident was the pilot's inability to perform an autorotation.NTSB SEA89LA083Accident · Serious injuriesLimited investigationFinal reportDavis Starship Alpha · Star, IDFailure of the propeller drive belt (stripped teeth). Contributing factors were: strong/gusty winds and the hilly terrain.NTSB MKC89FA104Accident · 1 fatalField investigationFinal reportCallair A-9 · Hamilton, MOThe pilots failure to maintain control and prevent the airplane from descending while in a turn.NTSB ANC89FA069Accident · Minor injuriesField investigationFinal reportBell 412 · Girdwood, AKA main rotor flight control bolt (part number 20-057-6-38D) came out of its rod end bearing while in flight due to the bolt being improperly torqued during maintenance.NTSB CHI89IA083Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNFailure of the hydraulic power transfer unit shut-off (ptu s/o) valve due to failed (fatigued) valve body attach screws.NTSB LAX89LA173Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Travis Afb, CAThe left main landing gear failing to fully extend for undetermined reasons resulting in its collapsing during landing.NTSB LAX89DVM02Accident · Minor injuriesFinal reportHiller UH-12E · Salinas, CAThe separation of the torsion coupling in the main rotor drive system.NTSB ATL89LA133Accident · No injuriesLimited investigationFinal reportBeech A36 · Macon, GAThe pilot delayed remedial action when the imminent loss of electrical power was observed. Additionally, the pilot's failure to execute the appropriate emergency procedure and manually lower the landing gear, resulted in its collapse upon landing.…NTSB ATL89FA130Accident · Serious injuriesField investigationFinal reportBell UH-1E · Aiken, SCImproper installation of a tail rotor pitch change crosshead retention bolt by the company mechanic, which resulted in loosening of the bolt and eventual failure of the tail rotor assembly/blade and subsequent loss of control. Trees at the crash site…NTSB ANC89IA059Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-6-100 · Barrow, AKThe propagation of a fatigue crack from multiple origins due to manufacturing defects in the elevator bellcrank mounting quadrant.NTSB CHI89FA071Accident · Serious injuriesField investigationFinal reportSikorsky S-58T · Milwaukee, WIDisconnect of the tailrotor drive shaft coupling.NTSB SEA89LA066Accident · No injuriesLimited investigationFinal reportThiessen RV-4 · Independence, ORFailure of the propeller. A related factor was the obstruction (transmission line) in the emergency landing area.NTSB NYC89LA113Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Utica, NYA fire in the cockpit from an unknown source.NTSB MIA89IA118Incident · No injuriesIncident investigationFinal reportCessna P206B · West Palm Beach, FLFailure of the throttle control arm resulting in the loss of engine power. The failure was caused by poor maintenance.NTSB DEN89LA095Accident · No injuriesLimited investigationFinal reportBeech F33A · Lamar, COFailure of an alternator bearing which resulted in total loss of electrical power after the battery became discharged, and failure of the pilot to insure the gear was fully extended during a precautionary landing. The pilot's lack of familiarity with the gear…NTSB NYC89LA103Accident · No injuriesLimited investigationFinal reportBeech A100 · Johnstown, PAFailure of the down lock plate, which allowed the landing gear to collapse.NTSB DCA89MA035Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas DC-9-33F · Saginaw, TXThe loss of control of the airplane for undetermined reasons following the inflight opening of the improperly latched cargo door. Contributing to the accident were: inadequate procedures used by evergreen airlines and approved by the FAA for preflight…