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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN89LA090Accident · No injuriesLimited investigationFinal reportBell 222 · Leadville, COFailure of the pilot to compensate adequately for wind conditions with rudder pedals while maneuvering in unfavorable wind and high density altitude.NTSB DEN89FA091Accident · 1 fatalField investigationFinal reportCessna 210D · Eugene, ORThe pilot's decision to continue VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: the terrain and weather conditions at the accident site, and the pilot's lack of instrument experience.NTSB BFO89LA025Accident · No injuriesLimited investigationFinal reportCessna 170A · Ravenswood, WVThe pilots decision to land with a tailwind and inadequately compensating for the wind conditions.NTSB NYC89LA103Accident · No injuriesLimited investigationFinal reportBeech A100 · Johnstown, PAFailure of the down lock plate, which allowed the landing gear to collapse.NTSB DEN89IA089Incident · No injuriesIncident investigationFinal reportBoeing 727-200A · San Antonio, TXFailure of the ARTCC controller to assure that the aircraft maintained IFR separation standards. The controller's heavy workload was a related factor.NTSB CHI89LA059Accident · No injuriesLimited investigationFinal reportCessna 150L · Sellersburg, INThe failure of the student pilot to control the airplane during the landing flare and touchdown. The student pilots lack of experience and gusty crosswinds are contributing factors to the accident.NTSB CHI89FA062Accident · Serious injuriesField investigationFinal reportHughes 269C · De Kalb, ILFatigue failure of the number four connecting rod which resulted in an engine failure. Factors in the accident were the broken ring in the number one piston and a deteriorated center main bearing.NTSB CHI89FA061Accident · 1 fatalField investigationFinal reportCessna 150M · Corunna, MIThe failure of the student pilot to maintain sufficient altitude to recover from a practice stall maneuver. A factor related to the accident was: the pilot's visual perception over snow covered terrain.NTSB ATL89FA112Accident · Serious injuriesField investigationFinal reportBell 206B · Atlanta, GAFatigue failure of the engine spur adapter gearshaft in an area where there was a lack of lubrication (oil starvation) due to a partially blocked oil delivery tube. Contributing factors were: inattentive maintenance or servicing of the aircraft by unknown…NTSB MKC89IA082Incident · No injuriesIncident investigationFinal reportGulfstream 690A · Bismark, NDA failed (cracked) engine plenum resulting in loss of engine power.NTSB MIA89LA112Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Marathon, FLThe pilot failed to maintain directional control of the aircraft and inadvertently allowed it to ground loop. Crosswind was a contributing factor.NTSB MIA89FA111Accident · Serious injuriesField investigationFinal reportCessna 172H · Melbourne, FLThe pilot's selection of an inappropriate runway for takeoff and his inadequate compensation for crosswind conditions.NTSB LAX89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fullerton, CAEngine failure due to fuel starvation, the selection of the improper fuel tank by the student, and poor supervision by the instructor. Contributing to the cause of the accident was an inadequate preflight of the airplane by the dual student.NTSB LAX89DUG03Accident · 1 fatalFinal reportVan'S/Fish RV-4 · Hesperia, CAThe pilot's failure to properly latch the canopy prior to takeoff and by allowing the aircraft to enter into a stall during a critical phase of flight at an attitude insufficient to recover safely. A factor in the accident was the loss of his eyeglasses when…NTSB ATL89LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Kershaw, SCFatigue failure of the crankshaft dowel pin. Factors related to the accident were: failure of maintenance personnel to follow the applicable service bulletin and darkness.NTSB ATL89FA113Accident · 1 fatalField investigationFinal reportBeech F33A · Ashland, ALThe pilot continued VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: high terrain, the adverse weather conditions, and trees.NTSB LAX89LA129Accident · No injuriesLimited investigationFinal reportHughes 269C · Saipan, SarkFailure of maintenance personnel to assure the helicopter was serviced with the proper grade of fuel. A factor realated to the accident was: the lack of a suitable landing area, which resulted in having to ditch the helicopter in the water.NTSB LAX89LA128Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Jose, CAImproper in-flight planning/decision by the pilot and subsequent fuel exhaustion. Contributing factors were: dark night,trees, and the building.NTSB SEA89FA057Accident · 1 fatalField investigationFinal reportCessna T210L · Longmire, WAPhysical incapacitation of the pilot.NTSB MIA89LA110Accident · No injuriesLimited investigationFinal reportCessna 195 · Moore Haven, FLInadequate preflight by the pilot which resulted in fuel exhaustion due to inadequate fuel supply. A contributing factor was a ditch which the aircraft hit as the pilot was applying brakes to avoid a fence.NTSB DEN89LA088Accident · Minor injuriesLimited investigationFinal reportMiller S.A.L. 2/3 Mustang · Erie, COLoss of engine power for an unknown reason. Soft uneven terrain was a contributing factor.NTSB ATL89LA108Accident · No injuriesLimited investigationFinal reportBeech A36 · Chamblee, GAThe inattention of the pilot which resulted in the inadvertent retraction of the landing gear during the landing roll.NTSB SEA89LA067Accident · No injuriesLimited investigationFinal reportCessna TU206 · Anacortes, WAThe pilot diverted his attention during the landing, which resulted in an improper flare & hard landing. His lack of recent flying experience was a related factor.NTSB SEA89LA058Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Jerome, IDThe failure of another person to report a hard landing which resulted in the airplane not being inspected by authorized personnel.NTSB LAX89LA127Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Malibu, CAThe failure of the passenger to follow briefed procedures and the failure of ground personnel to provide adequate assistance.NTSB LAX89DVA05Accident · Serious injuriesFinal reportGrumman G-164B · Westley, CAA loss of engine power for undetermined reasons. A factor related to the accident was the proximity of obstructions.NTSB DCA89MA035Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas DC-9-33F · Saginaw, TXThe loss of control of the airplane for undetermined reasons following the inflight opening of the improperly latched cargo door. Contributing to the accident were: inadequate procedures used by evergreen airlines and approved by the FAA for preflight…NTSB CHI89FA058Accident · No injuriesField investigationFinal reportCessna 177RG · Rockford, ILThe inadequate servicing of the hydraulic fluid by maintenance personnel and the pilot's failure to extend the landing gear manually.NTSB ATL89LA111Accident · 1 fatalLimited investigationFinal reportMorrisey 2150A · Lenoir, NCPilot disregarded the apparent severity of the approaching thunderstorms and attempted a circuit of the airport under visual flight rules when it was not possible. The pilot's lack of recent flight experience was a contributing factor.NTSB ATL89LA109Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pickens, SCImproper flare by the pilot and inadequate supervision of the flight by the other crew member.NTSB MKC89LA081Accident · No injuriesLimited investigationFinal reportRockwell S2R T34 · Heth, ARAircraft control not maintained by the pilot in command due to landing in a tailwind of excessive velocity which the pilot misjudged or failed to recognize.NTSB MIA89FA109Accident · 2 fatalField investigationFinal reportCessna 172M · Pascagoula, MSContinued flight by the pilot into instrument meteorological conditions (IMC). Contributing factors were: inadequate preflight planning, weather conditions, pilot's lack of instrument flight time, lack of visual cues at night, and trees at the crash site.NTSB FTW89LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Galveston, TXFailure of the pilot to maintain sufficient airspeed, which resulted in a stall and loss of control. Contributing factors were: the weather conditions, which were below minimums, and failure of the pilot to perform a missed approach.NTSB DCA89MA034Accident · No injuriesMajor investigationFinal reportBoeing 737-300 · Oakland, CAIgnition of puddled fuel from a blocked combustor drain line, and a slow start during which fuel was misted and blown out the tail pipe. An existing tailwind at the gate allowed the fuel to wet the tail surfaces and be ignited during the APU start. The…NTSB BFO89DID01Accident · No injuriesFinal reportHalstead Sandpiper · Chesapeake, VAThe pilot/builders improper installation of the ruddervador and the pilot's improper recovery from a bounced landing. A contributing factor was the failure of the FAA to detect the flaw during the certification of the aircraft.NTSB SEA89LA075Accident · No injuriesLimited investigationFinal reportCessna 150E · Hillsboro, ORThe improper landing flare performed by an unqualified person at the controls who had no flight training.NTSB NYC89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honesdale, PAThe loss of directional control by the pilot during landing.NTSB NYC89LA100Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Lakewood, NJThe pilot's failure to adequately compensate for the crosswind conditions. Contributing to the accident were the crosswind conditions.NTSB LAX89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rio Vista, CAThe improper planning and execution of an emergency (simulated) maneuver by the pilot.NTSB LAX89LA125Accident · No injuriesLimited investigationFinal reportBell 206B · Corona, CAImproper operation of the cyclic by the student pilot, failure of the student to relinquish control and inadequate supervision by the flight instructor.NTSB ATL89LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Swainsboro, GAThe pilot's decision to land at an unlighted airstrip in low light conditions, and her subsequent, inadvertent selectionof unsuitable terrain bordering the runway.NTSB ATL89FA106Accident · 2 fatalField investigationFinal reportBeech H35 · Knoxville, TNThe pilot's continued operation of the airplane with a known mechanical defect in the engine carburetor/fuel supply system as evidenced by the past history of engine stoppage during ground operation. Contributing to the accident was the pilot's performance of…NTSB ANC89LA053Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Fairbanks, AKThe student pilot's inproper use of carburetor heat and the instructors failure to properly supervise the student actions within the airplane.NTSB FTW89LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Henryetta, OKThe loss of engine power from fuel starvation due to inadequate inflight planning/decision.NTSB CHI89MA057Accident · 2 fatalMajor investigationFinal reportNihon YS-11A-600 · West Lafayette, INA loss of control due to the improper inflight decisions by the crew and the undetected accumulation of ice on the leading edge of the horizontal stabilizer, during flight in a forward center of gravity condition and exacerbated by the extension of full…NTSB MIA89FA108Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Holley, FLContinued flight by the plt into adverse wx, followed by spatial disorientation and loss of aircraft control. Lack of a preflight weather briefing, weather conditions, and lack of visual cues at night were considered contributing factors.NTSB FTW89IA067Incident · Minor injuriesIncident investigationFinal reportBoeing 727-232 · Greenville, TXFalse fire warning, which resulted from (1) contaminants on hardware at one end of the fire detection loop; and (2) an electrical short on both elements of the loop.NTSB ATL89IA104Incident · No injuriesIncident investigationFinal reportCessna 177RG · Savannah, GAFatigue-induced fracture of the main landing gear actuator rod end.NTSB ATL89DKJ02Accident · No injuriesFinal reportAircraft Parts & Dev. A-9B · Athens, ALThe pilot's inadequate preflight preparation/planning to assure sufficient runway length for clearing obstructions.NTSB MKC89LA080Accident · No injuriesLimited investigationFinal reportCallair A9-B · Fisher, ARFailure of the engine magneto resulting in engine failure.