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 NYC90LA071Accident · No injuriesLimited investigationFinal reportCessna 177RG · Harford, PAA loss of braking action which allowed the aircraft to run into trees after the pilot made a precautionary landing due to a rough running engine of undetermined cause.NTSB LAX90FA093Accident · 1 fatalField investigationFinal reportCessna 210L · Modesto, CAFor an undetermined reason, the engine lost power.NTSB LAX90FA092Accident · 2 fatalField investigationFinal reportMooney M20F · Galt, CAThe pilot flew into instrument condition, because spatially disorientated and collided with terrain. Factor was foggy weather conditions.NTSB CHI90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pontiac, MIOverload failure of the left main landing gear attach bolts for an undetermined reason.NTSB CHI90LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Plainwell, MIForeign object (ice), which jammed the right wheel. A factor related to the accident was: the snowbank.NTSB BFO90LA029Accident · No injuriesLimited investigationFinal reportCessna 150M · Leesburg, VAThe pilot's failure to assure an adequate supply of fuel was onboard to complete the flight.NTSB ATL90LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Peewee Valley, KYThe pilot's improper precautionary landings. The pilot's improper planning/decisions, the low fuel level, and the terrain conditions at the airstrip were related factors.NTSB LAX90LA096Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Inyokern, CAThe pilot's failure to refuel which led to fuel exhaustion.NTSB FTW90DRA03Accident · 1 fatalFinal reportAir Command 447 · Hearne, TXThe pilot's loss of control for undetermined reasons. A factor was the pilot's lack of total experience in the accident make and model.NTSB BFO90IA028Incident · No injuriesIncident investigationFinal reportBoeing B-727-29 · Washington, DCThe accident was fatigue failure of the right main landing gear support link shaft because of overtorque.NTSB ANC90FA034Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Cold Bay, AKContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate altitude (or clearance) from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB LAX90LA095Accident · No injuriesLimited investigationFinal reportBell 47B3 · Redlands, CAFailure of the pilot to use carburetor heat when warrented by conditions.NTSB LAX90LA091Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Corona, CAHelicopter rolling over in a dirt field after the pilot was demonstrating an engine faiure and autorotation maneuver.NTSB DEN90LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder, COFailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve. Patches of packed snow on the runway may have contributed to the pilot's inability to regain control after the initial swerve began.NTSB SEA90IA042Incident · No injuriesIncident investigationFinal reportBoeing 747-446B · Everett, WAA break from pre-existing intergranular cracks which led to a fracture.NTSB LAX90LA090Accident · No injuriesLimited investigationFinal reportCessna 180 · Red Bluff, CAThe pilot's loss of directional control during an attempted go-around after he swerved off the runway after landing with a crosswind component.NTSB LAX90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Napa, CAThe student pilot's failure to maintain directional control after landing.NTSB CHI90LA082Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILPilot's inability to maintain directional during the landing phase of flight. The slippery, snow covered runway, and a twelve knot direct crosswind contributed to the accident.NTSB ANC90LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKWater (or ice) contamination of the aircraft's fuel, and an inadequate preflight by the pilot. A factor related to the accident was: snow covered terrain in the emergency landing area.NTSB NYC90LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Worcester, MAA power loss due to an oil pump failure while operating over unsuitable terrain. A factor related to the accident was night conditions.NTSB MIA90FA071Accident · No injuriesField investigationFinal reportPiper PA-28-161 · Roseland, FLThe engine failure due to fuel starvation caused by a needle valve in the carburetor which allows fuel to enter the carburetor bowl, stuck in the closed position for undetermined reasons resulting in the forced landing.NTSB FTW90LA070Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Arlington, TXPoor judgement of the pilot after consumption of alcoholic beverage, his decision to make low passes at night (buzzing), failure of the pilot to maintain proper altitude, and diversion of his attention. Darkness was a related factor.NTSB FTW90FA072Accident · 5 fatalField investigationFinal reportMitsubishi MU-2B-60 · Putnam, TXImproper planning/decision by the pilot, which resulted in excessive accummulation of structural icing (on the aircraft's wings, stabilizers, fuselage, and/or engine inlets), and his failure to maintain adequate airspeed and aircraft control. Factors related…NTSB BFO90LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Tappahannock, VAFailure of fixed base operator (FBO) personnel to assure that the fuel tank was free of water, and failure of the pilot to insure that the aircraft was properly preflighted. Soft/marshy terrain in the emergency landing area was a related factor.NTSB MIA90IA070Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Sarasota, FLImproper servicing of the forward lavatory by contract service personnel.NTSB FTW90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rayne, LAFailure of the #3 exhaust valve, which necessitated a forced landing on unsuitable terrain.NTSB FTW90FA069Accident · 2 fatalField investigationFinal reportBeech C-90 · Burlington, NCThe double engine power loss due to fuel starvation, the pilot's failure to follow procedures and directives by not engaging the right fuel transfer pump, and the inadvertent stall during the forced landing approach. A factor was the pilot's failure to refuel…NTSB DEN90LA056Accident · No injuriesLimited investigationFinal reportCessna 404 · Englewood, COThe collapse of the nose gear assembly for undetermined reasons.NTSB CHI90LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harbor Springs, MIThe student pilot's failure to maintian adequate directional control of the aircraft. The unfavorable wind was a related factor.NTSB CHI90LA080Accident · No injuriesLimited investigationFinal reportBeech V35 · West Chicago, ILFailure of the pilot to extend the gear, which resulted in an inadvertent wheels-up landing.NTSB CHI90LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Elkhart, INThe pilot's improper in-flight planning/decision and inadequate fuel consumption calculations, which resulted in a loss of engine power & subsequent off-airport forced landing. The stronger than anticipated wind aloft was a contributing factor.NTSB BFO90FA025Accident · 1 fatalField investigationFinal reportCessna 150F · Arden, NCThe pilot failure to maintain adequate altitude and clearance from a powerline during the landing approach. A factor was the unmarked powerline.NTSB LAX90FA088Accident · 1 fatalField investigationFinal reportBeech F-33A · Oro Valley, AZThe pilot's poor judgement in performing low level aerobatic maneuvers.NTSB CHI90TL#03Accident · Serious injuriesClass 3Final reportBell 206B · Fort Thompson, SDNTSB CHI90LA079Accident · No injuriesLimited investigationFinal reportCessna 177B · Raleigh, ILInadequate preflight by the pilot and fuel exhaustion due to an inadequate supply of fuel. The unreliable fuel quantity gauge was a related factor.NTSB SEA90LA041Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Sun River, ORThe pilot's failure to properly compensate for strong crosswinds during takeoff ground roll.NTSB MIA90LA069Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Lauderdale, FLThe pilot's failure to maintain control of the airplane after the right main gear contacted a tie down hole, which resulted in a collision with the hangar.NTSB FTW90LA068Accident · No injuriesLimited investigationFinal reportCessna 180J · Austin, TXThe pilot in command's failure to maintain directional control of the airplane during a downwind landing. Contributing to the accident was the pilot's lack of total experience in this type airplane.NTSB ATL90LA062Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Atmore, ALFuel starvation due to an inadequate preflight and improper positioning of the fuel selector. A factor related to the accident was: rough terrain in the emergency landing area.NTSB NYC90FA067Accident · 1 fatalField investigationFinal reportBell 206L · New York City, NYThe pilot's misjudgement of the wind resulting in a downwind takeoff. Additionally the loss of lift when the helicopter flew off the heliport platform, prior to reaching effective translational lift, resulted in the helicopter settling into the water.NTSB MKC90LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palestine, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB LAX90LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Long Beach, CAThe pilot's failure to raise the gear and flaps during a go-around resulting in a loss of control. A contributing factor was the pilot's lack of experience in a PA-23.NTSB LAX90LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Bullhead City, AZThe pilot's miscalculation of the fuel remaining, which caused the engine to quit.NTSB FTW90LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Prue, OKFailure of the pilot to see-and-avoid the powerlines. The powerlines were a related factor.NTSB FTW90LA066Accident · No injuriesLimited investigationFinal reportCessna 180 · Portland, TXThe pilot's inadequate compensation for wind conditions, which resulted in a failure to attain a flare during the landing. The unfavorable wind conditon was a related factor.NTSB FTW90LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Encinal, TXThe loss of directional control due to the failure of the tail rotor cable.NTSB FTW90DRD02Accident · No injuriesFinal reportC&J Sontheimer Rotorway · Lake Charles, LAFailure of the tail rotor drive belt.NTSB CHI90LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lafayette, INFailure of the student pilot to maintain directional control during the landing roll. The student's lack of aviation experience was a related factor.NTSB ATL90LA063Accident · No injuriesLimited investigationFinal reportBeech A 36 · Ocean Island Be, NCLoss of engine power due to fuel starvation and the pilot in commands failure to turn on the electric boost pump during attempted engine restart resulting in a forced landing.NTSB NYC90LA069Accident · No injuriesLimited investigationFinal reportCessna 172P · Sunapee Lake, NHFailure of the pilot to maintain adequate altitude above the lake, which resulted in unplanned contact with its frozen surface.