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 ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.NTSB ATL92LA170Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisburg, NCThe passenger's inadvertent interference with the flight controls.NTSB ANC92FA148Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKMisjudgment by the pilot to insure adequate distance from objects in the takeoff area, which resulted in damage to the main landing gear on takeoff, and the uncontrolled ground loop by the pilot during a landing with the damaged landing gear. Factors related…NTSB SEA92LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAInadequate visual lookout by the other pilot.NTSB NYC92LA183Accident · Minor injuriesLimited investigationFinal reportBeech A24 · Griswold, CTThe pilot failed to maintain control of the airplane which resulted in the airplane touching down short of the intended touchdown point, and collapsing the landing gear.NTSB FTW92LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Angel Fire, NMThe pilot's inadequate evaluation of the environmental conditions which resulted in exceeding the climb capability of the aircraft. The inadvertent stall was also a cause. Factors were the downdraft and high density altitude.NTSB CHI92DEP04Accident · Minor injuriesFinal reportGrumman 164A · Elkhorn, WIThe pilot-in-command's inadequate compensation for wind conditions.NTSB ATL92IA169Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Chattanooga, TNThe failure and subsequent seizure of the reduction gear box, and the failure of the propeller control unit as a result of contaminated oil supply which is shared with the gear box.NTSB ANC92LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Sparrevohn, AKPilot exercised poor preflight planning/preparation by taking off with a tailwind component. Factors relating to the accident were: the unfavorable wind in the area and the rising hilly/mountainous terrain in the takeoff path.NTSB SEA92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Blackfoot, IDThe pilot's failure to use proper airspeed for takeoff, resulting in loss of control during initial climb. Factors relating to the accident were the high da weather conditions, power line obstructions and a highway with a dirt bank at the end of the runway.NTSB NYC92LA184Accident · Minor injuriesLimited investigationFinal reportWilliam C. Keiling Prober Pixie · Cumberland, MDAn inadvertent stall/spin, following a power loss due to fuel contamination. Factors related to the accident were the failure of the pilot to detect the rust particles and water in the fuel system prior to takeoff and his lack of total experience in the…NTSB NYC92LA181Accident · Minor injuriesLimited investigationFinal reportBeech A24 · Simsbury, CTA power loss due to a fuel line blocked with dirt and sludge, while operating over unsuitable terrain. A factor related to the accident was the failure of the owner/pilot to detect the dirt and sludge in the fuel system prior to takeoff.NTSB MIA92LA169Accident · No injuriesLimited investigationFinal reportCessna 425 · Greenwood, MSFailure of the pilot-in-command to maintain his descent rate resulting in an undershoot. Contributing to the accident was the chip detector failure due to improper quality control by the manufacturer.NTSB ANC92LA151Accident · No injuriesLimited investigationFinal reportCessna 185E · Yakutat, AKThe pilot in command not maintaining directional control of the airplane.NTSB ANC92IA147Incident · No injuriesIncident investigationFinal reportShort Brothers SH-7 · Sheldon Point, AKThe unlatching of the left crew entrance door by means undetermined and the lack of adherence to door check items by the pilot in command on the requisite checklists. A factor relating to the incident was the separation of the door from the frame when opened…NTSB SEA92LA199Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bucoda, WAThe failure of the pilot to maintain proper alignment while landing on water, resulting in a swerve during deceleration.NTSB MIA92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Hill, FLFailure of the pilot-in-command to level off during the simulated forced landing.NTSB LAX92LA371Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Casa Grande, AZThe pilots inadequate compensation for the existing wind conditions. The gusty nature of the cross wind condiitons encountered was a factor.NTSB LAX92LA370Accident · No injuriesLimited investigationFinal reportCessna 150G · Woodland, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. Factors in the accident were the students lack of total experience and the soft nature of the recently plowed field the aircraft encountered.NTSB LAX92LA369Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Atwater, CAThe partial loss of engine power for undetermined reasons and the pilots failure to attain the proper touchdown point during the subsequent forced landing attempt back on the runway. Factors in the accident were the tail wind condition encountered during the…NTSB FTW92DQG02Accident · 1 fatalFinal reportWoodstock AIR Command 532 · Dumas, TXThe pilot's failure to maintain airspeed. A factor was the high density altitude.NTSB DEN92FA088Accident · 4 fatalField investigationFinal reportCessna 175A · Pagosa Springs, COThe pilot experiencing spatial disorientation and his failure to maintain aircraft control. Factors were: the pilot's total lack of instrument experience and dark night conditions.NTSB CHI92LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INThe pilot's failure to maintain directional control during the landing roll.NTSB CHI92LA259Accident · No injuriesLimited investigationFinal reportMooney 20F · Lacon, ILThe pilot's failure to recognize that the runway he selected for landing was closed. Factors which contributed to the accident were: the pilot's anxiety following the near-collision, and his limited ability to detect the orange-colored marking.NTSB CHI92LA258Accident · Minor injuriesLimited investigationFinal reportChristen Industries S2B · Alton, ILThe pilot's failure to accomplish refueling.NTSB CHI92FA257Accident · 3 fatalField investigationFinal reportCessna 310D · Crystal, MNThe pilot's failure to maintain aircraft control during takeoff/initial climb in gusty, shifting crosswind conditions.NTSB NYC92LA180Accident · No injuriesLimited investigationFinal reportPiper PA-46-350 · Sanford, METhe pilot did not follow IFR procedures when he disregarded the decision height limitation and failed to initiate a missed approach which resulted in the airplane striking trees.NTSB LAX92LA368Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Temecula, CAThe shutdown of the engine due to the failure of the muffler and the resulting heat induced shorting of the magneto ground wires, and the inadequate maintenance inspection of the muffler and the engine exhaust system.NTSB LAX92FA367Accident · 1 fatalField investigationFinal reportCessna 182Q · Santa Paula, CAThe failure of both pilots to see and avoid each other. Contributing to the accident was the azimuth of the setting sun and the Cessna 182 pilots non standard flight pattern.NTSB CHI92IA260Incident · No injuriesIncident investigationFinal reportDouglas DC-8-61 · Morton Grove, ILFailure of the right main landing gear door actuator.NTSB ATL92LA168Accident · No injuriesLimited investigationFinal reportBeech C23 · Pageland, SCThe pilot's improper touchdown, resulting in an overload failure of the nose gear attachment support tubes. Factors were the lack of total experience of the pilot and the ditch adjacent to the runway.NTSB MIA92LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Miami, FLFailure (short) of a diode located inside a transformer which is located in the no. 1 generator control unit.NTSB LAX92LA366Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Fresno, CAThe loss of engine power due to carburetor icing and the failure of the pilot to use carburetor heat.NTSB FTW92LA219Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, ARThe pilot's inadequate visual lookout while maneuvering at low altitude.NTSB CHI92TL#02Accident · No injuriesClass 3Final reportSikorsky S-58ET · North Platte, NENTSB ATL92FA167Accident · 2 fatalField investigationFinal reportCessna 402B · Miramar, FLThe failure of the pilot to perform preflight planning in that the weight and balance of the aircraft were exceeded. The pilot's lack of experience in the type of aircraft and lack of multiengine certification.NTSB SEA92LA191Accident · No injuriesLimited investigationFinal reportHelio H-391B · Edmonds, WAThe partial loss of engine power when an exhaust valve seized in the open position and the water where the pilot was forced to land, which resulted in an acft nose over on touchdown.NTSB LAX92LA364Accident · No injuriesLimited investigationFinal reportCessna 140 · Reedley, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll and his excessive use of the brakes.NTSB CHI92LA256Accident · No injuriesLimited investigationFinal reportCessna A185F · St. Cloud, MNFailure of the pilot-in-command to abort takeoff before overrunning the lake edge.NTSB ANC92LA146Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKProper touchdown point was not attained by the pilot. Factors related to the accident were: the tailwind and the improper approach procedure used by the pilot, an inadequate background check of pilot in hiring by company/mgmt, inadequate training and check of…NTSB SEA92LA190Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Mattawa, WAThe inadvertent locking of the acft brakes while landing by the PIC, resulting in an acft nose over on the gravel strip.NTSB NYC92LA182Accident · No injuriesLimited investigationFinal reportCessna 172H · New Cumberland, WVThe pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…NTSB FTW92FA218Accident · 3 fatalField investigationFinal reportFairchild SA 227-AC · Hot Springs, ARInadequate maintenance and inspection by the operator's maintenance personnel, and the failure of the pilot-in-command to assure proper travel direction of the airplane's primary flight controls after being made aware of the nature of the maintenance…NTSB FTW92DQG01Accident · Minor injuriesFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's selection of a downwind runway for takeoff. A factor was the tailwind.NTSB DEN92LA087Accident · No injuriesLimited investigationFinal reportCessna 172F · Folsom, NMCarburetor heat not used and improper use of throttle and mixture control. A factor was: the lack of suitable terrain for a forced landing.NTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.NTSB CHI92FA254Accident · 1 fatalField investigationFinal reportCessna 172N · Marquette, MIThe pilot's failure to maintain proper altitude during the approach.NTSB ATL92LA166Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · St. Augustine, FLThe failure of the engine's exhaust valve rocker arm.NTSB ATL92LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greensboro, NCThe failure of the pilot in command to maintain control of the airplane, and his improper use of the rudder during a go-around.NTSB ATL92LA164Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Surfside Beach, SCThe failure of the main landing gear as a result of inadequate manufacturing.