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 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.Feb 18, 1990 · N45371 · Substantial damageNTSB LAX90FA093Accident · 1 fatalField investigationFinal reportCessna 210L · Modesto, CAFor an undetermined reason, the engine lost power.Feb 18, 1990 · CGICH · DestroyedNTSB 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.Feb 18, 1990 · N4093N · DestroyedNTSB CHI90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pontiac, MIOverload failure of the left main landing gear attach bolts for an undetermined reason.Feb 18, 1990 · N8394D · Substantial damageNTSB CHI90LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Plainwell, MIForeign object (ice), which jammed the right wheel. A factor related to the accident was: the snowbank.Feb 18, 1990 · N50003 · Substantial damageNTSB BFO90LA029Accident · No injuriesLimited investigationFinal reportCessna 150M · Leesburg, VAThe pilot's failure to assure an adequate supply of fuel was onboard to complete the flight.Feb 18, 1990 · N63506 · Substantial damageNTSB 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.Feb 18, 1990 · N95445 · Substantial damageNTSB LAX90LA096Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Inyokern, CAThe pilot's failure to refuel which led to fuel exhaustion.Feb 17, 1990 · N9843J · Substantial damageNTSB 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.Feb 17, 1990 · UNREG · DestroyedNTSB 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.Feb 17, 1990 · N902TS · Minor damageNTSB 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.Feb 17, 1990 · N27328 · DestroyedNTSB LAX90LA095Accident · No injuriesLimited investigationFinal reportBell 47B3 · Redlands, CAFailure of the pilot to use carburetor heat when warrented by conditions.Feb 16, 1990 · N11HU · DestroyedNTSB 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.Feb 16, 1990 · N777FH · Substantial damageNTSB 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.Feb 16, 1990 · N25197 · Substantial damageNTSB SEA90IA042Incident · No injuriesIncident investigationFinal reportBoeing 747-446B · Everett, WAA break from pre-existing intergranular cracks which led to a fracture.Feb 15, 1990 · UNREG · Minor damageNTSB 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.Feb 15, 1990 · N9164T · Substantial damageNTSB LAX90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Napa, CAThe student pilot's failure to maintain directional control after landing.Feb 15, 1990 · N2824Y · Substantial damageNTSB 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.Feb 15, 1990 · N6186X · Substantial damageNTSB 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.Feb 15, 1990 · N4305L · Substantial damageNTSB 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.Feb 14, 1990 · N763DS · Substantial damageNTSB 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.Feb 14, 1990 · N8432P · Substantial damageNTSB 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.Feb 14, 1990 · N21969 · DestroyedNTSB 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…Feb 14, 1990 · N300CW · DestroyedNTSB 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.Feb 14, 1990 · N8521W · Substantial damageNTSB MIA90IA070Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Sarasota, FLImproper servicing of the forward lavatory by contract service personnel.Feb 13, 1990 · N8889Z · Minor damageNTSB FTW90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rayne, LAFailure of the #3 exhaust valve, which necessitated a forced landing on unsuitable terrain.Feb 13, 1990 · N1785T · Substantial damageNTSB 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…Feb 13, 1990 · N110LT · DestroyedNTSB DEN90LA056Accident · No injuriesLimited investigationFinal reportCessna 404 · Englewood, COThe collapse of the nose gear assembly for undetermined reasons.Feb 13, 1990 · N409EX · Substantial damageNTSB 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.Feb 13, 1990 · N6704W · Substantial damageNTSB CHI90LA080Accident · No injuriesLimited investigationFinal reportBeech V35 · West Chicago, ILFailure of the pilot to extend the gear, which resulted in an inadvertent wheels-up landing.Feb 13, 1990 · N9582Q · Substantial damageNTSB 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.Feb 13, 1990 · N4931M · Substantial damageNTSB 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.Feb 13, 1990 · N8615S · DestroyedNTSB LAX90FA088Accident · 1 fatalField investigationFinal reportBeech F-33A · Oro Valley, AZThe pilot's poor judgement in performing low level aerobatic maneuvers.Feb 12, 1990 · N3SN · DestroyedNTSB CHI90TL#03Accident · Serious injuriesClass 3Final reportBell 206B · Fort Thompson, SDFeb 12, 1990 · N620 · DestroyedNTSB 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.Feb 12, 1990 · N35100 · Substantial damageNTSB SEA90LA041Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Sun River, ORThe pilot's failure to properly compensate for strong crosswinds during takeoff ground roll.Feb 11, 1990 · N6045N · Substantial damageNTSB 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.Feb 11, 1990 · N98673 · Substantial damageNTSB 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.Feb 11, 1990 · N52035 · Substantial damageNTSB 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.Feb 11, 1990 · N90093 · Substantial damageNTSB 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.Feb 10, 1990 · N16664 · Substantial damageNTSB 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.Feb 10, 1990 · N3049V · Substantial damageNTSB 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.Feb 10, 1990 · N2118P · DestroyedNTSB LAX90LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Bullhead City, AZThe pilot's miscalculation of the fuel remaining, which caused the engine to quit.Feb 10, 1990 · N1272Q · Substantial damageNTSB FTW90LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Prue, OKFailure of the pilot to see-and-avoid the powerlines. The powerlines were a related factor.Feb 10, 1990 · N1407Y · Substantial damageNTSB 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.Feb 10, 1990 · N3110C · Substantial damageNTSB FTW90LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Encinal, TXThe loss of directional control due to the failure of the tail rotor cable.Feb 10, 1990 · N58204 · Substantial damageNTSB FTW90DRD02Accident · No injuriesFinal reportC&J Sontheimer Rotorway · Lake Charles, LAFailure of the tail rotor drive belt.Feb 10, 1990 · N850JR · Substantial damageNTSB 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.Feb 10, 1990 · N6003U · Substantial damageNTSB 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.Feb 10, 1990 · N4723M · Substantial damageNTSB 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.Feb 9, 1990 · N65057 · Substantial damage