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 LAX89DVG06Accident · No injuriesFinal reportGrumman G-164B · Davis, CAThe pilot failed to properly use his brakes during the off airport landing.May 14, 1989 · N3629Y · Substantial damageNTSB FTW89DPJ04Accident · Minor injuriesFinal reportFields Rotorway Exec · Oklahoma City, OKThe pilot's failure to maintain proper altitude during the hover taxi.May 14, 1989 · N28276 · Substantial damageNTSB CHI89LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ojibwa, WIImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were: the wet/upward sloping condition of the airstrip, unfavorable wind, high obstructions (tall trees/obstacles at the end of the runway), and high…May 14, 1989 · N82702 · Substantial damageNTSB CHI89LA088Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 · Big Rapids, MIInadequate compensation for wind conditions by the pilot and his failure to maintain directional control. The the variable/gusty/crosswind condition was considered to be a contributing factor.May 14, 1989 · N163MH · Substantial damageNTSB CHI89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waunakee, WISlippage of a bearing, which resulted in blockage of the lubrication system, and subsequent failure of a connecting rod.May 14, 1989 · N7465P · Substantial damageNTSB SEA89LA085Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Ely, NVThe pilot's improper decision to continue flight into IMC. Contributing to the accident were snow, obscuration and mountainous terrain.May 13, 1989 · N8049R · Substantial damageNTSB SEA89LA084Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Battle Mountain, NVInadequate compensation for wind condition by the pilot. Contributing to the accident were wind gusts encountered during landing flare.May 13, 1989 · N2943K · Substantial damageNTSB MKC89FA109Accident · Serious injuriesField investigationFinal reportBensen B-8KSB · Eldon, MOPilot's failure to maintain aircraft control which resulted in collision with the terrain during take off.May 13, 1989 · N37511 · Substantial damageNTSB DEN89DTM02Accident · Serious injuriesFinal reportHiller UH-12E · Mack, COThe pilot's failure to maintain proper altitude during a swath run.May 13, 1989 · N5594N · Substantial damageNTSB ATL89LA147Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay, NCFailure of the student pilot to maintain directional control of the aircraft during the landing, which resulted in an inadvertent ground swerve. Contributing factors were: improper flare by the student during the landing, which resulted in a hard landing, and…May 13, 1989 · N733VS · Substantial damageNTSB ATL89LA146Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Troy, NCAn undetermined powerplant problem, which resulted in a loss of engine power, and the pilot/mechanic's failure to assure the aircraft was properly inspected before flight. Factors related to the accident were: the pilot's delay in making a precautionary…May 13, 1989 · N99766 · DestroyedNTSB NYC89DNE02Accident · 1 fatalFinal reportSmith Mini DSA-1 · Sterling, CTThe pilot's failure to maintain control of the experimental aircraft while performing aerobatic maneuvers, and the aircraft's resultant uncontrolled descent into the ground.May 12, 1989 · N21H · Substantial damageNTSB LAX89LA193Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Upland, CAInadequate in-flight planning/decision by the pilot in command, the instructor pilot. Factors were the private pilot did not switch the fuel tanks and the instructor did not catch it.May 12, 1989 · N5368V · Substantial damageNTSB LAX89LA187Accident · No injuriesLimited investigationFinal reportCessna T210N · Monterey, CAThe pilots improper use of the checklist when his attention was diverted.May 12, 1989 · N7568N · Substantial damageNTSB CHI89LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Terre Haute, INPilot's inability to maintain directional control during the takeoff roll. A factor in the accident was the crosswind.May 12, 1989 · N77201 · Substantial damageNTSB 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.May 12, 1989 · N908B · Substantial damageNTSB MKC89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Moberly, MOThe failure of the pilot in command to maintain control of the aircraft while on takeoff ground run. Contributing to this lack of control were wind gusts from dust devils in the area, thermal activity, and the pilot's lack of experience.May 11, 1989 · N7741W · Substantial damageNTSB MKC89FA107Accident · Serious injuriesField investigationFinal reportCessna 152 · Cottage Grove, MNPoor judgement of the pilot by flying while physically impaired from consumption of alcohol; and his failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and collision with wooded/hilly terrain.May 11, 1989 · N5357Q · Substantial damageNTSB LAX89LA196Accident · No injuriesLimited investigationFinal reportCessna 175A · Mojave, CAInadequate preflight planning/preparation, and the pilot's disregard of the wind information.May 11, 1989 · N7002E · Substantial damageNTSB LAX89LA191Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300-B4-203 · San Diego, CAAn unexpected encounter with clear air turbulence which seriously injured a passenger in the aft lavatory.May 11, 1989 · N972C · No damageNTSB LAX89LA190Accident · No injuriesLimited investigationFinal reportCessna 150D · Vacaville, CAThe pilots failure to accurately calculate fuel consumption during preflight planning and preparation and during the flight which resulted in fuel exhaustion.May 11, 1989 · N4276U · Substantial damageNTSB CHI89LA086Accident · No injuriesLimited investigationFinal reportPorterfield CP-55 · Tecumseh, MIPilot's inadequate preflight operatins, which failed to detect the presence of water contamination in the fuel system, and resulted in the substantial loss of power and subsequent forced landing. The aircraft encountered soft, loose soil during the forced…May 11, 1989 · N32340 · Substantial damageNTSB ATL89LA145Accident · No injuriesLimited investigationFinal reportHughes 269A · Ozark, ALThe pilot's excessive use of the cyclic control and the misjudged flare during a practice touchdown autorotation.May 11, 1989 · N9049J · Substantial damageNTSB LAX89FA192Accident · 1 fatalField investigationFinal reportBeech 200 · Azusa, CAImproper in-flight planning/decision by the pilot, which resulted in has inadvertent flight into instrument meteorological conditions (IMC) and subsequent collision with mountainous terrain. The weather and terrain conditions were considered to be related…May 10, 1989 · N39YV · DestroyedNTSB ANC89LA082Accident · No injuriesLimited investigationFinal reportCessna 180H · Togiak, AKImproper planning/decision by the pilot. Contributing factors were: light conditions at dusk, an unsafe/hazardous condition (drum that someone had left near the landing area).May 10, 1989 · N2747X · Substantial damageNTSB ANC89FA070Accident · No injuriesField investigationFinal reportCessna C-402 · Tatitlek, AKInstallation of the improper washer on the scissors assembly of the left main landing gear. The extra forces encounteredon a gravel runway were sufficient to pull the bushing, washer, and bolt through the scissors assembly and allowing the lower half to pivot…May 10, 1989 · N966JW · Substantial damageNTSB 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.May 9, 1989 · N5531N · Substantial damageNTSB SEA89LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Woodland, WAThe pilot's poor planning and inadequate calculation of fuel consumption which resulted in fuel exhaustion.May 9, 1989 · CGREV · Substantial damageNTSB MIA89FA146Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Fort Pierce, FLInadequate supervision by the instructor pilot (CFI), and failure of the crew to maintain sufficient airspeed, which resulted in an inadvertent stall/spin and subsequent loss of engine power from possible interruption of fuel.May 9, 1989 · N2231M · DestroyedNTSB LAX89LA146Accident · No injuriesLimited investigationFinal reportBeech A36 · Sacramento, CAFailure of the number four piston assembly. A factor related to the accident was: the soft/uneven terrain in the emergency landing area.May 9, 1989 · N7238A · Substantial damageNTSB LAX89FA189Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Dublin, CAThe pilot decided to continue VFR flight after encountering instrument meteorological conditions in an area of rising mountainous terrain. Factors in this accident were the pilots lack of experience and his failure to obtain a preflight weather briefing.May 9, 1989 · N8078V · DestroyedNTSB DEN89LA118Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Regina, NMThe pilot's poorly planned approach and disregard of the helicopters performance data. Contributing to the accident was the high density altitude conditions which existed at the time of the accident.May 9, 1989 · N88RA · Substantial damageNTSB MKC89LA105Accident · No injuriesLimited investigationFinal reportWeatherly 620TP · Montrose, ARFailure of the pilot in command to maintain control of the aircraft during landing adversely affected by the existance of a tailwind of average proportions.May 8, 1989 · N4607C · Substantial damageNTSB LAX89LA185Accident · Minor injuriesLimited investigationFinal reportCessna 210T · Imperial, CAThe pilots inaccurate fuel consumption calculations along with the decision to depart with inadequate fuel to insure landing at his proposed destination which resulted in fuel exhaustion. The rough/uneven terrain on which the landing was made contributed to…May 8, 1989 · N30678 · Substantial damageNTSB LAX89IA184Incident · Minor injuriesIncident investigationFinal reportBoeing 747 · Los Angeles, CAInadequate visual look-out by the pilot of the other (small twin engine) aircraft. A factor related to the incident was: a delay of the 747 crew to see-and-avoid the other aircraft.May 8, 1989 · ZKNZX · No damageNTSB MKC89LA106Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, MNThe pilots failure to properly calculate fuel consumption which resulted in an inadequate fuel reserve and fuel exhaustion prior to reaching his destination. During the ensuing forced landing the pilot failed to maintain airspeed which resulted in an…May 7, 1989 · N6411K · Substantial damageNTSB MKC89FA104Accident · 1 fatalField investigationFinal reportCallair A-9 · Hamilton, MOThe pilots failure to maintain control and prevent the airplane from descending while in a turn.May 7, 1989 · N3581G · DestroyedNTSB MKC89DCG01Accident · Serious injuriesFinal reportGrigg/Bowers Flybaby · West Plains, MOImproper preflight planning by the pilot and his failure to attain adequate airspeed, which resulted in a stall as he was attempting to avoid a power transmission line. Factors related to the accident were: rising terrain, tall grass, tailwind, and the…May 7, 1989 · N1305 · DestroyedNTSB FTW89FA093Accident · 1 fatalField investigationFinal reportMBB BO-105S · W Cameron BlkThe partial electrical failure of the micro-switch for the outboard lateral guide assembly, and the incorrect guard installed on the hydraulic test switch, resulting in a total hydraulic failure. Factors were: the incorrect installation of the guard by an…May 7, 1989 · N2785B · DestroyedNTSB DEN89FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Livingston, MTThe poor judgement displayed by the pilot when he maneuvered the airplane at extremely low altitude over mountainous terrain. During the flight the pilot misjudged the pull-up required and struck trees.May 7, 1989 · N7296J · Substantial damageNTSB DEN89DTE03Accident · Serious injuriesFinal reportGalbreath Variviggen · Falcon, COThe pilot's lack of familiarity with the control characteristics of this newly completed homebuilt. The pilot's failure to use proper control inputs and the lack of information provided by the aircraft kit manufacturer are considered as contributing factors…May 7, 1989 · N34VV · DestroyedNTSB ATL89DMG03Accident · Serious injuriesFinal reportSmithgall Pitts Special S-1C · Fuquay-Varina, NCPilot did not maintain sufficient altitude to insure recovery from an aerobatic maneuver and spin.May 7, 1989 · N7VC · DestroyedNTSB SEA89LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Yamhill, ORFailure of the pilot to maintain proper airspeed on final approach. Contributing to the accident was lack of total experience.May 6, 1989 · N6575G · Substantial damageNTSB SEA89LA080Accident · Minor injuriesLimited investigationFinal reportMccoy Super Koala · Kelso, WAThe pilot's failure to adequately compensate for wind conditions, and the pilot's delay in initiating a go-around. Contributing to the accident were crosswind gusts, and lack of total pilot experience.May 6, 1989 · N30SK · DestroyedNTSB MKC89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Brainerd, MNThe pilot's failure to follow procedures which resulted in the failure to extend the landing gear prior to touchdown. A contributing factor was the pilot's inattentiveness.May 6, 1989 · N8152R · Substantial damageNTSB MIA89LA147Accident · No injuriesLimited investigationFinal reportCessna 310P · Fort Myers, FLCollapse of the left main landing gear due to overload failure of the trunnion and bellcrank assembly.May 6, 1989 · N5769M · Substantial damageNTSB MIA89IA145Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Miami, FLFatigue failure of the left main landing gear trunnion. A contributing factor was: inadequate inspection procedure in Piper service bulletin #787A.May 6, 1989 · N859SC · Minor damageNTSB LAX89LA183Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Montague, CAThe pilot's failure to extend the landing gear because of inattention. Contributing to the accident was inadequate maintenance of the airplane which failed to repair the landing gear warning throttle position switch.May 6, 1989 · N550V · Substantial damageNTSB LAX89FA182Accident · 3 fatalField investigationFinal reportCessna 172 · Industry, CAThe failure of the pilot to maintain an adequate altitude to ensure obstruction clearance. Factors related to the accident were: darkness, low ceiling, fog, and the pilot's continued flight into adverse weather conditions.May 6, 1989 · N6129E · DestroyedNTSB LAX89FA181Accident · 2 fatalField investigationFinal reportCessna 152 · Port San Luis, CAPilot failed to execute a 180 degree turn and inadvertently entered into instrument meteorological conditions.May 6, 1989 · N6301M · Destroyed