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 CHI99FA129Accident · 2 fatalField investigationFinal reportCessna 152 · Superior, WIthe Certified Flight Instructor failed to maintain control of the airplane.NTSB ATL99LA071Accident · Serious injuriesLimited investigationFinal reportHoskins Craig Lightning BUG · Crystal River, FLThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall.NTSB ANC99LA046Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Kenai, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was high winds.NTSB ANC99FA047Accident · 1 fatalField investigationFinal reportCessna 207A · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions, spatial disorientation, and an inadvertent stall. Factors in the accident were weather conditions consisting of snow and mist, and flat lighting conditions.NTSB SEA99LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Puyallup, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB FTW99LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Sheridan, ARThe pilot's excessive landing approach speed and his failure to attain the proper touchdown point which resulted in a runway overrun.NTSB CHI99LA128Accident · No injuriesLimited investigationFinal reportCessna T-188C · Dalton, NEthe improper adjustment of the fuel pump by maintenance personnel. Factors to the accident were the excessive output of the fuel pump, trees, residential structure, fence, and propane tank.NTSB NYC99LA092Accident · No injuriesLimited investigationFinal reportSaab-Scania 340B · Boston, MAThe belt-loader driver's loss of control of the vehicle, and his failure to follow published procedures for approaching the airplane with the belt-loader.NTSB NYC99LA089Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Stiefler Corner, PAThe pilot diverting his attention inside the cockpit, and allowing the airplane to enter instrument meteorological conditions, resulting in an in-flight collision with a tree.NTSB MIA99LA124Accident · Minor injuriesLimited investigationFinal reportBean Whitman W-10 · Wimauma, FLThe pilot's failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with a ditch and subsequent nose over.NTSB MIA99FA125Accident · 2 fatalField investigationFinal reportPiper PA-16 · Hardeeville, SCAn inflight loss of control for undetermined reasons while in a descent and the subsequent collision with the terrain.NTSB LAX99LA165Accident · No injuriesLimited investigationFinal reportParker Vans RV-4 · Red Bluff, CAA crack which developed in the automotive-type oil cooler of the experimental, amateur built aircraft and permitted the engine oil supply to flow overboard.NTSB IAD99FA038Accident · 4 fatalField investigationFinal reportBeech BE-95A · Shawsville, VAthe pilot's inadequate preflight planning which resulted in intentional flight into known severe turbulence and the subsequent loss of control. Factors in the accident were the turbulence in instrument meteorological conditions and an airplane loaded over the…NTSB MIA99LA129Accident · No injuriesLimited investigationFinal reportMbb BK 117 A-3 · Sarasota, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering in a hover resulting in the tail rotor colliding with a building.NTSB MIA99LA122Accident · Serious injuriesLimited investigationFinal reportHarris VARI-EZE · Eufaula, ALThe loss of engine power for undetermined reasons.NTSB FTW99LA115Accident · Minor injuriesLimited investigationFinal reportDavis/Cleaver Renegade 2 · Port Allen, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA127Accident · No injuriesLimited investigationFinal reportReindl Quickie 2 · Olathe, KSThe loss of engine power for undetermined reasons. A factor associated with the accident is the lack of suitable terrain for a forced landing.NTSB ANC99LA045Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Chevak, AKThe pilot's inadequate in-flight planning/decision, and his failure to attain the proper touchdown point on the runway. Factors in the accident were a tail wind condition, and the presence of snow and ice on the runway surface.NTSB SEA99LA059Accident · No injuriesLimited investigationFinal reportCessna 172D · Glenns Ferry, IDThe failure of both pilots to see-and-avoid wires crossing the river. Factors included: transmission wires; inattention of both pilots to the aircraft's flight path; and the pilots' low-altitude flight.NTSB SEA99LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Boulder, MTThe pilot-in-command's failure to maintain directional control after encountering a dust-devil during landing rollout, resulting in a ground loop and collapse of the main landing gear. Factors include the dust-devil.NTSB LAX99LA145Accident · No injuriesLimited investigationFinal reportCessna 172H · North Las Vegas, NVThe pilot's failure to maintain directional control during takeoff roll resulting in a collision with taxiway sign. A factor was the sign.NTSB LAX99LA143Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · North Las Vegas, NVThe pilot's failure to ensure that all loose items inside the cockpit were secure before attempting aerobatic maneuvers.NTSB CHI99LA130Accident · No injuriesLimited investigationFinal reportBell 206B · Cloquet, MNThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pole and dusk light conditions.NTSB CHI99LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mora, MNthe student pilot's improper soft field takeoff technique in that excessive back pressure was used which resulted in an inadvertent stall/mush. A factor associated with the accident was the student's lack of total experience.NTSB LAX99LA142Accident · Minor injuriesLimited investigationFinal reportWitzel Glassair II FT · Casa Grande, AZThe pilot's inadequate compensation for the existing crosswind condition.NTSB FTW99LA113Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Franklinton, LALoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA126Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Atchison, KSThe loss of engine power for unknown reasons.NTSB CHI99IA136Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Dubuque, IAthe frozen elevator control. Factors to the incident were the rain and the low temperature.NTSB MIA99LA121Accident · No injuriesLimited investigationFinal reportFrederick Sweet Rotorway Exec · Fort Myers, FLThe pilot-in-command's failure to maintain aircraft control after the ground tie chain separated during engine run and hovering operations.NTSB DEN99LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dulce, NMThe pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…NTSB CHI99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · North Platte, NEThe pilot's inadequate compensation for gusty wind conditions. Factors associated with the accident were the gusty, high, wind conditions, and the pilot's continued flight into adverse weather.NTSB SEA99LA048Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Pendleton, ORA loss of power due to water contamination of the fuel. Factors include the inability of the helicopter to perform a successful autorotation immediately after takeoff.NTSB MIA99LA119Accident · No injuriesLimited investigationFinal reportDavid C. Bock Challenger II · Astatula, FLThe aircraft structure fluttering inflight resulting in fracture of fuselage longerons and the pilot being unable to maintain control.NTSB MIA99LA118Accident · No injuriesLimited investigationFinal reportSteve Hill Staudacher S600 · Bunnell, FLThe pilot's improper fuel consumption calculations which resulted in fuel exhaustion.NTSB FTW99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Turrell, ARThe total loss of engine power as the result of improper maintenance which led to the number one cylinder intake valve rocker assembly stud bolt backing out rendering the valve inoperative. A factor was the lack of suitable terrain for the forced landing.NTSB DCA99RA053Accident · 6 fatalForeign investigationBoeing 737-400 · Ceyhan Adana, TürkiyeNTSB CHI99LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Flint, MIThe loss of engine power for undetermined reasons. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB CHI99LA122Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Vienna, ILThe worn ignition points/cam follower assembly, and uneven landing terrain.NTSB SEA99LA047Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Emmett, IDThe pilot's failure to maintain aircraft control during a low-altitude maneuver to view a coyote on the ground. A related factor was the pilot's low altitude.NTSB IAD99LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Zelienople, PAThe pilot's inadequate preflight planning to practice crosswind landings in wind that exceeded the airplane's demonstrated capability and his failure to maintain directional control. A factor in the accident was the high wind.NTSB FTW99LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Cleburne, TXThe pilot's failure to maintain adequate altitude/ clearance from the wires.NTSB ATL99LA069Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Nashville, TNThe pilot's inflight decision to land on a runway with a strong cross wind, rather then on a runway into the wind. A factor was the strong cross wind conditions.NTSB ANC99LA044Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fairbanks, AKThe pilot's failure to attain the proper touchdown point on the runway. Factors in the accident were snow showers and snow-covered terrain.NTSB LAX99LA140Accident · Minor injuriesLimited investigationFinal reportCessna 210D · El Monte, CAA loss of engine power due to the fatigue failure of the mixture control cable, which was due to the improper installation and adjustment of the cable 99 hours prior to the accident.NTSB FTW99WA109Accident · No injuriesForeign investigationBell UH1-B · Mexico City, MexicoNTSB FTW99LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Midlothian, TXThe pilot's failure to maintain clearance with the powerlines. Factors were the low ceilings and the dusk light illumination.NTSB FTW99LA106Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Kingston, OKThe failure of the pilot-in-command to maintain control of the airplane during the landing roll. A factor was the gusty wind conditions.NTSB FTW99LA105Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Shawnee, OKThe improper flare during an autorotation by the pilot-in-command. A factor was the loss of engine power for an undetermined reason.NTSB ATL99LA068Accident · Minor injuriesLimited investigationFinal reportVans RV-6A · Cedar Creek, NCThe soft runway surface.NTSB ATL99LA067Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Lantana, FLThe pilot's failure to secure the engine oil filler cap during the preflight inspection that resulted the subsequent loss of engine power, and his in-flight decision to attempt a single engine go-around with full wing flaps extended.