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 DEN05LA093Accident · No injuriesLimited investigationFinal reportCessna 172N · Hudson, COThe flight instructor's improper use raising of the flaps. Contributing factors were the student pilot's misunderstanding of the instructor's intentions, the instructor's inadequate supervision of the student pilot, the density altitude, and the soft terrain.NTSB CHI05LA154Accident · No injuriesLimited investigationFinal reportCessna A188B · Washburn, NDThe separation of the tailwheel assembly, the pilot's directional control of the airplane not possible during the takeoff, and the unsuitable terrain the pilot encountered.NTSB CHI05LA149Accident · 1 fatalLimited investigationFinal reportCessna 188 · Senath, MOThe pilot's failure to maintain clearance from the tower guy wires. A factor was the extra antenna guy wire.NTSB CHI05CA150Accident · No injuriesData collectionFinal reportCessna 172P · St. Francis, KSThe pilot's failure to compensate for the crosswind conditions during landing and the unsuccessful go-around. A factor was the crosswind.NTSB ATL05CA119Accident · Minor injuriesData collectionFinal reportGlobe GC-1B · Athens, TNThe pilot's improper landing flare, which resulted in a hard landing.NTSB ATL05CA114Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Daytona Beach, FLThe private pilots improper landing flare. Factors were flight instructors inadequate supervision, and landing crosswind.NTSB ATL05CA107Accident · No injuriesData collectionFinal reportCessna 172 K · Panama City, FLThe pilot's inadequate planning of the fuel supply, which resulted in fuel exhaustion.NTSB ATL05CA104Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe CFI's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB LAX05LA210Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Phoenix, AZthe pilot's delay in executing a timely go-around and failure to raise the flaps, which resulted in a collision with terrain.NTSB LAX05LA209Accident · Minor injuriesLimited investigationFinal reportBeechcraft K35 · Apple Valley, CAfuel starvation due to the pilot's inadequate in-flight fuel system management and failure to set the fuel selector valve to a tank containing fuel. A factor was the ditch that the aircraft encountered.NTSB LAX05LA208Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Pasadena, CAa fuel starvation induced loss of engine power due a failure of the electric fuel pump. A factor in the accident was the dark night lighting conditions.NTSB LAX05FA213Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Mt. Shasta, CAThe pilot's continued cruise flight into instrument meteorological conditions, which resulted in the pilot's controlled flight into high mountainous terrain (CFIT).NTSB CHI05CA152Accident · No injuriesData collectionFinal reportCessna 172M · Rochester, MNThe pilot flared improperly and failed to recover from a bounced landing.NTSB ATL05LA103Accident · 1 fatalLimited investigationFinal reportRutherford Seawind 3000 · Sarasota, FLMaintenance personnel failure to secure throttle linkage on the carburetor which resulted in loss of engine power and a collision with a building.NTSB ATL05CA102Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Luka, MSLoss of engine power due to the total failure of the exhaust valve on the number 2 cylinder, and the pilot's misjudgment of speed/distance/altitude which resulted in a overshoot of the runway and subsequent in-flight collision with trees. A factor was the…NTSB SEA05LA120Accident · No injuriesLimited investigationFinal reportMBB BO-105 · Billings, MTThe pilot's improper in-flight decision to continue a simulated engine-out autorotation after sensing an excessive descent rate at 100 feet above the ground. Factors include the excessive descent rate, variable winds, and a high density altitude.NTSB NYC05CA101Accident · No injuriesData collectionFinal reportValentin Taifun 17E · Waterbury, CTThe pilots inadvertent encounter with a downdraft, which resulted in the airplane impacting trees.NTSB LAX05CA211Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Phoenix, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB IAD05MA078Accident · Serious injuriesMajor investigationFinal reportSikorsky S-76C · New York, NYAn inadvertent encounter with a left quartering tailwind. Factors in the accident were settling with power, the high gross weight of the helicopter, and the crew's failure to accurately assess the winds in the area.NTSB IAD05LA079Accident · No injuriesLimited investigationFinal reportCessna 414 · Butler, PAThe pilot's decision to conduct the flight with a known equipment deficiency. A factor was the tailwind condition.NTSB DFW05LA162Accident · 1 fatalLimited investigationFinal reportWsk-Pzl Mielec M18B · Eudora, ARThe pilot's failure to maintain clearance from the tree.NTSB DFW05CA163Accident · No injuriesData collectionFinal reportCarterCopter CarterCopter · Olney, TXThe pilot's inability to maintain control of the gyrocraft during a forced landing as a result of a loss of cyclic and collective control. Contributing factors were the sheared propeller drive pulley bolts, broken wire on the co-pilots cyclic boost control…NTSB DEN05LA091Accident · No injuriesLimited investigationFinal reportCessna 340A · Santa Fe, NMtotal failure of the main landing gear due to improper installation of the push-pull tubes by maintenance personnel, and their failure to follow proper procedures/directives.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.NTSB CHI05CA151Accident · No injuriesData collectionFinal reportKirby Christen Eagle · Wheeling, ILThe pilot's inadequate compensation for the wind conditions, and his failure to maintain obstacle clearance, which resulted in the airplane drifting during the landing flare and impacting the taxiway light.NTSB ATL05LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLA loss of engine power due to the connecting rod cap separation for undetermined reasons. Related factors were trees and the swampy terrain condition.NTSB SEA05LA118Accident · Minor injuriesLimited investigationFinal reportRash Vans RV-6A · Palouse, WALoss of engine power for undetermined reasons. Rising terrain was a factor.NTSB LAX05LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Happy Jack, AZThe fracture/separation of an engine intake valve during cruise flight, which resulted in a partial loss of engine power and a forced landing.NTSB DFW05CA164Accident · No injuriesData collectionFinal reportCessna 152 · Burneyville, OKThe students pilot's improper flare and his failure to maintain directional control of the airplane. A contributing factor was the bounced landing.NTSB CHI05CA144Accident · Serious injuriesData collectionFinal reportCessna 150M · Marcelles, MIThe total loss of engine power due to fuel exhaustion as a result of the CFI's inadequate supervision and inadequate planning/decision. The student pilot's inadequate preflight planning was a contributing factor.NTSB ATL05FA098Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Williamson, GAThe pilot's failure to follow the before takeoff checklist and attempted a takeoff with flaps extended, which resulted in an in-flight collision with trees.NTSB ATL05CA129Accident · No injuriesData collectionFinal reportLuscombe 8E · Orangeburg, SCThe pilot's failure to maintain directional control during landing roll.NTSB ATL05CA100Accident · No injuriesData collectionFinal reportGoodyear GZ-20A · Coral Springs, FLThe pilot's inadequate in-flight planning/decision which resulted in an in-flight encounter with weather (thunderstorm outflow), and downdrafts, loss of control and subsequent collision with trees and transmission wires.NTSB ATL05CA099Accident · Minor injuriesData collectionFinal reportCessna 150M · Panama City, FLThe pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.NTSB ATL05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Fort Payne, ALThe intentional unauthorized use of a stolen aircraft by an unqualified person which resulted in a hard landing and substantial damage to the airplane.NTSB ANC05LA088Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Anchorage, AKA lightning strike during a normal descent for landing, which resulted in structural damage to the airplane's left aileron.NTSB LAX05CA205Accident · Minor injuriesData collectionFinal reportCessna 177B · Fallon, NVthe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB IAD05LA077Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Southampton, NJA lack of lubrication for undetermined reasons which resulted in the failure of the Nos. 4 and 5 connecting rods, and a subsequent total loss of engine power. A factor in the accident was the furrowed cornfield.NTSB DFW05LA159Accident · 1 fatalLimited investigationFinal reportHughes 269A · Rusk, TXA loss of engine power for undermined reasons, and the subsequent collision with power lines and the ground. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA161Accident · No injuriesData collectionFinal reportCessna A188B · Osceola, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the prevailing crosswind.NTSB DEN05FA080Accident · Serious injuriesField investigationFinal reportSchweizer 269C · Pueblo, COthe flight instructor's failure to maintain control of the helicopter during the attempted autorotation after the loss of engine power for reasons undetermined. Contributing factors include the flight instructor's improper preflight planning, the high density…NTSB CHI05LA143Accident · No injuriesLimited investigationFinal reportThomas Zenith CH701 · Redford, MIThe total loss of engine thrust was the result of the propeller blades overstress separation from the propeller hub for an undetermined reason. An additional cause was the unsuitable terrain encountered during the forced landing.NTSB CHI05CA142Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Raymore, MOThe loss of total engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the unsuitable terrain encountered during the forced landing.NTSB CHI05CA141Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Maize, KSThe pilot's inadequate preflight planning that failed to ensure adequate takeoff performance, and his delay in aborting the takeoff.NTSB ANC05LA087Accident · No injuriesLimited investigationFinal reportCessna U206F · Homer, AKThe fracture of the airplane's nose gear scissor during landing, which resulted in a loss of control during the landing roll, and a nose down. A factor associated with the accident was the loss of nosewheel steering control.NTSB NYC05FA099Accident · Serious injuriesField investigationFinal reportBell 206L · New York, NYThe pilot's inadequate preflight planning, which resulted in an attempted takeoff with an overweight helicopter, and subsequent impact with a pier and water. Factors were a high ambient temperature and unfavorable winds.NTSB LAX05LA204Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Woodfords, CAthe pilot's failure to maintain an adequate airspeed while turning in strong wind conditions, which resulted in a stall/spin. A factor in the accident was the high density altitude.NTSB SEA05CA116Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Yellow Pine, IDThe pilot's delay in executing a go-around which resulted in his failure to obtain altitude/clearance with trees.NTSB MIA05FA123Accident · Serious injuriesField investigationFinal reportDouglas R4D-8 · Fort Lauderdale, FLThe inadequate maintenance inspection by company maintenance personnel/pilot and other maintenance personnel of the left engine resulting in a total failure of the master rod bearing, and nose case partial separation, which prevented the left propeller from…NTSB LAX05LA203Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Marble Canyon, AZthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around, which resulted in a stall.