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 LAX98LA139Accident · No injuriesLimited investigationFinal reportBell 206B · Grand Canyon, AZThe malfunction and erratic speed control of the engine's governor, and the flight instructor's delayed remedial action.Apr 20, 1998 · N8533F · Substantial damageNTSB DCA98RA036Accident · 52 fatalForeign investigationBoeing 727-200 · Bogota, ColombiaApr 20, 1998 · HCBRINTSB DCA98IA035Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300-600 · Atlantic Ocean (Atlantic Ocean)Malfunction of the primary navigation system for undetermined reasons.Apr 20, 1998 · N33069NTSB CHI98LA133Accident · No injuriesLimited investigationFinal reportMaule MXT-7-108A · Orland, INthe pilot's misjudged landing flare and improper recovery from a bounced landing.Apr 20, 1998 · N327PF · Substantial damageNTSB CHI98LA127Accident · Serious injuriesLimited investigationFinal reportBoeing 727-227 · Chicago, ILthe passenger initiated evacuation of the airplane. A factor was the auxiliary power unit fire.Apr 20, 1998 · N722AA · Minor damageNTSB CHI98FA130Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Kalamazoo, MIThe pilot's failure to maintain adequate flying airspeed resulting in a stall condition. Contributing factors were the tailwind condition and the pilot's exceeding the gross weight of the airplane on takeoff.Apr 20, 1998 · N1762J · DestroyedNTSB NYC98LA096Accident · No injuriesLimited investigationFinal reportBeech C-50 · Ford, VAA loss of engine power simultaneously on both engines as reported by the pilot, for undetermined reasons.Apr 19, 1998 · N377B · Substantial damageNTSB MIA98LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Lumber Bridge, NCThe pilot's delay in aborting a takeoff from a wet grass runway.Apr 19, 1998 · N63582 · Substantial damageNTSB MIA98FA135Accident · 2 fatalField investigationFinal reportBoeing A-75N1 · Kissimmee, FLFailure of the number 2 pilot to maintain visual contact and/or proper position/clearance from other aircraft.Apr 19, 1998 · N806RB · 2 aircraft · DestroyedNTSB FTW98LA188Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe pilot inadvertently stalling the aircraft during the landing touchdown. Factors were a crosswind and the pilot's lack of total flight experience.Apr 19, 1998 · N6174K · Substantial damageNTSB FTW98FA186Accident · 2 fatalField investigationFinal reportFoster/Hilsman Q2 · Siloam Springs, ARThe pilot's failure to maintain aircraft control during the forced landing. Factors were the failure of the #4 cylinder head which resulted in a partial loss of engine power and the co-owners/builders' failure to perform a condition inspection of the…Apr 19, 1998 · N996DT · DestroyedNTSB CHI98LA129Accident · 1 fatalLimited investigationFinal reportGood Velocity · Romulus, MIimproper planning/decision by the pilot, by using the airplane in an illegal activity and allowing the fuel to be exhausted before landing. Factors relating to this accident were: the pilot being under pressure to reach his destination with his illegal cargo,…Apr 19, 1998 · N234Q · DestroyedNTSB NYC98FA094Accident · Serious injuriesField investigationFinal reportBoeing 747-200 · Atlantic Ocean (Atlantic Ocean)The injured passengers failure to follow the directions to fasten their seat belts, prior to an encounter with clear air turbulence.Apr 18, 1998 · N623FF · Minor damageNTSB LAX98LA138Accident · No injuriesLimited investigationFinal reportPorat RAF-200 · Hollister, CAThe failure of the pilot to maintain control of the aircraft. A factor in this accident is the pilot's lack of experience in type aircraft.Apr 18, 1998 · N313EP · Substantial damageNTSB LAX98LA137Accident · No injuriesLimited investigationFinal reportGrumman American AA5B · Aguanga, CAthe lack of available published information regarding obstructions and nonstandard lighting at the private airport, and the lack of a lighted and properly marked displaced threshold.Apr 18, 1998 · N28565 · Substantial damageNTSB LAX98LA136Accident · Minor injuriesLimited investigationFinal reportBeech M35 · North Las Vegas, NVfuel starvation due to the pilot's improper fuel management and his failure to select the fullest tank for landing.Apr 18, 1998 · N9703R · Substantial damageNTSB CHI98LA131Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Canton, MIThe undetermined loss of power reported by the pilot. Contributing factors were the residential nature of the landing area and unsuitable landing terrain.Apr 18, 1998 · N50566 · Substantial damageNTSB ATL98LA064Accident · No injuriesLimited investigationFinal reportDennis L. Long Pitts S-2A · Daytona Beach, FLThe pilot's failure to maintain directional control during an attempted takeoff. A factor was the reported crosswind condition.Apr 18, 1998 · N60DL · Substantial damageNTSB ATL98LA062Accident · No injuriesLimited investigationFinal reportStewart 51 S-51D · Vero Beach, FLThe maintenance personnel failure to remove a plastic plug from the oil tank breather that resulted in the rupture of the engine oil tank. Factors were, a tailwind during the emergency landing, and a ditch on the departure end of the runway.Apr 18, 1998 · N51S · Substantial damageNTSB ANC98LA039Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Chugiak, AKThe pilot's selection of an unsuitable, slush-covered, runway for landing. A factor was the slush-covered runway.Apr 18, 1998 · N134C · Substantial damageNTSB FTW98LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Cameron, LAThe loss of engine power for undetermined reasons and the pilot's improper flare which resulted in a hard landing.Apr 17, 1998 · N59604 · Substantial damageNTSB FTW98FA185Accident · 2 fatalField investigationFinal reportYoung Glasair III · St. Martinville, LAThe pilot's failure to maintain control of the aircraft as a result of VFR flight into instrument meteorological conditions and flight into known adverse weather conditions. Contributing factors were turbulence, clouds, dark night and lack of an instrument…Apr 17, 1998 · N238BC · DestroyedNTSB CHI98LA132Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tecumseh, MIThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control. A contributing factors were wind gusts and crosswind.Apr 17, 1998 · N97876 · Substantial damageNTSB CHI98LA128Accident · Minor injuriesLimited investigationFinal reportJaeger Sonerai II-L · Bicknell, INThe pilot misjudged his altitude and airspeed during an emergency landing attempt. Factors associated with this accident were a manufacturing defect in the magneto drive coupling and a total failure of the ignition system.Apr 17, 1998 · N247RJ · DestroyedNTSB ATL98FA063Accident · 2 fatalField investigationFinal reportWilliam Sargent Lancair 235 · Newport, TNThe pilot's attempt to operate in instrument meteorological conditions and his failure to maintain clearance with the surrounding terrain. Contributing factors were clouds and the mountainous/hilly terrain.Apr 17, 1998 · N813Y · DestroyedNTSB MIA98LA134Accident · No injuriesLimited investigationFinal reportAmerican Blimp A-1-50 · Quincy, FLThe pilot-in-command's and groundcrew chief's failure to properly evaluate wind conditions prior to attempting to moor the blimp.Apr 16, 1998 · N151LG · Substantial damageNTSB FTW98LA183Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Castle Rock, COMalfunction of the engine-driven fuel pump. Factors were unsuitable terrain, soft ground, and a berm.Apr 16, 1998 · N5693D · Substantial damageNTSB MIA98LA133Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Miami Lakes, FLThe failure of the pilot to ensure the aircraft contained enough fuel to complete the flight resulting in loss of engine power due to fuel exhaustion.Apr 15, 1998 · N46SX · Substantial damageNTSB CHI98FA123Accident · 1 fatalField investigationFinal reportCessna 180J · Ashland, WIthe pilot failing to maintain separation from the trees. Factors contributing to this accident were the trees and the pilot being too low in altitude.Apr 15, 1998 · N828CE · DestroyedNTSB ANC98LA038Accident · No injuriesLimited investigationFinal reportGrumman G-21 · Dutch Harbor, AKThe pilot-in-command's failure to identify the swells prior to landing. A factor was the water swells.Apr 15, 1998 · N22932 · Substantial damageNTSB MIA98LA132Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesboro, TNThe student pilot's improper flare during landing.Apr 14, 1998 · N704HL · Substantial damageNTSB FTW98LA184Accident · No injuriesLimited investigationFinal reportCessna 182N · Albuquerque, NMThe pilot's failure to attain the proper touchdown point during landing, resulting in an overrun, and his exceeding the airplane's maximum crosswind component. A factor was the gusty crosswind.Apr 14, 1998 · N9008G · Substantial damageNTSB DCA98WA072Incident · No injuriesForeign investigationBeech 200 Super King AIR · FranceApr 14, 1998 · F-GHC · Minor damageNTSB CHI98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Barrington Hill, ILThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent in-flight collision with trees.Apr 14, 1998 · N6300E · Substantial damageNTSB NYC98GA093Accident · No injuriesFinal reportMcDonnell Douglas 500E · Columbus, OHloss of engine power for undetermined reason(s). Related factors were: lack of suitable terrain for an emergency landing; and high obstructions in the forced landing area.Apr 13, 1998 · N551CP · Substantial damageNTSB FTW98LA182Accident · No injuriesLimited investigationFinal reportFroberg Rotorway Executive · Sand Springs, OKThe failure of the owner/pilot to complete maintenance on the helicopter.Apr 13, 1998 · N71RF · DestroyedNTSB CHI98LA125Accident · No injuriesLimited investigationFinal reportBeech B35 · Bentonville, ARthe damage to the empennage was due to flutter.Apr 13, 1998 · N5246C · Substantial damageNTSB MIA98WA131Accident · No injuriesForeign investigationPiper PA-32R-300 · Dolo Odo, EthiopiaApr 12, 1998 · N2SX · Substantial damageNTSB IAD98LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · New Castle, VAThe pilot's failure to maintain adequate airspeed during the turn to reverse direction. A factor was his improper use of the speed brake.Apr 12, 1998 · N55BR · Substantial damageNTSB IAD98LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Stevensville, MDthe pilot's improper flare, improper recover from a bounced landing, and failure to maintain directional control.Apr 12, 1998 · N734MN · Substantial damageNTSB IAD98FA044Accident · 2 fatalField investigationFinal reportPiper PA-20 · Beaver Falls, PAThe pilot's failure to maintain aircraft control, and his failure to attain adequate airspeed, which resulted in a stall. Contributing was the pilot's lack of familiarity with the airplane, and his misjudgment of wind information which resulted in a tailwind…Apr 12, 1998 · N2336A · DestroyedNTSB FTW98LA181Accident · No injuriesLimited investigationFinal reportWaxenfelter Thorp T-18 · Morrilton, ARThe pilot's failure to maintain directional control during landing roll.Apr 12, 1998 · N18WX · Substantial damageNTSB DCA98WA050Accident · No injuriesForeign investigationBoeing 737-200 · Alma-Ata, KazakhstanApr 12, 1998 · P4NEN · Substantial damageNTSB DCA98WA033Accident · No injuriesForeign investigationBoeing B-737-200 · Almaty, KazakhstanApr 12, 1998 · PK091NTSB CHI98LA121Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Chenoa, ILthe pilot experienced GLOC (G induced loss of consciousness) while performing an aerobatic maneuver. Fatigue was a factor.Apr 12, 1998 · N301NL · Substantial damageNTSB ANC98LA037Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28F · Haines, AKThe pilot flaring too low during an improper practice autorotation.Apr 12, 1998 · N199LB · Substantial damageNTSB SEA98FA101Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Bigfork, MTThe pilot's failure to maintain terrain clearance for undetermined reasons. Contributing factors were the mountainous terrain, trees, dark night conditions, clouds and pilot fatigue.Apr 11, 1998 · N9247W · DestroyedNTSB MIA98LA130Accident · 1 fatalLimited investigationFinal reportStarck Auriga · Collegedale, TNA leak in the electric fuel boost pump caused by an improperly sized 'O' ring installation and the pilot's failure to maintain airspeed during an approach to a forced landing resulting in a stall.Apr 11, 1998 · N311RS · DestroyedNTSB MIA98LA129Accident · Serious injuriesLimited investigationFinal reportKrips Kolb Firestar · Dallas, GAThe pilot's failure to maintain adequate airspeed for the existing wind conditions.Apr 11, 1998 · UNREG · DestroyedNTSB LAX98LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Scottsdale, AZThe pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A contributing factor was the crosswind.Apr 11, 1998 · N73405 · Destroyed