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 NYC90IA050Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Philadelphia, PAThe flight crew of EAL121 taking off on a taxiway. Contributing was failure of the flight crew of eal 121 to maintain an adequate visual lookout during taxi and takeoff.NTSB ATL90MA051Accident · 2 fatalMajor investigationFinal reportLearjet 23 · Ansonia, OHThe flight crew became incapacitated for undetermined reasons and lost control of the airplane.NTSB ATL90LA052Accident · Serious injuriesLimited investigationFinal reportAero Commander 680E · Knoxville, TNThe pilot's excessive airspeed and delay in initiating a go-around during the landing. Factors related to the accident were: the wet runway condition, the pilot's failure to attain the proper touchdown point for the landing, and his lack of flying experience…NTSB MIA90LA057Accident · No injuriesLimited investigationFinal reportBeech 400 · West Point, MSThe pilot misjudged distance, speed, and altitude on final approach, and failed to attain the proper touchdown Point for landing.NTSB MIA90LA056Accident · Minor injuriesLimited investigationFinal reportCessna 404 · Boca Raton, FLLoss of power in the right engine due to a disconnected duct between the turbocharger and the plenum chamber. The reason for the loss of power in the left engine was not determined.NTSB DEN90LA045Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fort Morgan, COPartial loss of power due to an undetermined reason.NTSB DEN90FA043Accident · 1 fatalField investigationFinal reportCessna 208A · Leadville, CODiversion of the pilot's attention, resulting in an in flight collision with terrain during normal cruise flight.NTSB CHI90LA067Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Lafayette, INThe helicopter student's iproper use of the collective pitch lever during the landing phase of flight. The pilot's lack of total expereince, the relatively high wind, and inadvertent liftoff of the helicopter were factors related to the accident.NTSB CHI90FA066Accident · Serious injuriesField investigationFinal reportCessna 402A · Mosinee, WIThe pilot disregarding the published decision height and not performing a missed approach.NTSB CHI90FA065Accident · 1 fatalField investigationFinal reportCessna 402B · Appleton, WIThe pilot's decision to continue flight into known adverse weather conditions resulting in a windshear encounter with insufficient altitude for recovery. The existing adverse weather conditions were factors.NTSB NYC90LA056Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Danbury, CTImproper maintenance, inadequate surveillance by the company/operator, and inadequate preflight by the pilot, which resulted in a fire during an attempted engine start. A factor related to the accident was: the unsecured fuel line.NTSB NYC90FA054Accident · 3 fatalField investigationFinal reportCessna 310R · Burlington, VTFor an unknown reason, the aircraft entered a descent and crashed in a lake.NTSB MKC90FA044Accident · Serious injuriesField investigationFinal reportCessna P210N · Newton, KSLoss of engine power for an undetermined reason. Darkness and the resultant delay in flaring to land were related factors.NTSB DEN90LA046Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · New York, NYOverrotation of the aircraft during takeoff. Factors related to the accident were: the first officer's improper use of the flight manual, which resulted in his improper calculations of the rotation speed, and inadequate supervision concerning verification of…NTSB DEN90LA044Accident · No injuriesLimited investigationFinal reportCessna 182 · Frederick, COA partial engine power loss induced by stuck intake valves. Contributing to the accident was the inadequate maintenance of the airplane and the unsuitable terrain in which the forced landing was performed.NTSB MKC90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Dexter, MOThe pilot misjudged his distance and altitude on final approach, and failed to reach the proper touchdown point for landing. The gusty crosswind condition was a related factor.NTSB MIA90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Immokalee, FLThe loss of engine power due to an undetermined reason. A factor related to the accident was: rough terrain in the emergency landing area.NTSB DEN90FA042Accident · Serious injuriesField investigationFinal reportFairchild SA227-AC · Elko, NVImproper IFR procedure by the captain, and inadequate monitoring of the approach by the first officer, which resulted in a failure to maintain proper altitude during the approach. Factors related to the accident were: the terrain and weather conditions at the…NTSB ANC90FA027Accident · No injuriesField investigationFinal reportBeech E18F · Anchorage, AKInadequate supervision by company/operator personnel and inadequate preflight planning/preparation by the captain, which resulted in an improperly loaded aircraft.NTSB NYC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Northampton, MAPilot's improper handling of the airplane, resulting in the loss of directional control. Contributing to the accident were gusty wind conditions and the pilot's lack of total experience.NTSB MKC90LA047Accident · Serious injuriesLimited investigationFinal reportBurnett Starduster TOO · Lawrence, KSThe pilot misjudged clearance from tree(s) near the approach end of the runway, while on final approach to land. Factors related to the accident were: sunglare, lack of visual cues to the pilot, and tree(s).NTSB MIA90LA055Accident · Minor injuriesLimited investigationFinal reportConn ONE Design · Daytona Beach, FLFuel starvation due the fuel vent being blocked by a mud dauber nest and the pilot's failure to find the obstruction (inadequate preflight) before taking off. Trees beyond the departure end of the runway were a related factor.NTSB LAX90LA271Accident · 1 fatalLimited investigationFinal reportCessna R172K · Lone Pine, CAThe pilot's decision to continue VFR flight into instrument meteorological conditions. Factors to the accident were the adverse weather conditions, mountainous terrain, and the likely effect of hypoxia on the pilot.NTSB FTW90LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Liberty, TXLoss of engine power due to failure of the tappet faces. A factor in the accident was the unsuitable terrain in which the forced landing was made.NTSB FTW90LA053Accident · No injuriesLimited investigationFinal reportCessna A185F · Houston, TXInadequate compensation for wind conditions by the pilot, and his failure to maintain directional control. The unfavorable wind was a related factor.NTSB MKC90LA046Accident · No injuriesLimited investigationFinal reportCessna 150 · York, MNPowerplant failure due to undetermined causes.NTSB MIA90LA053Accident · No injuriesLimited investigationFinal reportBeech E185 · Wauchula, FLLoss of air pressure in the left main tire during flight, which resulted in a ground swerve during the landing and a nose over as the pilot was correcting with opposite brake and rudder.NTSB FTW90LA056Accident · No injuriesLimited investigationFinal reportCessna 170 · Crockett, TXThe failure of the main landing gear axle due to fatigue which led to a loss of control after touchdown.NTSB DEN90FA041Accident · 3 fatalField investigationFinal reportCessna 182P · Tom'S Place, CAContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above the ground. Factors related to the accident were: dark night, adverse weather conditions, self induced pressure, and spatial…NTSB MKC90LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hornersville, MOPoor judgement of the pilot due to consumption of alcohol, and his misjudgement of distance and altitude to the runway, while on final approach, which subsequently resulted in a touchdown and nose over short of the runway.NTSB MIA90LA052Accident · No injuriesLimited investigationFinal reportCessna 210M · Ocala, FLSeparation of the throttle plate, due to improper securing of the attach screws during an overhaul.NTSB LAX90LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe failure of the pilot to maintain directional control and compensate for gusty wind conditions which resulted in a hard landing.NTSB FTW90FA051Accident · 1 fatalField investigationFinal reportBell UH-1B · San Diego, TXThe pilot intentionally flew into instrument meteorological conditions during night VFR flight, and the helicopter subsequently collided with terrain.NTSB DEN90LA040Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Ft Collins, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the aircraft.NTSB DEN90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Provo, UTFuel starvation due to pilot misjudgement of fuel requirements for the trip and a failure to refuel the airplane en route.NTSB ANC90LA026Accident · No injuriesLimited investigationFinal reportCessna 207A · Nondalton, AKImproper planning/decision by the pilot. Factors related to the accident were: inadequate positioning of the temporary runway markers, snow covered runway/terrain conditions, partial whiteout condition, and the snow berms at the edges of the runway.NTSB SEA90LA035Accident · 1 fatalLimited investigationFinal reportStanger Aircommander 532 · Hansen, IDFailue of the pilot to maintain control of the gyrocopter after entering an abrupt pull-up from a low pass. Factors related to the accident were: failure of the pilot to follow procedures/directives, his lack of certification (qualification) for this flight,…NTSB NYC90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Messena, NYThe airplane striking a light pole during an off airport landing on a road, due to a double power loss for unknown reasons. Factors related to the accident were: the pilots unfamiliarity with the airplane.NTSB FTW90LA052Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Mineola, TXThe pilot's misjudgement of the proper touchdown point on the runway surface. Related factors were: darkness and partial failure of the lighting system.NTSB DEN90LA038Accident · No injuriesLimited investigationFinal reportCessna 182M · Pierre, SDInadequate compensation for the wind conditions by the pilot. An on ground encounter with wind gusts is considered an additional cause.NTSB ATL90LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lithia Springs, GAImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB CHI90IA064Incident · No injuriesIncident investigationFinal reportBoeing 747-151 · Detroit, MIA fire in the aft cargo compartment for undetermined reasons(s).NTSB BFO90LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Staunton, VAThe pilot's failure to maintain directional control of the airplane during a crosswind landing.NTSB SEA90LA034Accident · No injuriesLimited investigationFinal reportCessna 177B · Friday Harbor, WAFailure of the pilot to attain the proper touchdown point or go-around. Factors related to the accident concerned the runway condition.NTSB MIA90LA051Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Jacksonville, FLFailure of the owner/operator to obtain proper maintenance and inspection of the aircraft. Factors related to the accident were: operation of the aircraft by the pilot without a current annual inspection (known deficiency), an oil leak in the left engine…NTSB SEA90LA033Accident · No injuriesLimited investigationFinal reportCessna 172A · Reno, NVThe pilot's improper use of the flight controls. Factors in the accident were the high, gusty wind conditions, the pilot's self induced pressure to arrive at work on time, and his lack of total pilot experience.NTSB NYC90LA047Accident · Minor injuriesLimited investigationFinal reportBeech V35B · W Kingston, RIFailure of the pilot to maintain control of the aircraft, while attempting to close the passenger's door during takeoff. The unsecured passenger door was a related factor.NTSB NYC90LA046Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Kutztown, PAImproper decision of the glider pilot to exit the glider without positive assurance that the tow pilot had received his signal or that the glider was released from the tow plane. A related factor to the accident was: the lack of crew coordination between the…NTSB MKC90LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOFailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind condition, the student's lack of total experience, and the building (hangar).NTSB LAX90LA067Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Van Nuys, CAThe pilot's failure to maintain adequate airspeed during final approach which allowed the aircraft to stall and collide with the runway.