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 CHI90FA055Accident · 3 fatalField investigationFinal reportBeech A24R · Merrill, WIFlight into known adverse weather by the pilot, and structural/wing ice. Factors related to the accident were: the icing conditions and trees in the area of the accident.Dec 28, 1989 · N37329 · DestroyedNTSB CHI90FA050Accident · 2 fatalField investigationFinal reportBeech 60 · Erie, PAThe pilot's failure to assure that the aircraft had an adequate supply of fuel on board for the intended flight. Contributing factors to the accident were an inoperative right fuel quantity gage which resulted in inaccurate fuel consumption calculations, and…Dec 28, 1989 · N478AD · DestroyedNTSB BFO90LA018Accident · No injuriesLimited investigationFinal reportBeech BE-24 · Martinsville, VAThe pilot failed to maintain adequate airspeed, causing the aircraft to stall and land hard.Dec 28, 1989 · N18733 · Substantial damageNTSB ANC90LA022Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKImproper compensation for wind conditions by the pilot, which resulted in loss of aircraft control during takeoff, and subsequent impact with the water. The weather conditions were contributing factors.Dec 28, 1989 · N67691 · Substantial damageNTSB NYC90LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · No. Andover, MAThe pilot inadvertently turned off the magneto switch during a go-around, resulting in a loss of power. Also causal to the accident was the failure of the pilot of a second airplane to respond to the tower controller's instructions. A factor related to the…Dec 27, 1989 · N9975Q · Substantial damageNTSB MIA90LA042Accident · 1 fatalLimited investigationFinal reportBoeing 727-225B · Miami, FLFatal injury to a stowaway due to asphyxia and hypothermia.Dec 27, 1989 · N822EA · No damageNTSB MIA90FA043Accident · Serious injuriesField investigationFinal reportTundermann Venne Q-2 · Zephyrhills, FLLoss of engine power for undetermined reasons.Dec 27, 1989 · N1UQ · DestroyedNTSB LAX90LA057Accident · Minor injuriesLimited investigationFinal reportBeech 33 · Gorman, CAThe malfunctioning propeller governor, and the pilot's misjudgement of altitude and distance of the approach path during an emergency landing. Factors contributing to the accident were: the power lines across the approach path to the runway and the…Dec 27, 1989 · N875R · Substantial damageNTSB FTW90LA047Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Stephenville, TXImproper planning/decision by the pilot.Dec 27, 1989 · N1691N · Substantial damageNTSB FTW90FA046Accident · Serious injuriesField investigationFinal reportBell 206L-1 · S Marsh Is 7The pilot's failure to recognize and correct a situation involving loss of tail rotor effectiveness, resulting in loss of aircraft control.Dec 27, 1989 · N3913S · DestroyedNTSB DEN90LA035Accident · No injuriesLimited investigationFinal reportCessna 172P · Billings, MTThe failure of the pilot to maintain directional control during adverse wind conditions.Dec 27, 1989 · N53432 · Substantial damageNTSB DCA90MA011Accident · 6 fatalClass 1 · MajorFinal reportBritish Aerospace BAE-3101 · Pasco, WAThe flightcrew's decision to continue an unstabilized instrument landing system (ILS) approach that led to a stall, most likely of the horizontal stabilizer, and loss of control at low altitude. Contributing to the accident was the air traffic controller's…Dec 27, 1989 · N410UE · DestroyedNTSB CHI90LA054Accident · No injuriesLimited investigationFinal reportBeech V35B · North Canton, OHContinued flight by the pilot into known adverse weather conditions, and his delay in diverting to an alternate airport, which resulted in accumulation of airframe icing. Factors related to the accident were: the adverse weather and runway/terrain conditions.Dec 27, 1989 · N2105L · Substantial damageNTSB ATL90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selmer, TNThe failure of the instructor to place the engine mixture control in the rich position prior to beginning traffic pattern maneuvers. As a result, the engine quit because of the lean fuel mixture at the high power setting required for the go-around and…Dec 27, 1989 · N2443K · Substantial damageNTSB NYC90FA041Accident · 3 fatalField investigationFinal reportCessna 172N · Washington Twp, NJThe failure of the pilot to properly pre-flight plan and execute the VFR flight. Factor's related to the accident were: the pilot's inexperience; no visual cues (lights) due to dark night conditions; the pilot's disregard of the weather briefing.Dec 26, 1989 · N3353E · DestroyedNTSB MIA90LA041Accident · No injuriesLimited investigationFinal reportCessna 150 · Orlando, FLThe pilot's loss of control of the aircraft due to a loss of consciousness brought on by reactive hypoglycemia.Dec 26, 1989 · N704SM · Substantial damageNTSB FTW90LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Minden, TXThe pilot's mismanagement of fuel by not maintaining an adequate supply of fuel.Dec 26, 1989 · N63391 · Substantial damageNTSB DEN90LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Firestone, COPremature liftoff by the pilot which resulted in insufficient airspeed.Dec 26, 1989 · N9570T · Substantial damageNTSB CHI90LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Middletown, OHThe inability to establish a sufficient climb after takeoff. Contributing to the accident was the pilot's lack of total experinece in this type of aircraft.Dec 26, 1989 · N65673 · Substantial damageNTSB CHI90LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · New Phila, OHThe pilot's failure to drain all of the trapped water from the fuel system prior to flight. Factors related to the accident were: the unfavorable wind condition and trees in the emergency landing area.Dec 26, 1989 · N59145 · Substantial damageNTSB ATL90LA039Accident · No injuriesLimited investigationFinal reportBeech B19 · Muscle Shoals, ALThe premature flare initiated by the student pilot and the flight instructor's delay in taking remedial action, which led to an inadvertent stall and a hard landing.Dec 26, 1989 · N6584R · Substantial damageNTSB SEA90LA031Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe pilots inadequate visual lookout while taxiing. Factors related to the accident are: the pilot's diverted attention and the pole.Dec 25, 1989 · N21543 · Substantial damageNTSB FTW90LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350B · Grand Prairie, TXManufacturer's failure to property install the left side components of the dual control system following its removal for additional completion work prior to delivery of the aircraft. Contributing to the accident was the failure of quality control personnel to…Dec 25, 1989 · N249HS · Substantial damageNTSB FTW90DQG01Accident · 1 fatalFinal reportSenior Aerosport/Paet PJ 260 · Hereford, TXThe pilot's failure to maintain adequate obstacle clearance on the approach to landing. A factor was the power pole just short of the end of the runway.Dec 25, 1989 · N260LP · DestroyedNTSB MIA90LA040Accident · No injuriesLimited investigationFinal reportMooney M20 · Fort Lauderdale, FLPartial loss of engine power for an unknown reason.Dec 24, 1989 · N6879N · DestroyedNTSB ATL90LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Danielsville, GAInadequate preflight preparation/planning by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Related factors were: a false fuel quantity indication, trees in the emergency landing area, and failure of the landing gear…Dec 24, 1989 · N5556P · Substantial damageNTSB LAX90LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Byron, CAThe pilot's failure to maintain sufficient terrain clearance altitude during a low altitude turn. Contributing to the accident was the pilot's poor judgement in conducting touch-and-go landings with a 700-foot ceiling.Dec 23, 1989 · N8218B · DestroyedNTSB LAX90LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Big Bear, CAThe pilot's improper level-off and improper recovery from a bounced landing.Dec 23, 1989 · N4111W · Substantial damageNTSB ANC90LA017Accident · No injuriesLimited investigationFinal reportBeech 18 · Brevig Mission, AKLoss of power in the the right engine for an unknown reason. The rough/uneven terrain was a contributing factor.Dec 23, 1989 · N220H · Substantial damageNTSB LAX90LA055Accident · No injuriesLimited investigationFinal reportBoeing 757-223 · Santa Ana, CAThe copilot's overrotation of the aircraft during the flare which allowed the tail to collide with the runway. The failure of the captain to take appropriate corrective action was a factor in the accident.Dec 22, 1989 · N611AM · Substantial damageNTSB ATL90LA043Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norcross, GAThe student pilot's improper execution of the landing procedure resulting in dynamic roll-over of the helicopter.Dec 22, 1989 · N75068 · Substantial damageNTSB ANC90LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKFailure of the non-certificated Pilot to remove ice/frost from the wing(s) prior to flight. His lack of training and qualification were probable contributing factors.Dec 22, 1989 · N8569D · Substantial damageNTSB ANC90FA021Accident · 1 fatalField investigationFinal reportPiper PA-31 · Beluga, AKFailure of the pilot to maintain proper altitude. Darkness and adverse weather conditions were related factors.Dec 22, 1989 · N302SC · DestroyedNTSB SEA90FA027Accident · 2 fatalField investigationFinal reportCessna 172N · Nordland, WAUndetermined.Dec 21, 1989 · N2228E · DestroyedNTSB NYC90FA040Accident · 1 fatalField investigationFinal reportPiper PA-60-602P · Frenchtown, NJThe inadequate maintenance and inspection of the turbocharger tailpipe exhaust stack on the right engine by the mechanic(s). The failure of the tailpipe permitted heat from the exhaust to weaken the main spar of the right wing resulting in a catastrophic…Dec 21, 1989 · N6894Y · DestroyedNTSB CHI90LA048Accident · No injuriesLimited investigationFinal reportCessna 310Q · Grand Rapids, MIThe undetermined engine compartment fire during the initial climbout. A factor was the failure of the pilot to shut off the fuel supply to the engine.Dec 20, 1989 · N117CC · Substantial damageNTSB ATL90LA042Accident · No injuriesLimited investigationFinal reportBell TH-1 · Creola, ALThe loss of engine power due to a #21 bearing failure. The bearing failed as a result of inadequate maintenance. A factor in the accident was the pilot operating the helicopter within the avoid operating envelope.Dec 20, 1989 · N106SR · Substantial damageNTSB LAX90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bumble Bee, AZThe failure of the student pilot to apply carburetor heat in a timely manner. Contributing to the accident were the carburetor icing conditions and the desert terrain.Dec 19, 1989 · N4101E · Substantial damageNTSB CHI90LA046Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lacrosse, WIThe student pilot's improper pre-flight planning/preparation, which did not include a plan to refuel the aircraft as necessary. The student pilot's lack of total experience contributed to this accident, as did the cfi's inadequate supervision of the student.Dec 18, 1989 · N704NP · Substantial damageNTSB CHI90LA045Accident · No injuriesLimited investigationFinal reportBeech 58P · Harrison, OHThe pilot misjudged his distance, speed, and altitude on final approach and failed to attain the proper touchdown. Factors related to the accident were: uneven (rising) terrain near the runway threshold and the runway light.Dec 18, 1989 · N6036S · Substantial damageNTSB CHI90DEE04Accident · No injuriesFinal reportCessna 172RG · Romeoville, ILDual student's inadequate compensation for wind conditions and remedial action not attained by the CFI. A factor related to the accident was: a snow bank adjacent the runway.Dec 18, 1989 · N9562B · Substantial damageNTSB MKC90FA038Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Lynch, NEAirspeed was not maintained by the pilot resulting in a stall/spin.Dec 17, 1989 · N6874H · DestroyedNTSB ATL90LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Nashville, NCA loss of engine power for undetermined reasons. A factor related to the accident was the ditch the airplane contacted.Dec 17, 1989 · N8EM · Substantial damageNTSB ATL90FA040Accident · 1 fatalField investigationFinal reportCessna 182 · Cincinnati, OHFailure of the Cessna pilot to remain clear of the helicopter after experiencing a partial power loss.Dec 17, 1989 · N8940T · 2 aircraft · Substantial damageNTSB SEA90FA030Accident · 1 fatalField investigationFinal reportCrawford-Gordon Thorp T-18 · Austin, NVAn improper major alteration performed by the pilot. As a result of this modification, the propeller failed in flight.Dec 16, 1989 · N111GC · DestroyedNTSB LAX90LA052Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Placerville, CAThe student pilot's failure to maintain directional control.Dec 16, 1989 · N3266M · Substantial damageNTSB DEN90FA033Accident · 2 fatalField investigationFinal reportBeech B35-A33 · Castle Rock, COThe pilot's loss of control as a result of spatial disorientation. Factors related to the accident were: the adverse weather conditions.Dec 16, 1989 · N477T · DestroyedNTSB BFO90FA012Accident · No injuriesField investigationFinal reportBritish Aerospace BAE 3101 · Staunton, VAThe pilot's failure to properly align the airplane with the runway heading during the takeoff run. Factors related to the accident were: airport personnel's failure to assure that runway marking and edge lights were adequately cleared of snow, adverse…Dec 16, 1989 · N851JS · Substantial damageNTSB NYC90FA039Accident · 6 fatalField investigationFinal reportPiper PA-31-350 · Cairo Township, NYThe pilot's decision to fly into the known adverse weather and his failure to select an altitude that would provide terrain clearance. Factors were: the adverse weather and the pilot's disregard for the forecasted conditions.Dec 15, 1989 · N45CH · DestroyedNTSB MIA90IA039Incident · No injuriesIncident investigationFinal reportBoeing 727 · Ormond Beach, FLFailure of the pilot in command in the Beech 300 to comply with an ATC clearance in a timely manner, while diverting his attention, and failure of the ATC controller to assure that IFR separation was maintained.Dec 15, 1989 · N64339 · 2 aircraft · No damage