NTSB investigations, 2000
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE year(c.\"eventDate\") = 2000 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 WHERE year(c."eventDate") = 2000 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 LAX00TA318Accident · Minor injuriesFinal reportBell 206L-1 · Los Angeles, CAThe probable loss of the main rotor tip weight on the red blade for undetermined reasons resulting in main rotor vibration and oscillation. Sideward movement during the ensuing emergency landing resulted in a dynamic rollover.NTSB LAX00FA320Accident · 2 fatalField investigationFinal reportCessna 182N · Las Vegas, NVThe pilot's continued visual flight into instrument meteorological conditions into rising terrain and the air traffic controller's failure to issue a Safety Advisory.NTSB IAD00FA079Accident · 1 fatalField investigationFinal reportMooney M20F · Jonestown, PAThe pilot's delay in aborting the landing, which resulted in a collision with transmission wires. Factors in the accident were the pilot's improper inflight decision to attempt a landing with a 14-knot tailwind, and his use of an unapproved pain medication.NTSB DEN00LA158Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Broomfield, COthe pilot's failure to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB CHI00LA287Accident · No injuriesLimited investigationFinal reportCessna 172R · New Lenox, ILThe pilot's failure to maintain directional control during landing. Factors to the accident were the pipe that was struck, the crosswind, and the pilot's runway selection.NTSB ANC00TA109Accident · Serious injuriesFinal reportPiper PA-18 · Port Heiden, AKThe pilot's inadequate weather evaluation and in-flight planning/decisions. Factors in the accident were turbulence, and a downdraft.NTSB SEA00LA173Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Council, IDthe fatigue failure of the crankshaft due to improper overhaul procedures. Factors include a soft area in the field where the forced landing took place.NTSB NYC00FA257Accident · 1 fatalField investigationFinal reportCessna 172L · Mill Creek, PAThe pilot's improper pre-flight planning, and in-flight planning decision to continue visual fight into deteriorating adverse weather conditions. Factors were the night conditions, low clouds and fog.NTSB LAX00LA339Accident · No injuriesLimited investigationFinal reportCessna 210E · Holbrook, AZThe lack of elevator control during final approach, for undetermined reasons, that resulted in a hard landing.NTSB LAX00LA315Accident · No injuriesLimited investigationFinal reportPitts S1S · Westminister, CAThe pilot of the Pitts misjudged the clearance while maneuvering under the Cessna.NTSB FTW00LA246Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Eudora, ARthe pilot's failure to maintain obstacle clearance while maneuvering.NTSB CHI00LA275Accident · No injuriesLimited investigationFinal reportFlurry Aventura II · Benton, ILthe pilot's inadvertent wheel down landing in water.NTSB CHI00LA274Accident · Minor injuriesLimited investigationFinal reportWidner Pietenpol Aircamper · Andover, MNThe trees and the unsuitable terrain for landing encountered during the forced landing. Factors were the side slip to avoid the trees initiated by the pilot, the fractured piston, and the cracked cylinder.NTSB MIA00LA253Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Chatom, ALthe pilot's improper preflight planning/decision and failure to ensure an adequate supply of fuel to safely complete the flight to his destination with adequate fuel reserves, which resulted in fuel exhaustion, subsequent engine failure, and a forced landing…NTSB MIA00LA252Accident · 1 fatalLimited investigationFinal reportPitts S1-T · Vero Beach, FLthe pilot's failure to maintain control in flight, which resulted in an uncontrolled descent, and collision with the ground.NTSB LAX00LA321Accident · No injuriesLimited investigationFinal reportFogerson Richard D RV-6A · El Monte, CAThe loss of engine power for undetermined reasons.NTSB LAX00LA313Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Cameron Park, CAfailure of the pilot to verify the seat latch was secure, resulting in the pilot's inability to reach the flight controls necessary to maintain directional control.NTSB LAX00FA314Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Poway, CAThe pilot's intentional flight into known adverse weather.NTSB CHI00LA280Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bolivar, MOThe pilot failed to maintain directional control of the airplane on landing. A factor associated with the accident was the crosswind.NTSB CHI00LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Plattsmouth, NEthe pilot's improper preflight planning, improper in-flight planning and decision not to land before exhausting the airplane's fuel. Factors relating to this accident were the power lines, the roadway, and the ditch.NTSB SEA00LA172Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Boise, IDAircraft control was not maintained during approach for landing.NTSB NYC00LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nantucket, MAThe pilot's failure to maintain the proper glide path to the runway. Factors related to the accident were the fog conditions and the pilot’s fatigue.NTSB NYC00LA241Accident · No injuriesLimited investigationFinal reportFreund Wittman W10 · Valley City, OHThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident was the crosswind condition.NTSB MIA00WA249Accident · 10 fatalForeign investigationCessna 208B · La Fortuna, Costa RicaNTSB MIA00LA254Accident · No injuriesLimited investigationFinal reportBeech D-45 · Jacksonville, FLthe pilot's improper landing flare which resulted the right wing dropping and impacting the runway.NTSB MIA00LA251Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Daytona Bch Sh, FLa loss of engine power due to undetermined reasons, that resulted in the aircraft being ditched.NTSB MIA00LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Cullman, ALfailure of the pilot to maintain directional control of the aircraft during the landing rollout, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it collided with a dirt bank.NTSB LAX00LA317Accident · No injuriesLimited investigationFinal reportSteinke Early Bird -JENNY · Chino, CAThe engine lost power for undetermined reasons and nosed over in a soft field during the resulting forced landing.NTSB LAX00LA312Accident · 1 fatalLimited investigationFinal reportCable-Breigler BG-12BD · Tehachapi, CAThe pilot exceeded the airspeed limit for operation of the flaps resulting in flap and wing overload and separation.NTSB LAX00LA311Accident · No injuriesLimited investigationFinal reportPerrucci Randall J Revolution MINI-500 · Gridley, CAThe fracture and separation of a control rod in the cyclic flight control system.NTSB LAX00FA310Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hilo, HIDeterioration and failure of the oil filter converter plate gasket, which resulted in a loss of engine power and a subsequent in-flight fire.NTSB IAD00LA070Accident · Minor injuriesLimited investigationFinal reportJordan Kitfox Model 1 · Waynesville, OHA broken carburetor jet needle, which blocked fuel from entering the carburetor's mixing tube and resulted in a partial loss of engine power.NTSB CHI00LA273Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Parsons, KSthe pilot not maintaining clearance from the fence post and not attaining the proper touchdown point. A factor was the fence post.NTSB CHI00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Superior, NEthe cracked number 7 cylinder exhaust valve. A factor relating to this accident was the tree.NTSB SEA00LA171Accident · No injuriesLimited investigationFinal reportCessna 180H · Roche Harbor, WAThe pilot's failure to adequately compensate for wind conditions during landing.NTSB SEA00LA170Accident · No injuriesLimited investigationFinal reportHughes 369E · Coolin, IDThe turbine outlet temperature indicating system was out of calibration. Factors included improper maintenance calibration, which resulted in the over temperature of the turbine assembly.NTSB NYC00FA240Accident · Serious injuriesField investigationFinal reportPiper PA-44-180 · Lake Hopatcong, NJThe flight instructor's improper placement of both fuel-selector switches, which resulted in a total loss of engine power on both engines.NTSB NYC00FA239Accident · Serious injuriesField investigationFinal reportCessna 206H · Mayville, NYAn engine compartment explosion due to a fuel/fuel vapor leak of undetermined origin. A secondary explosion resulted from a lack of lubrication to the number 6 connecting rod bearing. Contributing to the pilot's injuries was his reduced visibility during the…NTSB MIA00WA277Accident · No injuriesForeign investigationSwearingen SA-226TC · Rosario, ArgentinaNTSB MIA00LA248Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Niceville, FLThe pilots failure to drop the advertising banner prior to a precautionary landing resulting in the aircraft stalling and landing hard. Contributing to the accident was the pilots failure to maintain airspeed during climb after banner pickup resulting in the…NTSB MIA00LA247Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fayetteville, TNthe pilot's failure to maintain adequate airspeed during the takeoff/initial climb, which resulted in an inadvertent stall/mush and collision with the runway that resulted in substantial damage to the airplane.NTSB CHI00LA270Accident · Minor injuriesLimited investigationFinal reportRaven AS-55A · Lincoln, ILThe pilot failed to maintain clearance with the power lines. Factors associated with the accident were the pilot's attention was diverted and the power lines which the balloon contacted.NTSB SEA00LA197Accident · No injuriesLimited investigationFinal reportBell 206BII · Newhalem, WADebonding between the elastomeric material and the center plate of the transmission isolation mount.NTSB LAX00LA357Accident · No injuriesLimited investigationFinal reportCessna 182G · Fallon, NVA hard landing by a pilot of a previous flight. Additional causes of the accident were an undershoot that resulted in a hard landing, and the CFI's failure to adequately supervise the flight.NTSB FTW00LA242Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Corsicana, TXthe in-flight separation of the propeller blade, which resulted from intergranular corrosion and fatigue cracking.NTSB FTW00FA245Accident · 1 fatalField investigationFinal reportCessna 421C · Hunt, TXthe loss of left engine power as a result of the owner's failure to overhaul the engine before further flight after the lubrication system was found contaminated with metal. Contributing factors were the pilot's decision to fly the aircraft with a…NTSB ANC00LA108Accident · 3 fatalLimited investigationFinal reportCessna 180 · Pilot Point, AKThe commercial certificated pilot, an owner of a fishing lodge, departed a remote area of beach with three passengers to return to the lodge. The accident airplane was one of two airplanes transporting lodge guests. The beach was located along an area of…NTSB NYC00RA249Accident · 2 fatalForeign investigationRobinson R-22 · DenmarkNTSB NYC00LA238Accident · No injuriesLimited investigationFinal reportAviat A-1B · Newberryport, MAthe failure of the pilot to maintain directional control during landing and a subsequent rejected landing. Factors were the crosswind, and the delayed corrective action by the pilot.NTSB MIA00WA246Accident · 3 fatalForeign investigationCessna 207 · Marieta, Venezuela