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 SEA91LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, WAThe pilot's selection of an unsuitable landing sute after making the decision to attempt a precautionary landing.Feb 23, 1991 · N6568B · Substantial damageNTSB MIA91WA088Accident · No injuriesForeign investigationBeech C23 · Alice Town, BahamasFeb 23, 1991 · N2013N · Substantial damageNTSB MIA91FA085Accident · 1 fatalField investigationFinal reportParker Warren Whittman Formula VEE · Pompano Beach, FLThe pilot-in-command's in flight loss of control due to incapacitation resulting from underlying severe heart disease. Contributing to the accident was the pilot-in-command's not reporting the history of hypertension and heart problems during his FAA medical…Feb 23, 1991 · N24PW · DestroyedNTSB LAX91FA111Accident · 2 fatalField investigationFinal reportCessna 150L · Carlsbad, CAThe cfi/pic's inadequate in-flight planning/decision and the continued VFR flight into an area of IMC conditions. The pilot's impairment due to high levels of antihistamine and the low ceiling were factors in the accident.Feb 23, 1991 · N18526 · DestroyedNTSB FTW91DPG02Accident · No injuriesFinal reportGrumman G-164A · Light, ARThe pilot's selection of the downwind runway for landing. A factor was the tailwind.Feb 23, 1991 · N7493 · Substantial damageNTSB SEA91FA057Accident · 3 fatalField investigationFinal reportCessna 182J · Glendale, ORThe pilot's failure to use all available runway for this landing, aggravated by his failure to initiate a go-around after misjudging the proper touchdown point and landing with a tailwind.Feb 22, 1991 · N3154F · DestroyedNTSB MIA91LA084Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ldl-By-The-Sea, FLTail rotor blade failure due to undetermined reasons and unsuitable terrain during a precautionary landing.Feb 22, 1991 · N210FH · Substantial damageNTSB FTW91FA043Accident · 3 fatalField investigationFinal reportMitsubishi MU-2B-60 · Tulsa, OKThe shutdown of one engine for undetermined reasons, and the pilot's failure to maintain vmca during a critical phase of flight. A factor in the accident was the pilot's improper emergency procedure.Feb 22, 1991 · N274MA · DestroyedNTSB SEA91FA054Accident · 2 fatalField investigationFinal reportPiper PA-15 · Cottage Grove, ORThe pilot did not maintain an adequate airspeed. Factors to the accident were: a dark night condition and an uncontrolled stall/spin.Feb 20, 1991 · N4518H · Substantial damageNTSB MIA91LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · Panama City, FLThe pilot's improper recovery from a bounced landing. A factor was the pilot's lack of recent night flight experience.Feb 20, 1991 · N6136Y · Substantial damageNTSB CHI91LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, ILThe pilot in command's poor preflight planning and improper weather evaluation.Feb 20, 1991 · N116CF · Substantial damageNTSB CHI91LA097Accident · Serious injuriesLimited investigationFinal reportHughes 269C · North Mankato, MNThe fatique failure of the tail boom support strut attachment cluster and the improper inspection of the cluster attachment.Feb 20, 1991 · N8955F · DestroyedNTSB NYC91LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Punxsutawney, PAIntentional flight by the pilot into instrument meteorological conditions which resulted in a inflight collision with rising terrain, which was obscured by fog. A factor related to the accident was the pilots evaluation of the weather.Feb 19, 1991 · N5512Y · DestroyedNTSB SEA91LA053Accident · No injuriesLimited investigationFinal reportBeech 95 · Roundup, MTPartial loss of power for undetermined reasons.Feb 18, 1991 · N2772Y · Substantial damageNTSB NYC91LA077Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Wallkill, NYDecision by the non-instrument rated pilot to attempt flight into instrument meteorological conditions, resulting in airframe icing, loss of control and collision with trees. A factor related to the accident was the failure of the pilot to receive a…Feb 18, 1991 · N2445G · Substantial damageNTSB MIA91LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, FLFailure of the pilot to plan the flight and failure to obtain proper assistance from ATC after becoming lost, which resulted in total loss of engine power due to fuel exhaustion.Feb 18, 1991 · N24913 · Substantial damageNTSB LAX91LA109Accident · No injuriesLimited investigationFinal reportRockwell S2R-600 · Corcoran, CAFailure of the aircraft engine's fuel pump valve assembly bypass.Feb 18, 1991 · N4930X · Substantial damageNTSB FTW91LA041Accident · No injuriesLimited investigationFinal reportHughes 269C · Knowles, OKThe pilot's failure to maintain a proper descent rate during the maneuver and his delay in initiating the go-around.Feb 18, 1991 · N8973F · Substantial damageNTSB FTW91FA042Accident · 1 fatalField investigationFinal reportCessna 172N · Thornton, TXThe pilot's decision to fly into known adverse weather and the wet microburst. A factor was his disregard for the forecast.Feb 18, 1991 · N5112K · DestroyedNTSB DEN91IA046Incident · No injuriesIncident investigationFinal reportAvions Marcel Dassault Mistert Falcon 900 · Eagle, COImproper engine maintenance by maintenance personnel, improper assembly of the combustion assembly transition liner, and the rupture of the first stage lp turbine wheel.Feb 18, 1991 · N90EW · Minor damageNTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.Feb 18, 1991 · N8770S · Substantial damageNTSB ATL91LA057Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brunswick, GAA hidden hole in the runway surface, which was contacted by the nose wheel during the landing roll.Feb 18, 1991 · N759VB · Substantial damageNTSB LAX91LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · San Carlos, CAThe pilot's improper flare landing.Feb 17, 1991 · N5300F · Substantial damageNTSB LAX91LA104Accident · No injuriesLimited investigationFinal reportCessna 340A · Truckee, CAThat the pilot failed to follow the correct emergency procedures when he began to experience engine problems and improperly used the fuel boost pumps contrary to the pilot's operating handbook. The initial cause of the engine surging could not be determined.Feb 17, 1991 · N5350J · Substantial damageNTSB LAX91LA102Accident · No injuriesLimited investigationFinal reportCurtiss-Wright E-4000 · Watsonville, CAThe inadequate design and length of the tailwheel assembly cable.Feb 17, 1991 · N9048 · Substantial damageNTSB LAX91FA106Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Fredonia, AZThe pilot's inattention to the airspeed and subsequent loss of aircraft control after attempting VFR flight into adverse weather conditions. Contributing to the accident was the pilot's failure to recognize his limitations of his aircraft.Feb 17, 1991 · N4384L · DestroyedNTSB LAX91FA103Accident · Serious injuriesField investigationFinal reportCessna 172 · Bullhead City, CAThe pilot's poor in-flight planning and decision and physical impairment from fatigue; he also failed to maintain flying speed. The lineman's failure to secure the access door and the pilot's impairment due to consumption of alcohol were factors in the…Feb 17, 1991 · N8551B · Substantial damageNTSB DCA91MA021Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-15 · Cleveland, OHThe failure of the flightcrew to detect and remove ice contamination on the airplane's wings, which was largely a result of a lack of appropriate response by the federal aviation administration, Douglas aircraft company, and ryan international airlines to the…Feb 17, 1991 · N565PC · DestroyedNTSB LAX91LA101Accident · No injuriesLimited investigationFinal reportPiper PA28-201T · So. Lake Tahoe, CAThe pilot failed to properly compensate for the wind conditions, abruptly flared the airplane, and inadvertenly stalled the airplane. Contributing to this accident was windshear.Feb 16, 1991 · N47569 · Substantial damageNTSB LAX91FA108Accident · 1 fatalField investigationFinal reportCessna T210N · Kyburz, CAThe pilot's attempt to conduct his visual flight into instrument meteorological conditions and the loss of aircraft control by becoming spatial disoriented. The low ceilings and the dark night that existed in the area were factors in the accident.Feb 16, 1991 · N9448Y · DestroyedNTSB FTW91LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Wichita Falls, TXThe pilot's inadequate compensation for crosswind conditions encountered on final and his failure to maintain directional control during the attempted go around. A factor in the accident was the unfavorable gusting crosswind conditions.Feb 16, 1991 · N9490N · Substantial damageNTSB DEN91LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Guymon, OKFuel starvation for undetermined reasons, and the pilot's delay in flaring the airplane. A factor was: the pilot's total lack of experience.Feb 16, 1991 · N3549W · DestroyedNTSB DEN91LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Timberon, NMThe pilot's inadequate preflight planning and selection of the wrong runway. Related factors were: the rising terrain, trees, and the pilot's lack of experience.Feb 16, 1991 · N49123 · Substantial damageNTSB ATL91LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Union Springs, ALThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.Feb 16, 1991 · N85880 · Substantial damageNTSB ANC91LA030Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Kodiak, AKA loss of control and collision with terrain after the helicopter entered a whiteout condition.Feb 16, 1991 · N59568 · Substantial damageNTSB NYC91LA076Accident · No injuriesLimited investigationFinal reportGulfstream G-1159 · Cleveland, OHThe pilot's improper in flight decision to land on a snow covered runway. The lack of adequate braking action resulted in the pilot intentionally ground looping the airplane and overloading the main landing gear. Factors related to the accident were snow…Feb 15, 1991 · N85EQ · Substantial damageNTSB FTW91FA038Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Falfurrias, TXThe pilot's improper compensation for wind conditions, the pilot not maintaining airspeed above vs during the go-around attempt and the pilot's impairment due to drugs. Factors were the gusting crosswind conditions and the pilot's lack of total aircraft…Feb 15, 1991 · N6961C · DestroyedNTSB DEN91FA043Accident · 3 fatalField investigationFinal reportLearjet 35A · Aspen, COThe flight crew's failure to maintain airspeed and control of the airplane while maneuvering to land. Contributing factors were the flight crew's execution of an unstabilized approach and the surrounding snow-covered mountainous terrain.Feb 14, 1991 · N535PC · DestroyedNTSB ATL91LA055Accident · No injuriesLimited investigationFinal reportBeech C23 · Concord, NCThe pilot's inadequate preflight planning in that he disregarded the crosswind limit in the pilot's operating handbook. Factors were the wet runway and the ravine at the end of the runway.Feb 14, 1991 · N9146S · Substantial damageNTSB ATL91FA054Accident · 1 fatalField investigationFinal reportCessna 172 · Crossville, TNThe improper flight planning by the noninstrument rated pilot which resulted in his inadvertent flight into instrument meteorological conditions in mountainous terrain.Feb 14, 1991 · N8641B · DestroyedNTSB SEA91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot did not maintain directional control of the airplane during the landing roll.Feb 13, 1991 · N757PW · Substantial damageNTSB SEA91LA050Accident · 4 fatalLimited investigationFinal reportBeech F33A · Ogden, UTThe pilot elected to fly into known adverse weather and encountered icing conditions. Contributing to the accident was the pilot's inadequate evaluation of the weather and a loss of engine power for undetermined reasons.Feb 13, 1991 · N66841 · DestroyedNTSB MIA91LA081Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plant City, FLFailure of the pilot to maintain proper alignment during the landing roll, excessive rudder input, and loss of directional control resulting in the collapse of the right main landing gear.Feb 13, 1991 · N95T · Substantial damageNTSB LAX91LA100Accident · Minor injuriesLimited investigationFinal reportMaule M-6-235 · Mobile, AZThe pilots' failure to establish a sufficient climb rate to avoid striking a fence.Feb 13, 1991 · N5662F · DestroyedNTSB LAX91FA098Accident · 2 fatalField investigationFinal reportBell 206B · Santa Paula, CAInadequate visual lookout by the Bell 206B pilot, which resulted in his failure to see-and-avoid the pitts S-2A. A factor related to the accident was: the S-2A pilot's restricted visibility from the tailwheel equipped airplane, once it was in position on the…Feb 13, 1991 · N2282T · 2 aircraft · Substantial damageNTSB ANC91LA029Accident · No injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe pilot-in-command's failure to maintain directional control.Feb 13, 1991 · N6446K · Substantial damageNTSB ANC91IA028Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Unalaska, AKThe windshear encountered on short final. Contributing to the accident was the rising terrain within 150 feet of the runway, the variable nature of the wind due to the rising terrain, and the pilot's failure to maintain lateral control during the go around.Feb 13, 1991 · N672MA · Minor damageNTSB NYC91LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Mount Gilead, OHThe pilot's improper use of carburetor heat resulting in an engine failure due to carburetor ice and a subsequent off airport landing in unsuitable terrain.Feb 12, 1991 · N2859S · Substantial damageNTSB LAX91LA107Accident · No injuriesLimited investigationFinal reportQuestaire Venture · San Luis Obispo, CAThe failure of the fuel system vent check valve, which resulted in fuel starvation to the aircraft's engine.Feb 12, 1991 · N71T · Substantial damageNTSB FTW91LA037Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Brownsville, TXThe pilot's failure to refuel the airplane prior to his departure on the last leg of the flight, which resulted in fuel exhaustion.Feb 12, 1991 · N210YB · Substantial damage