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 ATL89FA196Accident · 1 fatalField investigationFinal reportBeech A-36 · Chapel Hill, NCThe pilot's failure to maintain control of the airplane while maneuvering for a landing. Contributing factors were: the pilot's failure to follow the emergency procedures for an autopilot malfunction, and pilot fatigue.NTSB ANC89LA181Accident · 4 fatalLimited investigationFinal reportCessna R172K · Anchorage, AKUndetermined.NTSB MKC89LA178Accident · No injuriesLimited investigationFinal reportBell 206B · Marys Home, MOThe failure of the pilot to maintain control of the helicopter.NTSB LAX89DVA09Accident · No injuriesFinal reportAero Commander S2R · Tranquillity, CAThe pilot's visual look-out was inadequate and that he failed to see the high vegetation upon landing. Factors relating to this accident are dark night and high vegetation.NTSB FTW89LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Terrell, TXThe pilot became lost during the flight and fuel exhaustion occurred which required an off airport forced landing.NTSB FTW89DQG05Accident · No injuriesFinal reportSchweizer G-164A · Sunray, TXA total power loss for undetermined reasons. A factor was the rough uneven terrain in which the pilot had to make the forced landing.NTSB DEN89LA193Accident · Serious injuriesLimited investigationFinal reportAerofab Lake LA-250 · Bullfrog, UTA submerged object in the landing area.NTSB ATL89DMG06Accident · 1 fatalFinal reportDammann N3-2 · Hendersonville, NCEngine failure due to carburetor ice.NTSB ANC89LA138Accident · Serious injuriesLimited investigationFinal reportCessna 207-A · Tanana, AKPilot-in-command's improper inflight planning and decisions. He flew into weather that was known to be adverse, and the environmental conditions adversely affected his ability to safely complete the flight.NTSB NYC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Nanuet, NYInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB NYC89LA187Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Mount Joy, PAThe pilot's delay in initiating a go-around, and his failure to maintain proper runway alignment. Factors related to the accident were: failure of the pilot to attain the proper touchdown point and the crop.NTSB NYC89IA185Incident · Minor injuriesIncident investigationFinal reportBoeing 727-254 · Boston, MAThe failure of the landing gear drag brace to unlock during landing. Contributing was the failure of pacific southwest airlines to catch the incorrect assembly. An additional factor was the use of faulty information by eastern airlines and their decision to…NTSB LAX89LA251Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZImproperly use of the flight controls by the pilot and his failure to maintain control of the helicopter.NTSB LAX89IA315Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Los Angeles, CAA fatigue crack in the right gear wheel well.NTSB FTW89LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Comfort, TXThe fuel exhaustion induced power loss which resulted from the fuel pilot's failure to accurately determine the amount of fuel available for the flight.NTSB DCA89IA066Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Denver, COFatigue failure and separation of a first-stage compressor fan blade.NTSB ATL89LA195Accident · Minor injuriesLimited investigationFinal reportCessna 210C · Millington, TNA loss of engine power, due to contamination in the fuel flow manifold. The contamination in the fuel system was due to inadequate maintenance.NTSB ATL89FA194Accident · 1 fatalField investigationFinal reportBeech E55 · Raleigh, NCThe pilot's loss of control due to spatial disorientation while operating in instrument weather conditions.NTSB ANC89LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Nebesna Glacier, AKThe pilot allowed the aircraft to inadvertently touch down, he delayed making a go-around, and he did not maintain sufficient speed to continue the go-around. Contributing factors were: the pilot's selection of unsuitable terrain, high vegetation in the…NTSB ANC89LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Sparrevohn, AKPilot-in-command's failure to maintained directional control of the airplane during takeoff. The misjudged terrain was a contributing factor in the eventual outcome.NTSB MKC89DCQ01Accident · 1 fatalFinal reportWSK PZL Mielec PZL-M-18-A · Ingalls, KSImproper preflight planning by the pilot and his failure to attain inadequate airspeed, which resulted in a stall/spin. As he was attempting to avoid a power transmission line. Factors related to the accident were: rising terrain, tall grass, tailwind and the…NTSB LAX89LA270Accident · Serious injuriesLimited investigationFinal reportBell 206B · Bakersfield, CAThe loss of engine power due to the helicopter being flown in exhaust gases emanating from a cogeneration plant chimney stack that exceeded the certification standards of the powerplant. Contributing to the accident was invisible nature of the exhaust gases…NTSB ATL89DLT05Accident · 1 fatalFinal reportBratton RB-1 · Springfield, TNImproper planning/decision by the pilot, which resulted in fuel exhaustion at a low altitude, due to an inadequate supply of fuel; and his failure to maintain airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: the…NTSB MKC89LA175Accident · Minor injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Indianola, IAFailure of the pilot to maintain clearance from the tv tower due to improper in-flight planning/decision. Unfavorable wind/windshear and the tall tower were contributing factors.NTSB LAX89LA269Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Chandler, AZAn engine power loss for undetermined reasons.NTSB LAX89LA267Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Terminal Island, CAThe fatigue failure of an exhaust valve due to excessive wear of the respective valve guide. Factors related to the accident were: the fence & cars in the emergency landing area.NTSB LAX89FA268Accident · 1 fatalField investigationFinal reportPiper PA-601P · Ramona, CAThe pilot's VFR flight in instrument meteorologial conditions (IMC) and spatial disorientation, which resulted in an inadvertent descent into the ground. Factors related to the accident were: darkness, low ceiling, and the pilot's lack of a preflight weather…NTSB DEN89LA189Accident · Serious injuriesLimited investigationFinal reportBell 206B · Georgetown, COImproper inflight planning/decision by the pilot. The high density altitude, tail wind, gusts, and terrain were related factors.NTSB CHI89DEM06Accident · No injuriesFinal reportCessna 152 · Manistee, MIThe partial loss of power during initial climbout, and the aircraft's subsequent nose over during the forced landing roll.NTSB SEA89LA148Accident · No injuriesLimited investigationFinal reportBell 206B · Boulder City, NVPilot displayed poor inflight planning while maneuvering. The pilot did not identify the wind conditions resulting in a loss of directional control. The pilot's corrective action was inadequate and as result, the helicopter collided with the terrain.NTSB NYC89LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Hammonton, NJThe pilot overshooting a landing during a precautionary landing due to deteriorating weather conditions. Contributing factor(s) was: the pilot's decision to attempt the flight after being advised that VFR flight was not recommended and inadequate preflight by…NTSB FTW89DRJ01Accident · Serious injuriesFinal reportCessna 150 · Piedmont, OKThe pilot's failure to maintain adequate airspeed while buzzing, which resulted in an inadvertent stall.NTSB DEN89LA190Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTMisjudgement of the proper touchdown point by the pilot, which resulted in an overrun of the landing area and collision with a post. The downhill terrain condition and location of the fence post were related factors.NTSB ANC89FA137Accident · 1 fatalField investigationFinal reportCessna 402 · Nome, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his improper in-flight planning/decision. The weather and terrain conditions were considered to be contributing factors.NTSB SEA89LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Mollala, ORPilot displayed poor judgement and did not adequately plan for the flight. The pilot was unfamiliar with the area and terrain conditions. As a result, the airplane was not able to attain sufficient altitude for the conditions to clear the terrain.NTSB NYC89LA191Accident · No injuriesLimited investigationFinal reportCessna 421C · Waterville, MEImproper planning/decision by the pilot, his failure to obtain NOTAMS, and failure of the approach controller to provide a safety advisory about the runway condition.NTSB NYC89FA183Accident · 2 fatalField investigationFinal reportBeech B24R · Wiscasset, METhe pilot's loss of control of the airplane and uncontrolled descent during attempted flight in instrument meteorological conditions.NTSB MKC89LA174Accident · No injuriesLimited investigationFinal reportStinson L-5 · Minneapolis, MNThe pilot selected the wrong runway and failed to maintain directional control. The crosswind was a contributing factor.NTSB MKC89DPG04Accident · Serious injuriesFinal reportRockwell S-2R · Moscow, ARInadequate visual lookout by the pilot. The guy wire was a contributing factor.NTSB MIA89LA216Accident · No injuriesLimited investigationFinal reportCessna 195B · Hollywood, FLThe failure of the left main landing gear spring due to low cycle fatigue, resulting in the loss of control of the ground.NTSB LAX89LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Monica, CAThe student pilot's improper flare and recovery from a bounced landing.NTSB LAX89LA262Accident · 1 fatalLimited investigationFinal reportCessna 172H · Dana Point, CAPilot-in-commands failure to maintain control of the airplane while in maneuvering flight.NTSB LAX89FA276Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Toms Place, CAFailure of the pilot to attain sufficient altitude to clear terrain obstructions before entering a high elevation basin. Contributing to the accident was a high density altitude which reduced the aircraft's climb performance to less than the rate of climb of…NTSB DEN89LA188Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper planning/decision by the pilot. The wind condition was considered to be a contributing factor.NTSB DEN89LA186Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lovell, WYImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to continue out of the canyon or turn around. The terrain and high density altitude were related factors.NTSB DEN89LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Louisville, COThe pilot's failure to adequately evaluate the weather prior to takeoff. High winds developed during the Balloon flight which resulted in a rough landing.NTSB DEN89FA184Accident · 1 fatalField investigationFinal reportCessna 172M · Albuquerque, NMThe pilot deliberately flew his aircraft into the face of a mountain. A contributing factor was: the psychological condition of the pilot.NTSB DEN89DTG01Accident · 1 fatalFinal reportCessna 188A · Valley City, NDInadequate visual lookout by the pilot. The power line was a related factor.NTSB CHI89LA162Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Garrettsville, OHThe pilot did not maintain adequate airspeed and allowed the aircraft to inadvertently enter a stall/spin. Turbulence was considered to be a contributing factor.NTSB CHI89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIThe pilot-in-command failed to properly compensate for unfavorable wind conditions.