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 CHI89LA102Accident · No injuriesLimited investigationFinal reportCessna 206 · Flushing, MIPilot's inadequate aircraft control during the aborted takeoff attempt, and the aircraft's resultant collision with trees. The wet runway was a factor in the lack of normal braking action.NTSB BFO89LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Criders, VAThe pilot failed to maintain directional control of the airplane during the crosswind conditions encountered during the initial takeoff climb.NTSB BFO89LA039Accident · Minor injuriesLimited investigationFinal reportAircoupe Alon A2A · Sutherland, VALow output of the magnetos which resulted in the loss of full power during the attempted recovery from a simulated forced landing. The pilot ignored indications of an engine problem during start when the engine was hard to start.NTSB ANC89LA083Accident · No injuriesLimited investigationFinal reportCessna 185F · Toksook Bay, AKThe pilot inadvertently landed on water with the gear extended.NTSB NYC89LA141Accident · No injuriesLimited investigationFinal reportBell 206-L · Wading River, NYThe pilot's failure to control the rate of descent which resulted in a hard landing. Contributing to the accident was a power loss due to a compressor failure.NTSB MKC89LA132Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Scandia, KSImproper planning/decision by the pilot and fuel exhaustion. Contributing factors were the pilot becoming lost/disoriented and small trees.NTSB MKC89LA120Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Alexandria, MNThat proper starting procedures were not followed by the pilot in command and the aircraft was not tied down.NTSB CHI89FA101Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Bristol, INContinued flight by the pilot into known adverse weather and his exceeding the design stress limits of the aircraft, which resulted in failure of the wing spars and separation of the right wing and empennage (stabilizers). Contributing factors were: continued…NTSB SEA89LA095Accident · No injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDA loss of engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB NYC89LA171Accident · No injuriesLimited investigationFinal reportHughes 369HS · Niagara Falls, NYFailure of the pilot to see and avoid the cables.NTSB MKC89LA121Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Snow Lake, ARThe selection of unsuitable terrain to takeoff from by the pilot and the inadequate runway maintenance by airport personnel. Contributing to the accident was the hidden hole which the airplane contacted resulting in the pilot's inability to control the…NTSB MKC89LA119Accident · Minor injuriesLimited investigationFinal reportRockwell Thrush S2R · Carlisle, ARThe engine failed due to a cracked cylinder and the pilot was forced to attempt a landing in a rice field where the gear collapsed.NTSB MIA89LA165Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Keystone Hgts., FLThe tail rotor drive system became disconnected due to a bent tail rotor drive shaft. The trees contributed to the helicopter damage.NTSB MIA89LA163Accident · No injuriesLimited investigationFinal reportCessna 150L · Jacksonville, FLThe pilot's failure to have someone operate the airplane's brakes and engine controls during hand propping the engine.NTSB MIA89FA164Accident · Serious injuriesField investigationFinal reportAir Tractor AT-401 · Clarksdale, MSThe pilot failed to maintain airspeed resulting in the airplane stalling and descending out of control.NTSB LAX89LA209Accident · No injuriesLimited investigationFinal reportAeronca 50F · Ontario, CAThe pilot's inability to compensate for existing wind conditions, resulting in the inability to maintain a climb.NTSB LAX89LA208Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAThe pilot of the other aircraft displayed poor judgement when he elected to continue taxiing in the runup area when visual lookout could not be maintained.NTSB FTW89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Stratford, TXImproper planning/decision by the pilot, and his inadequate compensation for wind conditions, which resulted in a loss of aircraft control. The wind condition was a related factor.NTSB DEN89FA127Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wilmington, OHThe failure of the pilot to assure an adequate fuel supply and his failure to refuel en route.NTSB CHI89LA098Accident · No injuriesLimited investigationFinal reportCessna P210N · Wheeling, ILFailure of the pilot to extend the landing gear, which resulted in a wheels-up landing.NTSB ATL89LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Trinity, NCThe pilots failure to select a suitable takeoff area based on the weight of the aircraft and the atmospheric conditions at the time of takeoff.NTSB ATL89LA154Accident · 1 fatalLimited investigationFinal reportBoeing E75 (PT-13D) · Jacksonville, NCThe pilot encountered an accelerated stall during an abrupt maneuver, lost control of the airplane and did not have sufficient altitude to recover from the ensuing spin prior to colliding with the ground.NTSB ATL89LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Medina, OHFailure of airport management to establish a displaced threshold which would provide adequate obstruction clearance. Factors contributing to the accident were the power lines, the utility pole and the dusk light conditions.NTSB ANC89LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilots failure to maintain directional control of the aircraft during a touch and go landing which resulted in a ground loop.NTSB SEA89LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Bend, ORThe pilot allowed his attention to be diverted by a crosswind and failed to maintain clearance from trees on approach.NTSB SEA89FA092Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Angoon, AKPilot failed to assure the landing gear on the amphibious floats were retracted for the water landing.NTSB MIA89WA167Accident · Minor injuriesForeign investigationCessna R182 · Walker Cay, BahamasNTSB MIA89LA162Accident · No injuriesLimited investigationFinal reportCessna A152 · Lake Wales, FLImproper planning/decision by the pilot by not properly securing the aircraft or obtaining proper assistance.NTSB FTW89LA102Accident · No injuriesLimited investigationFinal reportCessna 150L · Onalaska, TXFuel system exhaustion due to the improper planning/decision by the flight instructor, on the ground, prior to the flight and the improper inflight planning/decision by the student pilot.NTSB FTW89DRD05Accident · Minor injuriesFinal reportGrumman G-164A · Gueydan, LAVisual lookout was not maintained by the pilot in command, which resulted in the collision with a power transmission line during a swath run.NTSB DEN89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rangely, COImproper planning/decision by the pilot. The high wind, gusts, the pilot's lack of recent experience, and his lack of familiarity with the aircraft's new handling characteristics were considered to be contributing factors.NTSB DEN89FA123Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas MD-80 · Denver, COA right main landing gear vibration of unknown origin, which resulted in a failure of the right main landing gear torque link and side brace.NTSB CHI89LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-180 · Frankfort, ILPilot's failure to maintain directional control while attempting to land in cross/tailwind conditions.NTSB ATL89DKG03Accident · No injuriesFinal reportRotorway Exec · Roswell, GAThe pilots improper use of the tail rotor controls while in a hover. Adding to this was the pilots total lack of experience operating helicopters.NTSB ANC89LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Kahiltna Glac, AKThe pilot's decision to commit himself to a landing before completing an evaluation of the weather in the vicinity of the landing site. Contributing to the severity of the accident was the snowbank off the side of the runway with which the aircraft collided.NTSB ANC89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKA crack on the left side of the engine crankcase which resulted in a loss of lubricating oil and which forced the pilot to land on a gravel bar which resulted in a nose over during landing.NTSB SEA89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Black Diamond, WAPower loss due to magneto failure. Contributing to the accident were lack of suitable terrain for forced landing and the presence of obstacles.NTSB NYC89LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oneonta, NYThe pilot lost control of the aircraft while landing in gusty wind conditions.NTSB MKC89FA117Accident · Serious injuriesField investigationFinal reportCessna 172M · Oakland, ARPilot electing to buzz persons on the lake at low altitude and colliding with power lines.NTSB MIA89LA166Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Lambert, MSFailure of the engine impeller. The ditch in the emergency landing area was a related factor.NTSB MIA89LA161Accident · No injuriesLimited investigationFinal reportCessna 182R · Tutwiler, MSLoss of control of the aircraft due to an encounter with a dust devil while on the ground.NTSB LAX89LA207Accident · No injuriesLimited investigationFinal reportCessna A185F · Jackson, CAThe pilot did not establish a climb rate sufficient enough to clear trees before turning towards them during a go-around. Contributing to the accident were gusty crosswinds which changed to a tailwind when the aircraft turned to the right and the pilots…NTSB LAX89LA206Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Big Sur, CAThe pilot elected to attempt a takeoff from a field that he had previously made a forced landing to and the airplane nosed over during the attempt. Contributing to the accident was the high grass that became entangled in the tailwheel and the soft downhill…NTSB DEN89LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Angel Fire, NMThe pilot's failure to properly evaluate the existing weather conditions and the subsequent takeoff into adverse conditions which degraded the airplane's climb capability. The pilot performed an intentional gear up landing.NTSB DEN89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Fort Collins, COLoss of engine power for an undetermined reason. The dark night and terrain condition were considered to be contributing factors.NTSB CHI89LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Crandon, WIImproper inflight planning/decision by the pilot which resulted in loss of control & subsequent wingtip collision with the ground during the landing. The crosswind and turbulence were contributing factors.NTSB BFO89LA037Accident · Serious injuriesLimited investigationFinal reportSchweizer I-26E · Churchville, MDThe pilot's failure to maintain adequate airspeed during the turn from base to final approach which resulted in the wing contacting the ground and the glider cartwheeling.NTSB NYC89LA138Accident · No injuriesLimited investigationFinal reportHughes 269A · Swanton, VTThe pilot failed to maintain directional control.NTSB NYC89LA136Accident · No injuriesLimited investigationFinal reportMaule M5 · Kutztown, PAAn off airport landing in unsuitable terrain due to a power loss for undetermined reasons.NTSB MKC89LA118Accident · No injuriesLimited investigationFinal reportBeech V35 · Strong, AREngine failure due to fuel starvation.