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 FTW89LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Conroe, TXFailure of the engine crankshaft due to fatigue. The low ceiling, dark night, and trees in the emergency landing area were factors.Feb 17, 1989 · N3976W · Substantial damageNTSB ATL89LA089Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wilmington, OHThe failure of the pilot to adequately compensate for wind conditions, to maintain proper runway alignment, and his delay in aborting the landing. Contributing factors were: variable crosswind conditions and a small tree.Feb 17, 1989 · N739US · Substantial damageNTSB MIA89LA086Accident · No injuriesLimited investigationFinal reportAero Commander 500U · Daytona Beach, FLControl malfunction of undetermined cause that made further flight inadvisable.Feb 16, 1989 · N1010U · Substantial damageNTSB ATL89FA088Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Jackson, GAThe pilot's improper handling of the airplane which resulted in an inadvertent stall/spin and subsequent collision with terrain. Factors contributing to the accident were the pilot's decision to perform aerobatic maneuvers at low altitude, and complacency…Feb 16, 1989 · N4126Y · DestroyedNTSB SEA89LA049Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Beaver Marsh, ORAn loss of engine power due to a failed exhaust valve. Contributing to the accident was the snow covered terrain on which a precautionary landing was made.Feb 15, 1989 · N95286 · Substantial damageNTSB NYC89IA084Incident · No injuriesIncident investigationFinal reportBeech 200 · Burlington, VTImproper preflight which resulted in a frozen elevator surface.Feb 15, 1989 · N123D · No damageNTSB NYC89FA085Accident · Serious injuriesField investigationFinal reportDassault/Sud FAN JET Falcon D · Binghamton, NYImproper planning/decision by the pilot(s). Factors related to the accident were: icy runway conditions and failure of the drag chute to properly open after it was deployed.Feb 15, 1989 · N232RA · Substantial damageNTSB LAX89LA117Accident · No injuriesLimited investigationFinal reportCessna 182C · Adalanto, CAThe pilot was inattentive, did not maintain proper alignment with the runway and did not maintain an adequate visual lookout during takeoff.Feb 15, 1989 · N8923T · Substantial damageNTSB LAX89FA111Accident · 1 fatalField investigationFinal reportCessna 340A · Safford, AZThe pilot's poor judgement and the resultant hypoxia sustained in the unpressurized airplane. Factors were: the malfunctioning pressurization system and the pilot's decision to continue operation with that known discrepancy.Feb 15, 1989 · N8814K · DestroyedNTSB ANC89LA044Accident · No injuriesLimited investigationFinal reportPiper J-5 · Skwentna, AKThe pilot's selection of unsuitable terrain. A contributing factor is the pilot's lack of experience in off airport landings.Feb 15, 1989 · N35038 · Substantial damageNTSB MIA89LA085Accident · No injuriesLimited investigationFinal reportCessna 340A · Jacksonville, FLSeizure of the right main landing gear upper downlock top bushing, and the failure of other maintenance personnel to properly rig the landing gear down light micro switches.Feb 14, 1989 · N5454X · Substantial damageNTSB LAX89LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Pacific Ocean (Pacific Ocean)Loss of oil pressure due to unknown circumstances. Contributing to the cause of the accident was the overweight condition of the airplane necessitated by overwater fuel requirements.Feb 14, 1989 · N41169 · DestroyedNTSB LAX89LA108Accident · No injuriesLimited investigationFinal reportMooney M20J · San Martin, CAFailure of the student to follow instructions and inadequate supervision of the flight by the CFI which resulted in adequate airspeed not being maintained by the CFI. During an attempted go-around.Feb 14, 1989 · N5726M · Substantial damageNTSB LAX89IA112Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Los Alamitos, CAInadequate coordination among the ATC controllers which resulted in their failure to maintain adequate radar separation of the two aircraft.Feb 14, 1989 · N141AC · No damageNTSB FTW89LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Seminole, TXThe pilot's delay in updating his weather and diverting to an alternate destination, which resulted in fuel exhaustion from lack of fuel. Contributing factors were: the pilot's inadequate preflight planning/preparation at the en route stop, the weather…Feb 14, 1989 · N5258L · Substantial damageNTSB FTW89FA049Accident · 3 fatalField investigationFinal reportMBB BK-117 A-1 · Tyler, TXThe pilot's failure to execute the published inadvertent IMC procedures when he encountered adverse weather conditions.Feb 14, 1989 · N7025L · DestroyedNTSB DEN89LA077Accident · No injuriesLimited investigationFinal reportBalloon Works AX8-24 · Telluride, COIce forming in the fuel tank shut off valve, and the burner blast valve resulting in a loss of control during landing.Feb 14, 1989 · N7127J · Substantial damageNTSB MKC89LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNPremature raising of flaps and the failure of the instructor pilot to maintain runway alignment during the attempted go around.Feb 13, 1989 · N95975 · Substantial damageNTSB LAX89LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Sacramento, CAThe pilot's selection of the wrong runway for landing and his delay in initiating a go-around after landing long. Contributing factors were: light conditions as dusk and a tailwind.Feb 13, 1989 · N73309 · Substantial damageNTSB LAX89LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · Green Valley, AZThe student pilot displayed poor judgement in not maintaining proper altitude. A factor contributing to the accident was the pilot's overall lack of experience.Feb 12, 1989 · N5496B · Substantial damageNTSB LAX89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZThe pilot's failure to raise the wing flaps during the aborted landing, and his failure to maintain airspeed during the climbing right turn.Feb 12, 1989 · N3388E · DestroyedNTSB LAX89FA106Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Julian, CAThe pilot's poor judgement of intentionally flying into an area of known forecast icing conditions which resulted in a loss of control and an inflight breakup of the aircraft. Contributing factors were the pilot's overconfidence in his personal ability by…Feb 12, 1989 · N9240P · DestroyedNTSB CHI89LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Stevens Point, WIFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve.Feb 12, 1989 · N16TP · Substantial damageNTSB ATL89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Huntersville, NCFire resulting from an oil leak of undetermined origin in the area of the left engine.Feb 12, 1989 · N5112Y · DestroyedNTSB ATL89FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Jasper, TNThe pilot's improper handling of the airplane flight controls at low altitude which resulted in an excessive rate of descent and collision with a tree.Feb 12, 1989 · N588FL · DestroyedNTSB NYC89LA083Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Yarmouth, MAA loss of engine power and subsequent forced landing which resulted from binding of the carbuerator throttle shaft. The binding resulted from an improper overhaul of the carbuertor approximately 10 flight hours prior to the accident.Feb 11, 1989 · N38529 · DestroyedNTSB NYC89FA080Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Lyon Mountain, NYThe pilot decided to fly in weather conditions that were beyond his and the aircraft's capabilities.Feb 11, 1989 · CGBHN · DestroyedNTSB MKC89LA057Accident · No injuriesLimited investigationFinal reportCessna 150 · Wayland, MOThe pilot becoming lost during the flight which resulted in fuel exhaustion.Feb 11, 1989 · N61064 · Substantial damageNTSB MIA89LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · San Juan, PRThe failure of the pilot to properly use carburetor heat in conditions conducive to the formation of carburetor ice.Feb 11, 1989 · N303CR · Substantial damageNTSB FTW89LA048Accident · Serious injuriesLimited investigationFinal reportPitts S2B · Walker, LALoss of total engine power due to fuel exhaustion. Fuel exhaustion occurred due to the pilot's failure to perform fuel consumption calculations. Contributing was the inadequate fuel quanity sight gauge in the rear cockpit, which was occupied by the PIC.Feb 11, 1989 · N11SE · DestroyedNTSB DEN89FA076Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Saint George, UTMalfunction of the nosewheel steering system due to improper installation of the nosewheel steering poppet valve & inadequate maintenance instructions.Feb 11, 1989 · N1010Z · Substantial damageNTSB CHI89LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Baldwin, WIFailure of the pilot to go around when he landed long with too much speed for the conditions. Factors related to the accident were: the pilot's excessive airspeed, his failure to attain the proper touchdown point, the crosswind, snowy/icy runway conditions,…Feb 11, 1989 · N4028D · Substantial damageNTSB ATL89LA085Accident · No injuriesLimited investigationFinal reportCessna 177B · Oneonta, ALInadequate preflight by the pilot and fuel exhaustion. Trees contributed to the aircraft damage.Feb 11, 1989 · N34306 · DestroyedNTSB NYC89LA082Accident · No injuriesLimited investigationFinal reportCessna R172K · Ballston Spa, NYWorn connecting rod bearing(s), and failure of the #1 connecting rod. A factor related to the accident was: the lack of suitable terrain for an emergency landing.Feb 10, 1989 · N758PW · Substantial damageNTSB MIA89LA083Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fernandina Bch, FLLocking of the left brake, which resulted in a ground swerve and loss of control during the landing roll.Feb 10, 1989 · N926SA · Substantial damageNTSB ATL89DKG01Accident · No injuriesFinal reportGrumman G-164A · Dawson, GATotal loss of engine power due to leaking carburetor float. Contributing to the accident was the soft terrain used for a forced landing.Feb 10, 1989 · N9755 · Substantial damageNTSB ANC89FA043Accident · No injuriesField investigationFinal reportde Havilland DHC-3 · Fairbanks, AKFailure of the pilot to remove frost from the aircraft. Contributing factors were: improper weight and balance and snow covered terrain.Feb 10, 1989 · N5056Q · Substantial damageNTSB LAX89FA103Accident · Minor injuriesField investigationFinal reportCessna 150K · Honolulu, HIInadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…Feb 9, 1989 · N6149G · 2 aircraft · Substantial damageNTSB FTW89MA047Accident · 1 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-32F · Salt Lake City, UTImproper in-flight planning/decision by the captain (pilot-in-command) and his improper use of the portable oxygen system, which resulted in his incapacitation due to hypoxia. Factors related to the accident were: inadequate maintenance/inspection of the…Feb 9, 1989 · N935F · No damageNTSB DEN89LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Gill, COImproper use of the powerplant controls by the CFI during descent through low temperature air.Feb 9, 1989 · N69117 · Substantial damageNTSB ATL89FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 310Q · Cleveland, OHAn uncontrolled descent into the water for undetermined reasons.Feb 9, 1989 · N6269Q · DestroyedNTSB ANC89FA042Accident · Serious injuriesField investigationFinal reportCessna 207 · Nome, AKThe partial loss of power resulting from fuel interruption due to a blockage in the engine fuel pump low pressure check valve.Feb 9, 1989 · N73771 · Substantial damageNTSB ANC89FA041Accident · 1 fatalField investigationFinal reportCessna U206G · Fairbanks, AKSeparation of the torsional vibration dampers from the crankshaft boss.Feb 9, 1989 · N756EA · DestroyedNTSB SEA89LA048Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cottonwood, IDThe pilot misjudging his altitude due to the white out conditions. Contributing to the accident was the pilots lack of experience in this aircraft and this type of operation.Feb 8, 1989 · N5620X · Substantial damageNTSB MIA89LA081Accident · No injuriesLimited investigationFinal reportBell TH-1L · Greenville, FLInstallation of the improper sprag clutch assembly by the owners maintenance personnel resulting in failure of the sprag clutch and the loss of transmission drive.Feb 8, 1989 · N204AP · Substantial damageNTSB MIA89GA082Accident · Minor injuriesFinal reportCessna T210L · Melbourne, FLFailure of the pilot to accurately determine fuel quantity prior to departure followed by his failure to operate the engine on the fullest fuel tank resulting in a fuel tank being run dry resulting in engine failure while on short final approach at his…Feb 8, 1989 · N81859 · Substantial damageNTSB LAX89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Flagstaff, AZThe pilot's failure to maintain proper runway alignment while expediting to exit the runway. His lack of experience in this type of aircraft, self-induced pressure & the snow covered terrain were contributing factors.Feb 8, 1989 · N9007S · Substantial damageNTSB DEN89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COFailure of the dual student to maintain directional control and the failure of the pilot in command (CFI), to provide adequate remedial action in a timely manner, to correct the swerve. A second probable cause was the cfi's failure to provide adequate…Feb 8, 1989 · N4355Z · Substantial damageNTSB DCA89RA023Accident · 144 fatalForeign investigationBoeing 707 · Santa Maria, PortugalFeb 8, 1989 · N7231TNTSB CHI89FA049Accident · 3 fatalField investigationFinal reportCessna 172RG · Mosinee, WISpatial disorientation of the pilot as a result of initiating the flight into known adverse weather. Factors related to the accident were: dark night, snow, and low ceilings.Feb 8, 1989 · N6525V · Destroyed