Skip to content

NTSB investigations · 107

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2073416') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2073416')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2073416')
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 ERA19LA239Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Chattanooga, TNThe improper maintenance of the airplane’s landing gear system, which resulted in a hydraulic fluid leak and insufficient pressure to extend and lock the landing gear during the accident flight.Jul 30, 2019 · N2362F · Substantial damage NTSB WPR14FA174Accident · 1 fatalField investigationFinal reportCessna 210E · Richmond, CABoth pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot.Apr 27, 2014 · N4962U · 2 aircraft · Destroyed NTSB CEN14GA135Accident · 1 fatalFinal reportCessna 210E · Oden, ARThe pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.Jan 31, 2014 · N4957U · Substantial damage NTSB CEN14CA092Accident · Minor injuriesData collectionFinal reportCessna 210E · Guymon, OKThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.Dec 20, 2013 · N2382F · Substantial damage NTSB ERA13FA209Accident · 2 fatalField investigationFinal reportCessna 210E · Williamsburg, VAThe pilot’s failure to maintain airplane control during a base-to-final turn with a gusting wind and potential turbulence/wind shear, which resulted in an aerodynamic stall and collision with terrain.Apr 19, 2013 · N111BK · Substantial damage NTSB ERA12LA157Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Port Orange, FLThe total loss of engine power for reasons that could not be conclusively determined during postaccident examination.Jan 25, 2012 · N7130U · Substantial damage NTSB SEA08CA176Accident · Minor injuriesData collectionFinal reportCessna 210E · Auburn, WAA catastrophic engine failure due to the partial blockage of the lubricating oil galley in one of the crankshaft connecting rod journals, leading to the failure of the connecting rod cap.Aug 12, 2008 · N98KC · Substantial damage NTSB SEA07CA015Accident · No injuriesData collectionFinal reportCessna 210E · Friday Harbor, WAAn in-flight collision with a bird during takeoff.Oct 21, 2006 · N4942U · Substantial damage NTSB DEN05CA116Accident · No injuriesData collectionFinal reportCessna 210E · Saratoga, WYthe pilot's failure to maintain aircraft control and the pilot's improper preflight planning/preparation. Contributing factors include the pilot's failure to maintain airspeed resulting in an inadvertent stall/mush, the pilot's failure to calculate a weight…Jul 29, 2005 · N2361F · Substantial damage NTSB CHI05LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · La Gygne, KSThe failure of the throttle control cable which resulted from wear followed by fatigue cracking. A factor associated with the accident was the corn crop which the airplane contacted during the forced landing.Jul 9, 2005 · N4933U · Substantial damage NTSB CHI05LA079Accident · No injuriesLimited investigationFinal reportCessna 210E · Bronson, MIThe pilot's inadequate preflight preparation which failed to detect contaminated fuel that led to a loss of engine power. The unsuitable terrain encountered was a factor.Mar 24, 2005 · N2380F · Substantial damage NTSB IAD04LA011Accident · No injuriesLimited investigationFinal reportCessna 210E · Pittsburgh, PAThe owner/pilot-mechanic's failure to comply with an airworthiness directive, which resulted in a fatigue fracture to the left main landing gear saddle.Feb 16, 2004 · N4974U · Substantial damage NTSB MIA03LA118Accident · No injuriesLimited investigationFinal reportCessna 210E · Tallahassee, FLThe arching of the battery electric wire which was chaffing against the main steel braided fuel hose resulting in fire in the engine compartment.Jun 3, 2003 · N2328F · Substantial damage NTSB SEA00LA123Accident · No injuriesLimited investigationFinal reportCessna 210E · Pocatello, IDImproper landing flare resulting in a hard landing. Factors include dark night environmental conditions and lack of recent experience for night landings.Jul 3, 2000 · N2331F · Substantial damage NTSB LAX00LA095Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Glendale, AZthe pilot's attempt to go-around with inadequate altitude and airspeed available, resulting in a power demand that exceeded the capability of the aircraft. The fully extended gear and flaps were factors in this accident.Feb 8, 2000 · N4946U · Substantial damage NTSB LAX97LA299Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Oxnard, CAThe failure of maintenance personnel to properly secure a fuel supply line during a 100-hour inspection and the failure of inspection personnel to detect the loose fitting.Aug 22, 1997 · N1808F · Destroyed NTSB LAX96FA308Accident · 1 fatalField investigationFinal reportCessna 210E · Big Bear City, CAan inadequate annual inspection conducted by other maintenance personnel.Aug 17, 1996 · N4931U · Destroyed NTSB CHI96LA292Accident · No injuriesLimited investigationFinal reportCessna 210E · Clarksville, MOfuel starvation for undetermined reason(s). Factors relating to the accident were: the crop, and the uphill terrain condition in the emergency landing area.Aug 11, 1996 · N4963U · Substantial damage NTSB SEA95LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · Bullfrog, UTThe right brake locking for undetermined reasons.Aug 10, 1995 · N2377F · Substantial damage NTSB FTW94LA222Accident · No injuriesLimited investigationFinal reportCessna 206E · Cleveland, TXLoss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.Jul 5, 1994 · N4945U · Substantial damage NTSB DEN90FA089Accident · 1 fatalField investigationFinal reportCessna 210E · Elbert, COThe pilot's initiation of flight into known adverse weather, the rapid ice accumulation on the airframe, and an inadvertent stall-mush, resulting in an uncontrolled descent into terrain.Apr 9, 1990 · N4912U · Destroyed NTSB SEA89LA013Accident · 4 fatalLimited investigationFinal reportCessna 210E · Wenatchee, WAThe acft crashed while the plt was on a x-country flt at dawn. Impact occurred on rising, rocky terrain in a box canyon area at an elev of about 6000 ft. no ground scars were evident, but the acft impacted on a rocky slide area. It came to rest in one area…Oct 18, 1988 · N4961U · Destroyed NTSB SEA88FA154Accident · 2 fatalField investigationFinal reportCessna 210E · N Bonneville, WAWhile on a flt from oroville to orchards, WA, the acft was about 25 to 30 mi east of the destn when it collided with trees & crashed. Impact occurred aprx 100 ft below the top of a ridgeline at an elev of about 1755 ft. a witness, who heard the crash, rprtd…Aug 16, 1988 · N3ME · Destroyed NTSB MIA86LA104Accident · No injuriesLimited investigationFinal reportCessna 210E · Jacksonville, FLAfter departure plt selected landing gear up and did not receive a gear up indication. Another aircraft flew under the aircraft and reported the nose gear and left main gear were up and that the right main gear was partially extended. When attempts to correct…Mar 25, 1986 · N4916U · Substantial damage NTSB ATL86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Alma, GAThe pilot reported that the engine quit during his descent from the 2000 foot cruise altitude. The aircraft examination failed to disclose any system malfunction or failure. The pilot stated that his preflight indicated that there was about 1/2 and 1/3 tanks…Feb 9, 1986 · N4981U · Substantial damage NTSB FTW85LA215Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Natchitoches, LAThe pilot experienced partial power loss due to ingestion of the alternate air door shaft needle bearing rollers into the engine, and cross firing of the right magneto. He reportedly closed the throttle and made a gear up forced landing. The aircraft slid…May 8, 1985 · N2367F · Substantial damage NTSB DEN84LA164Accident · No injuriesLimited investigationFinal reportCessna 210E · Livingston, MTWhile on a visual flight plan flight the non-instrument rated plt operated his unpressurized Cessna 210 above the clouds and up to an altitude of 16500 feet MSL. The plt stated that just after passing, 'crazy peak', he encountered extreme turbulence and the…May 25, 1984 · N2373F · Substantial damage NTSB NYC84FA178Accident · 1 fatalField investigationFinal reportCessna 210E · Glen Burnie, MDBefore the flt, the plt was observed performing maintenance in the eng compartment. He was known to do some of his own maintenance which included stopping an oil gasket leak by using a sealer. While climbing after takeoff, he turned back to the departure…May 21, 1984 · N432MD · Destroyed NTSB LAX84LA109Accident · No injuriesLimited investigationFinal reportCessna 210E · El Monte, CAA relatively inexperienced plt made a hard landing and reported that the 'front' tire blew upon landing. He pulled up & the acft ballooned and landed very hard on the nose wheel. Control tower personnel stated that the acft flew into the rwy in a nose low…Oct 26, 1983 · N2353F · Substantial damage NTSB DEN83LA207Accident · No injuriesLimited investigationFinal reportCessna 210E · Powell, WYAccording to the pilot he made an approach to a dirt road beside a feed lot and overshot the intended touchdown point. He was relectant to make a go around because there was a high hill close ahead. He tried to stop the acft on the road remaining but the road…Sep 4, 1983 · N2339F · Substantial damage NTSB ATL83FA024Accident · No injuriesField investigationFinal reportCessna 210E · Chattanooga, TNThe eng lost power passing 4,000 ft during climbout. The plt immediately reversed course & attempted to reach lovell field. He was unable to reach the rwy & landed in a shopping center parking lot 1 mi short of the rwy. The right wing struck a signpost & the…Nov 3, 1982 · N4958U · Substantial damage NTSB FTW81DQA20Accident · No injuriesClosedCessna 210E · La Plata, NMFeb 21, 1981 · N4941U · Destroyed NTSB NYC80FA045Accident · 4 fatalClosedCessna 210E · Provincetown, MAJun 14, 1980 · N4919U · Destroyed NTSB SEA80FYA06Accident · Serious injuriesClosedCessna 210E · Burley, IDJan 23, 1980 · N2352F · Substantial damage NTSB CHI79FEK09Accident · No injuriesClosedCessna 210E · Westerville, OHApr 8, 1979 · N4940U · Substantial damage NTSB OAK79DVG14Accident · Serious injuriesClosedCessna 210 · Rio Linda, CAFeb 18, 1979 · N2368F · Substantial damage NTSB IAD78FKW06Accident · Minor injuriesClosedCessna 210 · Powell, TNJun 4, 1978 · N2397F · Destroyed NTSB SEA78FA010Accident · 2 fatalClosedCessna 210E · Moscow, IDNov 27, 1977 · N2369F · Destroyed NTSB DEN77DQA54Accident · No injuriesClosedCessna 210E · Carrizozo, NMSep 12, 1977 · N194CF · Substantial damage NTSB NYC77FFA29Accident · Serious injuriesClosedCessna 210 · Sandy Creek, NYJul 5, 1977 · N731CJ · Destroyed NTSB NYC77FNE03Accident · Minor injuriesClosedCessna 210E · Burlington, CTOct 26, 1976 · N4985U · Substantial damage NTSB OAK77DVG04Accident · No injuriesClosedCessna 210 · Davis, CAOct 16, 1976 · N4987U · Substantial damage NTSB MIA76DKJ46Accident · No injuriesClosedCessna 210 · Lanett, ALJan 21, 1976 · N2358F · Substantial damage NTSB LAX76DUG22Accident · No injuriesClosedCessna 210E · 29 Palms, CADec 4, 1975 · N4908U · Destroyed NTSB FTW76AF030Accident · 1 fatalClosedCessna 210E · Missing AircraftSep 27, 1975 · N2334F · Destroyed NTSB MKC76FCA01Accident · No injuriesClosedCessna 210 · Sikeston, MOJul 16, 1975 · N2358F · Substantial damage NTSB MKC75FCJ5KAccident · Minor injuriesClosedCessna 210E · Omaha, NEMay 19, 1975 · N4981U · Substantial damage NTSB FTW75FRD07Accident · Serious injuriesClosedCessna 210E · Renner, LAAug 20, 1974 · N2355F · Substantial damage NTSB FTW75OF005Accident · No injuriesClosedCessna 210E · Punta Chivato, MexicoJun 27, 1974 · N2332F · Substantial damage NTSB MIA74FKJ57Accident · 1 fatalClosedCessna 210E · Bay Minette, ALMay 13, 1974 · N4918U · Destroyed

Back to Cessna 210E