NTSB investigations, 2000
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 MIA00LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Monticello, MSThe failure of the pilot to maintain directional control during takeoff into crosswind conditions resulting in the collision with trees. A factor in the accident was the pilot's lack of familiarity with the aircraft.NTSB MIA00LA165Accident · No injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe student's failure to maintain the proper landing pattern altitude resulting in an undershoot during landing and collision with a fence. A factor in the accident was the pilot's failure to realize the spoilers were still deployed during the undershoot.NTSB FTW00WA172Accident · No injuriesForeign investigationFairchild F-27E · Coca, EcuadorNTSB FTW00LA152Accident · Serious injuriesLimited investigationFinal reportCameron V-90 · Frisco, TXThe pilot's inadequate passenger briefing for a high wind landing. A factor was the wind.NTSB FTW00LA149Accident · Serious injuriesLimited investigationFinal reportPZL-Mielec M-18A · Kilbourne, LAThe corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight.NTSB DEN00IA093Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Erie, COImproper installation of cylinders by unknown maintenance personnel who failed to torque the cylinder stud nuts sufficiently.NTSB CHI00LA144Accident · No injuriesLimited investigationFinal reportCessna C-T188C · Elgin, NDthe failure of the pilot in command to maintain clearance with the ground during an aerial application.NTSB CHI00LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Goshen, INthe failure of the student pilot to maintain directional control on the takeoff roll. Factors to the accident were the lack of experience of the student pilot and the improper use of the throttle.NTSB ANC00LA061Accident · No injuriesLimited investigationFinal reportCessna 402C · Cordova, AKAn in-flight collision with a bird.NTSB MIA00LA169Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Nashville, TNThe passenger's onboard disturbance and self-evacuation from the parked aircraft, resulting in injuries. A factor in the accident was the lack of backup electrical power to the terminal which necessitated a lengthy ground hold.NTSB LAX00LA202Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Boulder City, NVThe fracture and separation of the oil pressure line fitting, which resulted in a loss of oil and an oil starvation failure of the engine.NTSB LAX00LA201Accident · 1 fatalLimited investigationFinal reportIssoire-Aviation PIK-30 · Minden, NVThe pilot's inadequate in-flight planning/decision to attempt to make it back to the runway for landing after experiencing a loss of lift and not maintaining a proper descent rate.NTSB LAX00LA200Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Los Angeles, CAThe pilot's loss of directional control during landing rollout due to the pilot's foot becoming wedged under a rudder pedal, which restricted its movement.NTSB FTW00WA171Accident · Serious injuriesForeign investigationCessna 182N · Nogales, MexicoNTSB FTW00WA151Accident · 3 fatalForeign investigationBeech V35 · San Quintin, MexicoNTSB FTW00LA150Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Houston, TXThe pilot's failure to maintain control of the aircraft. Factors were the partially engaged parking brake and the pilot's diverted attention to the engine instruments.NTSB DEN00LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Laramie, WYThe pilot-in-command's failure to confirm, the landing gear was down and locked. Factors were the check pilot's failure to confirm the landing gear was down and locked, and the sun glare.NTSB DCA00MA052Accident · 19 fatalClass 1 · MajorFinal reportBritish Aerospace J-3101 · Bear Creek Town, PAThe flight crew’s failure to ensure an adequate fuel supply for the flight, which led to the stoppage of the right engine due to fuel exhaustion and the intermittent stoppage of the left engine due to fuel starvation. Contributing to the accident were the…NTSB SEA00LA089Accident · Serious injuriesLimited investigationFinal reportGifford TR-4 · Wenatchee, WAThe pilot's improper decision to attempt to close the canopy (entry door) after it inadvertently opened in flight, instead of making a precautionary landing with it open. Factors include the pilot's failure to follow all items on the checklist, his failure to…NTSB SEA00LA088Accident · Minor injuriesLimited investigationFinal reportAvions Mudry et Cie CAP 231 · Ephrata, WAThe pilot's failure to maintain aircraft control subsequent to the aircraft's canopy opening in flight. Factors include the pilot's failure confirm that the aircraft's canopy was secured prior to takeoff and impaired vision.NTSB CHI00FA139Accident · 1 fatalField investigationFinal reportWsk Pzl Mielec M-18A · Muskegon, MIthe pilot's failure to maintain clearance from the trees. Factors relating to this accident were the low altitude and the trees.NTSB MIA00WA167Accident · No injuriesForeign investigationPiper PA-28-140 · St. Barthelemy, WNNTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…NTSB MIA00FA163Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Titusville, FLThe failure of the PIC to maintain control of the aircraft while in the simulated engine inoperative configuration in the landing pattern during a checkout flight resulting in an uncontrolled descent and collision with trees. A factor in the accident is the…NTSB DEN00LA091Accident · No injuriesLimited investigationFinal reportCessna 172XP · Larkspur, COA forced landing on soft unsuitable terrain. Factors were improper wiring of the electric fuel boost pump, which produce high pressure when either on position was selected causing the engine to flood during the practice engine out approach.NTSB DEN00FA092Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC · Denver, COpropeller blade fatigue failure due to stress corrosion.NTSB ANC00TA059Accident · Minor injuriesFinal reportCessna 185F · Anchorage, AKThe pilot's improper remedial action and his failure to maintain directional control of the airplane during landing. A factor in the accident was the pilot's excessive use of the airplane brakes.NTSB ANC00LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor in the accident was a sudden wind shift.NTSB SEA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Middleton, IDLoss of engine power for undetermined reasons.NTSB MIA00WA178Incident · No injuriesForeign investigationGrumman HU16A · Barbados, BarbadosNTSB MIA00LA162Accident · No injuriesLimited investigationFinal reportCessna A150M · Gainesville, GAThe pilot's failure to use proper soft field landing technique while attempting a forced landing to an open field following a loss of engine power which resulted in a hard landing. Factors in the accident were weather conditions conducive to formation of…NTSB LAX00LA199Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Biggs, CAThe broken exhaust valve rocker arm of the number 3 cylinder that resulted in a total loss of engine power during an aerial application flight.NTSB LAX00LA198Accident · No injuriesLimited investigationFinal reportCessna 185 · Borrego Springs, CAThe pilot's inadequate compensation for the crosswind condition and his subsequent failure to maintain directional control during landing.NTSB FTW00RA155Accident · 4 fatalForeign investigationCessna 182P · Coban, GuatemalaNTSB DEN00LA090Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Boulder, UTThe pilot's failure to take timely remedial action when he realized a low fuel state. Factors were fuel exhaustion and low airspeed.NTSB SEA00LA100Accident · No injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)A loss of engine power for undetermined reasons.NTSB NYC00LA137Accident · No injuriesLimited investigationFinal reportAnderson MA-18 · Pittsburgh, PAThe pilot's improper fuel management which resulted in the loss of power, and his improper flare during the forced landing, which resulted in a hard landing. Factors included a restricted fuel supply due to a design flaw in the header tank/fuel valve/supply…NTSB MIA00LA160Accident · Minor injuriesLimited investigationFinal reportDaniel A. Shapiro Searey 1DK · Morganton, NCThe inadvertent forward elevator input by the pilot-in-command while reducing throttle control resulting in the airplane nose-over.NTSB MIA00LA159Accident · Minor injuriesLimited investigationFinal reportRichard Shaffer Aircamper GN-1 · Florence, SCThe failure of the pilot to maintain directional control after takeoff resulting in the uncontrolled descent and impact on a closed runway.NTSB DCA00WA050Accident · No injuriesForeign investigationBeech 1900C · GabonNTSB NYC00FA136Accident · 1 fatalField investigationFinal reportBell UH-1H · Frenchville, PAForeign object damage to the compressor and turbine sections of the engine, which resulted in a loss of power.NTSB LAX00LA197Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Show Low, AZThe pilot's failure to properly position the fuel selector to a tank with fuel resulting in fuel starvation, a loss of engine power, and subsequent collision with the ground during the final landing approach.NTSB IAD00LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Tappahannock, VAthe pilots's inability to maintain aircraft control after a loss of consciosness.NTSB LAX00LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Borrego Springs, CAThe pilot's inadequate compensation for a crosswind condition during initial takeoff climb, which resulted a failure to maintain alignment and the airplane drifting into a nearby tree.NTSB IAD00LA042Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Gettysburg, PAThe pilot's improper pre-flight which resulted in the fuel strainer valve being left in the open position.NTSB DEN00GA089Accident · 2 fatalFinal reportCessna T337C · Alamogordo, NMthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/spin. Contributing factors were the loss of engine power on both engines for unknown reasons and the terrain induced turbulence.NTSB MIA00LA158Accident · No injuriesLimited investigationFinal reportPiper J-3 · Boca Raton, FLa loss of engine power due to undetermined reasons that resulted in a forced landing and substantial damage to the aircraft.NTSB MIA00LA157Accident · Serious injuriesLimited investigationFinal reportNavion L-17B · Sharpsburg, GATotal loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.NTSB MIA00LA156Accident · No injuriesLimited investigationFinal reportAsselyn CH701 · Wake Forrest, NCThe pilot's improper fuel management during a cross country flight resulting in a loss of engine power due to fuel exhaustion, and his failure to achieve the proper touchdown point during a forced landing. This resulted in the pilot forcing the airplane onto…NTSB MIA00LA155Accident · No injuriesLimited investigationFinal reportBeech 18 · Monroe, NCThe pilot's failure to maintain directional control during an attempted go-around, resulting in a loss of directional control, and subsequent collapse of the left main landing gear after the airplane departed the runway.