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 FTW89LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Conroe, TXFailure of the engine crankshaft due to fatigue. The low ceiling, dark night, and trees in the emergency landing area were factors.NTSB ATL89LA089Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wilmington, OHThe failure of the pilot to adequately compensate for wind conditions, to maintain proper runway alignment, and his delay in aborting the landing. Contributing factors were: variable crosswind conditions and a small tree.NTSB MIA89LA086Accident · No injuriesLimited investigationFinal reportAero Commander 500U · Daytona Beach, FLControl malfunction of undetermined cause that made further flight inadvisable.NTSB ATL89FA088Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Jackson, GAThe pilot's improper handling of the airplane which resulted in an inadvertent stall/spin and subsequent collision with terrain. Factors contributing to the accident were the pilot's decision to perform aerobatic maneuvers at low altitude, and complacency…NTSB SEA89LA049Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Beaver Marsh, ORAn loss of engine power due to a failed exhaust valve. Contributing to the accident was the snow covered terrain on which a precautionary landing was made.NTSB NYC89IA084Incident · No injuriesIncident investigationFinal reportBeech 200 · Burlington, VTImproper preflight which resulted in a frozen elevator surface.NTSB NYC89FA085Accident · Serious injuriesField investigationFinal reportDassault/Sud FAN JET Falcon D · Binghamton, NYImproper planning/decision by the pilot(s). Factors related to the accident were: icy runway conditions and failure of the drag chute to properly open after it was deployed.NTSB LAX89LA117Accident · No injuriesLimited investigationFinal reportCessna 182C · Adalanto, CAThe pilot was inattentive, did not maintain proper alignment with the runway and did not maintain an adequate visual lookout during takeoff.NTSB LAX89FA111Accident · 1 fatalField investigationFinal reportCessna 340A · Safford, AZThe pilot's poor judgement and the resultant hypoxia sustained in the unpressurized airplane. Factors were: the malfunctioning pressurization system and the pilot's decision to continue operation with that known discrepancy.NTSB ANC89LA044Accident · No injuriesLimited investigationFinal reportPiper J-5 · Skwentna, AKThe pilot's selection of unsuitable terrain. A contributing factor is the pilot's lack of experience in off airport landings.NTSB MIA89LA085Accident · No injuriesLimited investigationFinal reportCessna 340A · Jacksonville, FLSeizure of the right main landing gear upper downlock top bushing, and the failure of other maintenance personnel to properly rig the landing gear down light micro switches.NTSB LAX89LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Pacific Ocean (Pacific Ocean)Loss of oil pressure due to unknown circumstances. Contributing to the cause of the accident was the overweight condition of the airplane necessitated by overwater fuel requirements.NTSB LAX89LA108Accident · No injuriesLimited investigationFinal reportMooney M20J · San Martin, CAFailure of the student to follow instructions and inadequate supervision of the flight by the CFI which resulted in adequate airspeed not being maintained by the CFI. During an attempted go-around.NTSB LAX89IA112Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Los Alamitos, CAInadequate coordination among the ATC controllers which resulted in their failure to maintain adequate radar separation of the two aircraft.NTSB FTW89LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Seminole, TXThe pilot's delay in updating his weather and diverting to an alternate destination, which resulted in fuel exhaustion from lack of fuel. Contributing factors were: the pilot's inadequate preflight planning/preparation at the en route stop, the weather…NTSB FTW89FA049Accident · 3 fatalField investigationFinal reportMBB BK-117 A-1 · Tyler, TXThe pilot's failure to execute the published inadvertent IMC procedures when he encountered adverse weather conditions.NTSB DEN89LA077Accident · No injuriesLimited investigationFinal reportBalloon Works AX8-24 · Telluride, COIce forming in the fuel tank shut off valve, and the burner blast valve resulting in a loss of control during landing.NTSB MKC89LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNPremature raising of flaps and the failure of the instructor pilot to maintain runway alignment during the attempted go around.NTSB LAX89LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Sacramento, CAThe pilot's selection of the wrong runway for landing and his delay in initiating a go-around after landing long. Contributing factors were: light conditions as dusk and a tailwind.NTSB LAX89LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · Green Valley, AZThe student pilot displayed poor judgement in not maintaining proper altitude. A factor contributing to the accident was the pilot's overall lack of experience.NTSB LAX89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZThe pilot's failure to raise the wing flaps during the aborted landing, and his failure to maintain airspeed during the climbing right turn.NTSB LAX89FA106Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Julian, CAThe pilot's poor judgement of intentionally flying into an area of known forecast icing conditions which resulted in a loss of control and an inflight breakup of the aircraft. Contributing factors were the pilot's overconfidence in his personal ability by…NTSB CHI89LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Stevens Point, WIFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve.NTSB ATL89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Huntersville, NCFire resulting from an oil leak of undetermined origin in the area of the left engine.NTSB ATL89FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Jasper, TNThe pilot's improper handling of the airplane flight controls at low altitude which resulted in an excessive rate of descent and collision with a tree.NTSB NYC89LA083Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Yarmouth, MAA loss of engine power and subsequent forced landing which resulted from binding of the carbuerator throttle shaft. The binding resulted from an improper overhaul of the carbuertor approximately 10 flight hours prior to the accident.NTSB NYC89FA080Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Lyon Mountain, NYThe pilot decided to fly in weather conditions that were beyond his and the aircraft's capabilities.NTSB MKC89LA057Accident · No injuriesLimited investigationFinal reportCessna 150 · Wayland, MOThe pilot becoming lost during the flight which resulted in fuel exhaustion.NTSB MIA89LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · San Juan, PRThe failure of the pilot to properly use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB FTW89LA048Accident · Serious injuriesLimited investigationFinal reportPitts S2B · Walker, LALoss of total engine power due to fuel exhaustion. Fuel exhaustion occurred due to the pilot's failure to perform fuel consumption calculations. Contributing was the inadequate fuel quanity sight gauge in the rear cockpit, which was occupied by the PIC.NTSB DEN89FA076Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Saint George, UTMalfunction of the nosewheel steering system due to improper installation of the nosewheel steering poppet valve & inadequate maintenance instructions.NTSB CHI89LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Baldwin, WIFailure of the pilot to go around when he landed long with too much speed for the conditions. Factors related to the accident were: the pilot's excessive airspeed, his failure to attain the proper touchdown point, the crosswind, snowy/icy runway conditions,…NTSB ATL89LA085Accident · No injuriesLimited investigationFinal reportCessna 177B · Oneonta, ALInadequate preflight by the pilot and fuel exhaustion. Trees contributed to the aircraft damage.NTSB NYC89LA082Accident · No injuriesLimited investigationFinal reportCessna R172K · Ballston Spa, NYWorn connecting rod bearing(s), and failure of the #1 connecting rod. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB MIA89LA083Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fernandina Bch, FLLocking of the left brake, which resulted in a ground swerve and loss of control during the landing roll.NTSB ATL89DKG01Accident · No injuriesFinal reportGrumman G-164A · Dawson, GATotal loss of engine power due to leaking carburetor float. Contributing to the accident was the soft terrain used for a forced landing.NTSB ANC89FA043Accident · No injuriesField investigationFinal reportde Havilland DHC-3 · Fairbanks, AKFailure of the pilot to remove frost from the aircraft. Contributing factors were: improper weight and balance and snow covered terrain.NTSB LAX89FA103Accident · Minor injuriesField investigationFinal reportCessna 150K · Honolulu, HIInadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…NTSB FTW89MA047Accident · 1 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-32F · Salt Lake City, UTImproper in-flight planning/decision by the captain (pilot-in-command) and his improper use of the portable oxygen system, which resulted in his incapacitation due to hypoxia. Factors related to the accident were: inadequate maintenance/inspection of the…NTSB DEN89LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Gill, COImproper use of the powerplant controls by the CFI during descent through low temperature air.NTSB ATL89FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 310Q · Cleveland, OHAn uncontrolled descent into the water for undetermined reasons.NTSB ANC89FA042Accident · Serious injuriesField investigationFinal reportCessna 207 · Nome, AKThe partial loss of power resulting from fuel interruption due to a blockage in the engine fuel pump low pressure check valve.NTSB ANC89FA041Accident · 1 fatalField investigationFinal reportCessna U206G · Fairbanks, AKSeparation of the torsional vibration dampers from the crankshaft boss.NTSB SEA89LA048Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cottonwood, IDThe pilot misjudging his altitude due to the white out conditions. Contributing to the accident was the pilots lack of experience in this aircraft and this type of operation.NTSB MIA89LA081Accident · No injuriesLimited investigationFinal reportBell TH-1L · Greenville, FLInstallation of the improper sprag clutch assembly by the owners maintenance personnel resulting in failure of the sprag clutch and the loss of transmission drive.NTSB MIA89GA082Accident · Minor injuriesFinal reportCessna T210L · Melbourne, FLFailure of the pilot to accurately determine fuel quantity prior to departure followed by his failure to operate the engine on the fullest fuel tank resulting in a fuel tank being run dry resulting in engine failure while on short final approach at his…NTSB LAX89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Flagstaff, AZThe pilot's failure to maintain proper runway alignment while expediting to exit the runway. His lack of experience in this type of aircraft, self-induced pressure & the snow covered terrain were contributing factors.NTSB DEN89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COFailure of the dual student to maintain directional control and the failure of the pilot in command (CFI), to provide adequate remedial action in a timely manner, to correct the swerve. A second probable cause was the cfi's failure to provide adequate…NTSB DCA89RA023Accident · 144 fatalForeign investigationBoeing 707 · Santa Maria, PortugalNTSB CHI89FA049Accident · 3 fatalField investigationFinal reportCessna 172RG · Mosinee, WISpatial disorientation of the pilot as a result of initiating the flight into known adverse weather. Factors related to the accident were: dark night, snow, and low ceilings.