NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

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
  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.

NTSB ATL89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Liberty, NCThe pilot's inadvertent landing at the wrong airport, contributing to the accident was the failure of the airport personnel to notify the FAA of the existance of the airport so it could be properly designated on aviation charts.Feb 26, 1989 · N56600 · Substantial damageNTSB SEA89LA051Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Albany, ORThe failure of the student pilot to maintain directional control of the airplane during landing and the improper use of flight controls. Contributing to the accident were the crosswind and the pilot's lack of total experience.Feb 25, 1989 · N97764 · Substantial damageNTSB NYC89LA090Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L-2M · Olcott, NYThe inattentiveness of the pilot to maintain airspeed while turning base leg for landing which resulted in a stall and subsequent collision with a hangar.Feb 25, 1989 · N60201 · DestroyedNTSB MKC89LA066Accident · No injuriesLimited investigationFinal reportCessna 182RG · Ft. Madison, IAAn electrical wiring short that caused an in flight fire.Feb 25, 1989 · N4314R · Substantial damageNTSB MKC89LA065Accident · No injuriesLimited investigationFinal reportComposite Aircraft Mfg Cozy · Hudson, IAImproper preflight by the pilot which resulted in an inadequate fuel supply and fuel exhaustion.Feb 25, 1989 · N611CZ · Substantial damageNTSB MKC89LA064Accident · No injuriesLimited investigationFinal reportCessna 172B · Unionville, IAThe failure of the engine due to carburetor ice. Contributing factors included carburetor icing conditions, improper use of the carburetor heat control by the pilot, and the improperly rigged carburetor air box which resulted in reduced carburetor heating…Feb 25, 1989 · N7662X · Substantial damageNTSB MKC89FA063Accident · 2 fatalField investigationFinal reportPiper PA-18 · Jacksonville, ARSevere corrosion of the left forward wing lift strut which resulted in the in-flight separation of the left wing. A contributing factor was inadequacy of the applicable service bulletin.Feb 25, 1989 · N7580D · DestroyedNTSB MIA89IA095Incident · No injuriesIncident investigationFinal reportCessna 172N · Homestead, FLFuel starvation caused by a sticking needle valve which was softened by contact with automotive fuel previously used to operate the engine.Feb 25, 1989 · N734MC · No damageNTSB MIA89IA094Incident · No injuriesIncident investigationFinal reportBeech B60 · Jacksonville, FLFailure of the left main landing gear retract rod due to poor maintenance and inspection of the main gear assembly.Feb 25, 1989 · N294D · Minor damageNTSB MIA89FA093Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Inverness, FLThe failure of the propeller governor oil line due to fatigue which was caused by bending damage to the line and the failure of mechanics to install support clamps on the line which caused the fatigue to propagate at a faster rate.Feb 25, 1989 · N43330 · DestroyedNTSB CHI89DEV05Accident · No injuriesFinal reportCessna 182A · Sparta, ILPoor and improper maintenance which resulted in the carburetor venturi being blocked by the duct tape. Contributing to the accident was the soft terrain on which the forced landing was made.Feb 25, 1989 · N4717D · Substantial damageNTSB MIA89LA092Accident · No injuriesLimited investigationFinal reportBell 47G · Oklawaha, FLPilot's failure to properly control the helicopter during an attempted landing on the back of a truck. Contributing to the accident was the pilot's lack of experience in performing similar landings.Feb 24, 1989 · N863Z · Substantial damageNTSB LAX89LA115Accident · No injuriesLimited investigationFinal reportRobinson R22 · Hayward, CAFailure of airport personnel to assure the taiway was free of objects after the taxiway was painted.Feb 24, 1989 · N9076K · Substantial damageNTSB DEN89LA080Accident · Minor injuriesLimited investigationFinal reportEller BD-5B · Colorado Spring, COThe improper installation of fuel lines which were pinched off causing fuel starvation when the gear was retracted. A factor in the accident were the terrain features including loose gravel short of the runway.Feb 24, 1989 · N94EC · Substantial damageNTSB DCA89MA027Accident · 9 fatalClass 1 · MajorFinal reportBoeing 747-122 · Honolulu, HIThe sudden opening of the improperly latched forward lobe cargo door in flight and the subsequent explosive decompression. Contributing to the accident was a deficiency in the design of the cargo door locking mechanisms, which made them susceptible to…Feb 24, 1989 · N4713U · Substantial damageNTSB SEA89FA050Accident · Minor injuriesField investigationFinal reportMooney M20K · Incline Village, NVThe pilot's improper use of the fuel system when troubleshooting surging fuel pressure. A contributing factor was snow conditions which impaired the pilot's ability to make a proper forced landing.Feb 23, 1989 · N94276 · DestroyedNTSB NYC89LA096Accident · No injuriesLimited investigationFinal reportBell 206B · Harding Twnp, NJThe pilots attempt to conduct the flight with less than required fuel resulting in loss of engine power and subsequent damage to the helicopter while performing an autorotative landing.Feb 23, 1989 · N5754J · Substantial damageNTSB MKC89LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Kansas City, MOImproper use of the carburetor heat control by pilot in command.Feb 23, 1989 · N25909 · Substantial damageNTSB LAX89LA114Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6 · Compton, CAFatigue cracks that existed in an engine cylinder.Feb 23, 1989 · N6972C · Substantial damageNTSB FTW89LA056Accident · No injuriesLimited investigationFinal reportMcculloch J-2 · Orange, TXThe pilot failed to maintain rotor RPM due to a lack of familiarity with aircraft performance data and procedures.Feb 23, 1989 · N4381G · Substantial damageNTSB FTW89FA055Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Mount Vernon, TXInadequate maintenance and inspection of the airplane by the mechanics who rebuilt the airplane, in that they failed to detect and/or correct the corroded lift strut which resulted in wing failure.Feb 23, 1989 · N494CB · DestroyedNTSB ANC89LA047Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igiugig, AKThe pilot's failure to maintain control of the airplane and his failure to understand the performance parameters of his airplane.Feb 23, 1989 · N78627 · Substantial damageNTSB NYC89FA089Accident · Minor injuriesField investigationFinal reportAerospatiale AS-350D · Spring Valley, NYFailure of the FAA flight examiner (f/e) to follow proper procedures concerning the autorotation, and improper remedial action by the pilot-in-command (PIC). Factors related to the accident were: lack of information in the flight manual concerning…Feb 22, 1989 · N5793P · DestroyedNTSB NYC89FA088Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Washington, PAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) which resulted in his loss of aircraft control. Factors related to the accident was: the pilot's flight into known weather, the adverse weather, and trees at the accident sight.Feb 22, 1989 · N767SA · Substantial damageNTSB MKC89FA060Accident · 1 fatalField investigationFinal reportCessna 150K · Pemberton, MNPoor judgement on the part of the pilot in that he attempted a down wind take off without adequate distance to clear obstacles in his flight path.Feb 22, 1989 · N6010G · Substantial damageNTSB MIA89WA091Accident · No injuriesForeign investigationPiper PA-31 · Pine Cay, Turks & Caicos IslandsFeb 22, 1989 · N222SC · Substantial damageNTSB LAX89DUJ05Accident · Serious injuriesFinal reportWarwick Thorp T-18 · Aguila, AZFailure of the pilot to maintain directional control, which resulted in the aircraft veering off the runway. Factors related to the accident were: uneven runway & the ditch.Feb 22, 1989 · N9675Z · Substantial damageNTSB FTW89LA054Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Brownsville, TXThe pilot failed to compensate for the existing wind conditions and maintain proper alignment with the runway. The wind conditions and the sunglare are considered to be contributing factors to the accident.Feb 22, 1989 · N3826D · Substantial damageNTSB DEN89LA079Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Wolf Point, MTThe failure of the student pilot to use carburetor heat in a timely manner which resulted in a partial loss of engine power. Contributing to the accident was the inadequate weather evaluation the pilot made after taking off and flying through fog due to his…Feb 22, 1989 · N4627E · Substantial damageNTSB ANC89LA046Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sulatna River, AKThe pilot's failure to maintain control of the airplane which resulted in a stall.Feb 22, 1989 · N1243A · Substantial damageNTSB FTW89IA053Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Houston, TXThe turbine guide vane failure.Feb 21, 1989 · N1289L · Minor damageNTSB ATL89FA090Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Tipp City, OHImproper planning by the pilot resulting in fuel exhaustion. The pilots lack of equipment and ability to handle the weather situation was ignored by the pilot in his planning for the flight.Feb 21, 1989 · N1139X · DestroyedNTSB NYC89LA087Accident · No injuriesLimited investigationFinal reportCessna 172RG · Durhamville, NYFailure of the pilot to extend the landing gear before landing after allowing his attention to be diverted.Feb 20, 1989 · N9530B · Substantial damageNTSB MIA89FA090Accident · 2 fatalField investigationFinal reportCessna 172 · Blue Mountain, MSThe continuation of a VFR flight into night, instrument meteorological conditions and the spatial disorientation of the non-instrument rated pilot. Contributing to the accident were the adverse weather conditions and the overconfidence of the pilot.Feb 20, 1989 · N3937F · DestroyedNTSB NYC89FA086Accident · 6 fatalField investigationFinal reportBeech A36 · Glen Falls, NYFailure of both pilots to see-and-avoid each other. Related factors were: failure of the Beech aircrew to make a normal left turn out of traffic and the Stinson pilot's visual perception due to sunglare.Feb 19, 1989 · N1DQ · 2 aircraft · DestroyedNTSB LAX89LA131Accident · Serious injuriesLimited investigationFinal reportAerostar Raven 560 · Tucson, AZBalloon entered into a severe down draft which resulted in a hard landing due to inadequate preparation and compensation for the conditions by the balloon pilot.Feb 19, 1989 · N767AA · No damageNTSB DEN89LA078Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Angel Fire, NMInadequate compensation for wind conditions by the pilot, which resulted in a loss of aircraft control. The adverse wind conditions and snowbank were related factors.Feb 19, 1989 · N9092W · Substantial damageNTSB DCA89RA025Accident · 4 fatalForeign investigationBoeing 747-200 · Puchong Malaysi, MalaysiaFeb 19, 1989 · N807FTNTSB DCA89MA026Accident · 10 fatalMajor investigationFinal reportCessna 402B · Corona, CAThe pilot's failure to properly preflight and plan for flight and his intentional flight into IMC conditions. Factors contributing to the accident were the low ceiling conditions in conjunction with the mountainous terrain.Feb 19, 1989 · N69383 · DestroyedNTSB ATL89LA092Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waynesville, OHThe pilot delayed his landing/touchdown, misjudged the distance of the remaining runway and did not go around. The slick/thawing runway conditions and the fences were contributing factors.Feb 19, 1989 · N8510L · Substantial damageNTSB ANC89LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe pilot's failure to maintain directional control during a touch and go landing. A contributing factor is the pilot's lack of total flight experience.Feb 19, 1989 · N5312Q · Substantial damageNTSB MIA89LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fort Lauderdale, FLFaulty installation of avionics equipment which caused wiring in the landing gear system to be improperly reinstalled.Feb 18, 1989 · N4303X · Substantial damageNTSB LAX89FA113Accident · 1 fatalField investigationFinal reportCessna 172F · Safford, AZFailure of the pilot to maintain proper airspeed while on final approach resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed use of wing flaps.Feb 18, 1989 · N8492U · DestroyedNTSB FTW89LA052Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Austin, TXThe pilot's inaccurate fuel consumption calculations and improper positioning of the fuel tank selector valve.Feb 18, 1989 · N5175U · Substantial damageNTSB CHI89LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Quincy, ILThe pilot's failure to achieve a proper touchdown point and to maintain adequate visual lookout during the landing.Feb 18, 1989 · N6894H · Substantial damageNTSB ATL89LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Cleveland, TNFlight into known adverse weather by the pilot and his delay in diverting to an alternate airport which led to a partial power loss and an emergency landing. The weather conditions and soft terrain were contributing factors.Feb 18, 1989 · N8032A · Substantial damageNTSB SEA89LA061Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35J · Spokane, WAThe failure of the pilot to maintain directional control and runway alignment during the landing roll. Factors related to the accident were: light conditions at dawn, snow and ice on the runway, and the runway lights.Feb 17, 1989 · N54US · Substantial damageNTSB MKC89FA061Accident · 2 fatalField investigationFinal reportBeech 58 · Hamburg, ARThe pilot continued VFR flight into IMC conditions and failed to maintain sufficient altitude above the wooded terrain. Weather conditions, low light conditions at or near dusk, lack of visual cues (visual perception) by the pilot, and trees were contributing…Feb 17, 1989 · N348U · DestroyedNTSB MIA89LA087Accident · Minor injuriesLimited investigationFinal reportHarmon Velocity · Fort Lauderdale, FLThe inability of the pilot to recover from the intentional stall with an unknown c.g.Feb 17, 1989 · N330RH · Substantial damageNTSB MIA89FA088Accident · 2 fatalField investigationFinal reportCessna 320E · Melrose, FLThe failure of the pilot to comply promptly with ATC instructions and his loss of control due to spatial disorientation.Feb 17, 1989 · N3488Q · Destroyed