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 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.NTSB MIA91WA088Accident · No injuriesForeign investigationBeech C23 · Alice Town, BahamasNTSB 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…NTSB 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.NTSB FTW91DPG02Accident · No injuriesFinal reportGrumman G-164A · Light, ARThe pilot's selection of the downwind runway for landing. A factor was the tailwind.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI91LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, ILThe pilot in command's poor preflight planning and improper weather evaluation.NTSB 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.NTSB 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.NTSB SEA91LA053Accident · No injuriesLimited investigationFinal reportBeech 95 · Roundup, MTPartial loss of power for undetermined reasons.NTSB 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…NTSB 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.NTSB LAX91LA109Accident · No injuriesLimited investigationFinal reportRockwell S2R-600 · Corcoran, CAFailure of the aircraft engine's fuel pump valve assembly bypass.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX91LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · San Carlos, CAThe pilot's improper flare landing.NTSB 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.NTSB LAX91LA102Accident · No injuriesLimited investigationFinal reportCurtiss-Wright E-4000 · Watsonville, CAThe inadequate design and length of the tailwheel assembly cable.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC91LA030Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Kodiak, AKA loss of control and collision with terrain after the helicopter entered a whiteout condition.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB SEA91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot did not maintain directional control of the airplane during the landing roll.NTSB 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.NTSB 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.NTSB LAX91LA100Accident · Minor injuriesLimited investigationFinal reportMaule M-6-235 · Mobile, AZThe pilots' failure to establish a sufficient climb rate to avoid striking a fence.NTSB 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…NTSB ANC91LA029Accident · No injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe pilot-in-command's failure to maintain directional control.NTSB 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.NTSB 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.NTSB 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.NTSB 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.