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 LAX89LA150Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZImproper use of the elevator flight control by the pilot and his failure to maintain a proper rate of climb after lift-off. Contributing factors were: improper use of elevator trim by the pilot, his lack of total experience, and an inadvertent porpoise.Apr 6, 1989 · N248ER · Substantial damageNTSB FTW89LA086Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Lampasas, TXThe pilot's failure to follow proper procedures and directives for the attempted operation. A factor was the undetermined status of the magnetos.Apr 6, 1989 · N17513 · Substantial damageNTSB CHI89FA069Accident · 2 fatalField investigationFinal reportCessna 150M · Kankakee, ILFailure of the instructor pilot (CFI) to maintain control of the aircraft and his failure to maintain sufficient altitude above the ground.Apr 6, 1989 · N3892V · DestroyedNTSB BFO89FA029Accident · 4 fatalField investigationFinal reportBeech C35 · Rupert, WVPilot inadvertantly flew into IMC while trying to maintain VFR and collided with trees during a steep turn during his attempt to turn away from IMC. The weather conditions that were determined to be factors in this accident were: low ceilings, obscuration,…Apr 6, 1989 · N9502C · DestroyedNTSB ATL89FA122Accident · 1 fatalField investigationFinal reportCessna 182 · Luthersville, GAPilot's failure to take action that would prevent the formation of carburetor ice. Following the engine malfunction, the pilot did not configure the airplane so as to reduce the severity of the impact, I.e. extend the flaps and slow the airplane. Contributing…Apr 6, 1989 · N5458B · DestroyedNTSB LAX89DUJ06Accident · 1 fatalFinal reportMurphy VARI-EZE · Parker, AZUndetermined.Apr 5, 1989 · N8494J · DestroyedNTSB FTW89FA075Accident · No injuriesField investigationFinal reportBell 206B · West CameronInadequate maintenance/inspection of the aircraft fuel system by company maintenance personnel and fuel contamination, which resulted in a partial loss of engine power. Related factors were: a binding (stuck) fuel filter cap bypass valve and partial failure…Apr 5, 1989 · N5004L · Substantial damageNTSB DEN89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Los Lunas, NMInadequate preflight by the pilot, which resulted in fuel exaustion from an inadequate supply of fuel. Factors related to the accident were: false fuel quantity indication, hard landing by the pilot, and uneven terrain conditions.Apr 5, 1989 · N1672M · Substantial damageNTSB DEN89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Cheyenne, WYFailure of the pilot-in-command to properly recover from a bounced landing.Apr 5, 1989 · N83864 · Substantial damageNTSB DEN89LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Devils Lake, NDInadequate compensation for wind conditions by the pilot, which resulted in loss of directional control and an inadvertent ground loop/swerve. Contributing factors were: the crosswind and the pilot's lack of familiarity with the aircraft.Apr 5, 1989 · N7523K · Substantial damageNTSB DEN89FA149Accident · 1 fatalField investigationFinal reportCessna 182P · Steamboat Sprg., COThe plt's failure to discontinue the VFR flight when he encountered IMC; and the plt's failure to maintain adequate altitude to clear the mountainous terrain.Apr 5, 1989 · N7248N · DestroyedNTSB DEN89FA101Accident · No injuriesField investigationFinal reportBell 206B-III · Park City, UTAn encounter with strong down-slope winds and gusts during a critiacal phase of flight which caused power required to exceed power available. Contributing factors to the accident was the downhill terrain and the downdraft conditions.Apr 5, 1989 · N16733 · Substantial damageNTSB ATL89LA121Accident · Minor injuriesLimited investigationFinal reportAero Commander 685 · Southern Pines, NCThe pilot's improper use of the mixture controls which resulted in engine roughness and the failure to properly execute the emergency procedure for a rough engine by placing the fuel boost pump switch in the low position.Apr 5, 1989 · N685RB · Substantial damageNTSB LAX89LA147Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Salinas, CAThe pilot's failure to maintain proper taxiway alignment, when he diverted his attention, while taxiing. The location of the parked aircraft was a related factor.Apr 4, 1989 · N59973 · Substantial damageNTSB CHI89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chicago, ILThe pilot's failure to compensate for the crosswind condition which existed during the landing. Contributing to the accident was the gusty, crosswind which existed and the failure of the aircraft manufacturer to provide crosswind performance data for the…Apr 4, 1989 · N2944P · Substantial damageNTSB ANC89GA055Accident · Minor injuriesFinal reportPiper PA-18 · Kotzebue, AKThe pilot continued flight into IFR conditions and failed to maintain the altitude. Contributing to the accident was the pilot's failure to obtain a weather briefing and the deteriorating weather conditions which were encountered.Apr 4, 1989 · N7085 · Substantial damageNTSB ANC89FA057Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Eklutna, AKThe pilot diverted his attention and failed to maintain adequate airspeed, which resulted in an inadvertent stall.Apr 4, 1989 · N86836 · DestroyedNTSB ANC89FA056Accident · No injuriesField investigationFinal reportPiper PA-18 · Chugiak, AKCarburetor ice due to the pilot's improper use of powerplant controls; and failure of the pilot to maintain adequate airspeed, while maneuvering (turning left), which resulted in an inadvertent stall. Factors related to the accident were: failure of the pilot…Apr 4, 1989 · N8677C · Substantial damageNTSB NYC89LA112Accident · No injuriesLimited investigationFinal reportChampion 8KCAB · Manchester, NHThe loss of control and collision with a parked aircraft due to the inadvertent application of the throttle that took place as the pilot was fastening the over the shoulder safety harness while warming the engine in preparation for departure.Apr 3, 1989 · N2520Z · Substantial damageNTSB LAX89LA144Accident · Serious injuriesLimited investigationFinal reportBoeing 767-201 · Los Angeles, CAThe first officer did not properly evacuate the airplane.Apr 3, 1989 · N645US · No damageNTSB DEN89LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Alamosa, COFatigue failure of the engine crankshaft. A factor related to the accident was: the terrain condition in the emergency landing area.Apr 3, 1989 · N48DL · Substantial damageNTSB BFO89LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Odenton, MDThe inflight collision with birds.Apr 3, 1989 · N8027L · Substantial damageNTSB SEA89GA064Accident · Minor injuriesFinal reportCessna 172P · Hawthorne, NVThe failure of the pilot to maintain flying speed and proper flying attitude resulting in a stall mush. Contributing to the accident were the density altitude and the variable winds.Apr 2, 1989 · N99713 · DestroyedNTSB MKC89DCJ02Accident · 1 fatalFinal reportSchmahl Volksplane VP-1 · Papillion, NEThe pilot failed to maintain the proper climb rate and inadvertently stalled the aircraft which entered an uncontrolled descent into an open field.Apr 2, 1989 · N81VP · DestroyedNTSB MIA89LA121Accident · No injuriesLimited investigationFinal reportCessna 340A · West Palm Beach, FLFailure of the right main landing gear bellcrank assembly due to binding and inadequate maintenance lubrication.Apr 2, 1989 · N4273C · Substantial damageNTSB MIA89LA120Accident · No injuriesLimited investigationFinal reportCessna 172M · Columbia, MSThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. A factor related to the accident was: the gusty/crosswind condition.Apr 2, 1989 · N80436 · Substantial damageNTSB LAX89DVA04Accident · Minor injuriesFinal reportLowe Quickie Q-200 · Hanford, CAThe pilot misjudged his altitude & distance to the runway, while on final approach, which resulted in an undershoot of the runway. A factor related to the accident was the fence.Apr 2, 1989 · N26PL · Substantial damageNTSB LAX89DUQ03Accident · No injuriesFinal reportMartin Sorrell Hiperlight · Liano, CAEngine failure due to a seized piston.Apr 2, 1989 · N85HL · Substantial damageNTSB CHI89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Allegan, MIImproper use of flight controls by the student pilot, which resulted in his loss of directional control and an inadvertent ground swerve; and the instructor pilot's (cfi's) inadequate supervision. Factors related to the accident were: the crosswind condition,…Apr 2, 1989 · N9504T · Substantial damageNTSB CHI89LA066Accident · No injuriesLimited investigationFinal reportCessna 170B · Freedom, WIThe pilot's failure to maintain directional control during the attempted takeoff on unsuitable terrain. The pilot's lack of recent flight experience was a contributing factor.Apr 2, 1989 · N3016A · Substantial damageNTSB MIA89WA123Accident · 1 fatalForeign investigationCessna 421B · Great Harbor, BahamasApr 1, 1989 · N4470L · DestroyedNTSB LAX89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lancaster, CAImproper planning/decision by the pilot. Strong/gusty winds contributed to the accident.Apr 1, 1989 · N3508Z · Substantial damageNTSB LAX89LA145Accident · No injuriesLimited investigationFinal reportLet L-13 · Hemet, CAInadequate crew coordination between the ground lineman and the blanik pilot, and failure of the blanik pilot to maintain clearance between his aircraft and the parked glider. A factor related to the accident was the proximity of the parked glider to the…Apr 1, 1989 · N82756 · Substantial damageNTSB LAX89LA143Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Bermuda Dunes, CAImproper assistance by ground personnel who inadvertently overloaded the airplane and the pilot's delay in jettisoning the load.Apr 1, 1989 · N61315 · Substantial damageNTSB LAX89LA142Accident · No injuriesLimited investigationFinal reportBeech C24R · Tucson, AZPilot misjudged the landing. The pilot began his flare too high above the runway resulting in a hard landing.Apr 1, 1989 · N23972 · Substantial damageNTSB FTW89LA077Accident · No injuriesLimited investigationFinal reportGulfstream 680FLP · Lohn, TXArson undertaken to conceal illegal activity.Apr 1, 1989 · N721F · DestroyedNTSB ATL89LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Bowling Green, OHThe student pilot failed to maintain control of the aircraft when he misjudged the height of the landing flare. The recovery from the bounced landing was inadequate and the nose gear collapsed upon impact with the runway.Apr 1, 1989 · N1044Z · Substantial damageNTSB ATL89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe pilot's failure to properly plan required fuel for this flight which resulting in fuel exhaustion and a forced landing in a field.Apr 1, 1989 · N6475Q · Substantial damageNTSB SEA89LA063Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sitka, AKThe pilot's continuing the takeoff despite the large boat wake and gusting wind. A contributing factor was the pilot's low flight time in this type of aircraft.Mar 31, 1989 · N9182L · Substantial damageNTSB NYC89FA111Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-35 · Syracuse, NYFailure of the crew of brockway flight 993 to see-and-avoid the other aircraft due to the first officer's inadequate visual lookout & the captain's inadequate supervision. Factors related to the accident were: the weather condition, and the ground…Mar 31, 1989 · N638MA · 2 aircraft · Substantial damageNTSB MIA89LA119Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Stuart, FLInadequate visual lookout by both the pilot of the Boeing E75N1 and the person running up the OV-1 (their failure to see each other and avoid the occurrence).Mar 31, 1989 · N53549 · Substantial damageNTSB LAX89LA149Accident · No injuriesLimited investigationFinal reportCessna 182Q · Eureka, CAThe pilot's improper flare during the landing.Mar 31, 1989 · N96642 · Substantial damageNTSB LAX89LA141Accident · No injuriesLimited investigationFinal reportHughes 369D · Vallejo, CAFatigue failure of a defective pc tube assembly resulting in a loss of engine power. A contributing factor was the unsuitable terrain.Mar 31, 1989 · N5108E · Substantial damageNTSB LAX89FA140Accident · 5 fatalField investigationFinal reportPiper PA-60-601P · Newport Beach, CAFailure of the pilot to attain adequate airspeed before maneuvering (turning) back toward the airport, which resulted in a loss of aircraft control. A factor related to the accident was: improper maintenance/installation of a fuel injector reference air line,…Mar 31, 1989 · CGWPS · DestroyedNTSB DEN89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Garrison, NDImproper flare by the student and inadequate supervision of the flight by the CFI which damaged the nose gear and restricted movement of the nosewheel steering and rudder control.Mar 31, 1989 · N6071K · Substantial damageNTSB CHI89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Monee, ILInadequate maintenance/inspection of the aircraft after metal fragments were found in the oil, and worn cam lobes/followers/piston pin plugs, which resulted in oil contamination, restriction (blockage) in the oil system, oil starvation, and subsequent engine…Mar 31, 1989 · N55191 · Substantial damageNTSB SEA89LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Tacoma, WAThe pilot's improper flare and improper recovery from the bounced landing. Contributing factors were the pilot's low total flight time and his inexperience in the Cessna 180 airplane.Mar 30, 1989 · N2936C · Substantial damageNTSB LAX89LA309Accident · No injuriesLimited investigationFinal reportHughes 269C · Mesa, AZImproper flare by the student pilot, and improper supervision by the instructor pilot (CFI).Mar 30, 1989 · N58164 · Substantial damageNTSB FTW89LA076Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Abilene, TXThe collapse of the nose gear during a forced landing following fuel exhaustion during the descent into the destination airport.Mar 30, 1989 · N3313T · Substantial damageNTSB ATL89DKG02Accident · Minor injuriesFinal reportCessna A188B · Statesboro, GAImproper inflight planning which allowed the engine to lose power due to fuel exhaustion.Mar 30, 1989 · N9583G · Substantial damage