Skip to content

NTSB investigations · 158

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 ('2074245') 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 ('2074245')
  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 ('2074245')
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 BFO88LA083Accident · No injuriesLimited investigationFinal reportCessna 310R · Washington, DCDuring the landing roll the left main landing gear collapsed. The acft continued to roll and came to a stop on taxiway 'k'. Inspection revealed that the push-pull rod assembly, p/n 0840125-15, failed allowing the gear to collapse. The purpose of the rod is to…Sep 15, 1988 · N87297 · Substantial damage NTSB CHI88LA197Accident · No injuriesLimited investigationFinal reportCessna 310RII · Noblesville, INDuring the landing roll, shortly after touchdown and brake application, the left main landing gear collapsed due to the failure of the drag brace. The pilot was unable to maintain directional control of the aircraft and it veered off the left side of the…Aug 6, 1988 · N98980 · Substantial damage NTSB NYC88FA051Accident · 1 fatalField investigationFinal reportCessna 310R · Hector, NYThe pilot made a routine IFR position report 12 minutes prior to the accident. Witnesses observed an 'orange ball' before the crash. Evidence at the crash site showed inflight jettison of the pilot's emergency window, positive aerodydnamic overload separation…Dec 7, 1987 · N5052J · Destroyed NTSB LAX87MA125Accident · No injuriesMajor investigationFinal reportCessna 310R · Los Angeles, CAAfter a ngt lndg on north side of Los Angeles intl arpt, Cessna 310, N98834, was taxied south (s) to delta cargo area. Bfr rchg s rwys (25L & 25R), the plt stopped short of kilo ramp bhnd another acft (N61C) & contacted s gnd ctlr (GC-1). He was told to hold…Feb 26, 1987 · N98834 · 2 aircraft · Substantial damage NTSB CHI87LA020Accident · No injuriesLimited investigationFinal reportCessna 310R · Belvidere, ILDuring takeoff roll, the acft door popped open at a point too late to abort the takeoff. The PIC tried to hold the door closed while the second plt flew the acft around the traffic pattern. Just prior to touchdown, the door opened wider and the PIC reached to…Nov 8, 1986 · N6096C · Substantial damage NTSB SEA86FA194Accident · 1 fatalField investigationFinal reportCessna 310C · Vancouver, WAPlt not IFR rated. Attempted departure from own airstrip in fog during early dawn. Positive rate of climb not established. Acft contacted terrain 3/4 mile from runway end. Psgrs reported no sensation of power probs, but complete loss of ground ref at liftoff.…Aug 6, 1986 · N310MT · Destroyed NTSB NYC86LA110Accident · No injuriesLimited investigationFinal reportCessna C-310R · Buffalo, NYThe pilot of the C-310R stated upon landing flare he heard a loud noise on the right side. His speed was such that he became airborne again on relanding right propeller blades struck runway. Aircraft suffered major wing and structural damage.Apr 22, 1986 · N1909G · Substantial damage NTSB MKC86LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe airplane was being taxied toward a parking spot in front of a hangar and the right brake failed and the left wing contacted the front of the hangar.Jan 26, 1986 · N1905G · Substantial damage NTSB ATL86LMG01Accident · No injuriesFinal reportCessna 310R · Rocky Mount, NCThe acft touched down 150 ft short of rwy 04 at the Rocky mountain-wilson arpt. The acft contacted two rows of apch lights and a ground drop off which sheared all three landing gears. The flt departed wilson municipal arpt and upon reaching 3700 ft the plt…Sep 30, 1985 · N1771G · Substantial damage NTSB SEA85LA023Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Pocatello, IDThe acft had descended to about 900 AGL after passing through icing conditions with a light accumulation of ice. When the landing gear was lowered the acft started yawing and the acft engine instruments were flucuating. The plt thought that the engines were…Nov 30, 1984 · N37279 · Substantial damage NTSB NYC84LA276Incident · No injuriesLimited investigationFinal reportCessna 310II · Newark, NJAn unemployed person was trying to help load an acft. In noticing that a bill of laden had been left off the cargo he ran toward the acft which had, by this time, started engines. The plt said he saw the running man and shoved the mixtures to cut off the…Aug 15, 1984 · N5338C · No damage NTSB ATL84FA169Accident · 2 fatalField investigationFinal reportCessna 310R · Clarkson, KYThe acft crashed after an in-flt separation of various components of the airframe. Post accident evidence provided by the failed parts gave a graphic picture of the in-flt seq which was supplemented by a witness who saw & heard the acft in its final dive.…May 11, 1984 · N5253J · Destroyed NTSB MIA84LA125Accident · No injuriesLimited investigationFinal reportCessna 310R · Palm Beach, FLThe acft landed hard, blew the left main tire and ran off the runway. A witness stated 'the pilot came in high on final, chopped power off and landed hard.'Mar 19, 1984 · N1UB · Substantial damage NTSB MIA84FA090Accident · 1 fatalField investigationFinal reportCessna 310R · St. Petersburg, FLPrior to departure the plt noticed thunderstorms & lightning to the north of the arpt. He stated that immediately after takeoff he remembered a flash of light & a noise. His next recollection is impact & being in the water. The area around St. Petersburg at…Feb 22, 1984 · N3447G · Destroyed NTSB NYC84FA054Accident · 1 fatalField investigationFinal reportCessna 310R · Buffalo, NYThe acft collided with lake erie during ILS approach to rwy 05 at Buffalo, NY. The acft had been descended to 3000 ft and the plt reported turning inbound from dunkirk VOR to the ILS. He was cleared for the approach and told to report the outer marker to…Dec 14, 1983 · N87291 · Destroyed NTSB MKC84FA036Accident · No injuriesField investigationFinal reportCessna 310R · Kansas City, MOThe BE-A36 was holding short of rwy 18. The C-310 was taxiing to also hold short & collided with the BE-A36. The position & strobe lights on the BE-A36 were illuminated. The plt of the C-310 indicated that he did not see the BE-A36 because of what he…Dec 12, 1983 · N3597G · 2 aircraft · Substantial damage NTSB MIA83LA114Accident · 1 fatalLimited investigationFinal reportCessna 310R · Gulf Of MexicoThe plt flew from mobile, al to pensacola, FL, where a passenger enplaned for a flt to columbus, MS. After the passenger disembarked at columbus, the plt took off on an IFR flt plan back to mobile at an altutude of 7000 ft. reportedly, the flt progressed…Apr 11, 1983 · N87498 · Destroyed NTSB ATL83FA128Accident · 3 fatalField investigationFinal reportCessna 310 · Hopkinsville, KYThe plt obtained a wx briefing & filed a flt plan from lexington to paducah,KY with a 15 min en route stop at bowling green, KY. While inbound to bowling green, he reported that the cloud base was at aprx 6000 ft & that there was lightning to the west. After…Mar 6, 1983 · N923CA · Destroyed NTSB MIA83FA054Accident · 1 fatalField investigationFinal reportCessna 310R · Ft. Lauderdale, FLThe aircraft crashed while the pilot was apparently attempting to return to land after takeoff. No radio calls were made, but landing gear had been lowered. High speed and excessive rate of descent are not consistant with a normal or even emergency attempt to…Dec 30, 1982 · N4055C · Destroyed NTSB DEN83LA029Accident · No injuriesLimited investigationFinal reportCessna 310R · Miles City, MTAfter executing a missed approach to rwy 22 the acft began accumulating rime ice. An approach was made to rwy 4. The acft had accumulated about 1/4 in ice, & during the flare the acft shuddered & stalled onto the rwy.Dec 2, 1982 · N30RA · Substantial damage NTSB FTW82DA373Accident · No injuriesFinal reportCessna 310R · Tomball, TXThe right main landing gear collapsed on landing roll. The aircraft departed the runway and crossed a drainage ditch sustaining substantial damage to the fuselage. Inspection of the landing gear revealed the bolt that connects the retraction drag link, pn…Sep 10, 1982 · N3980A · Substantial damage NTSB DEN82DA201Accident · No injuriesFinal reportCessna 31 · Sterling, COPilot came in high and made a hard, bouncing landing after which control was regained and the aircraft was taxied to ramp. Examination revealed extensive damage to the nose, wings, and fuselage.Sep 9, 1982 · N310CT · Substantial damage NTSB MKC82FA160Accident · 2 fatalField investigationFinal reportCessna T310R · Council Bluffs, IAThe omaha weather was reported (in part) to be 3500 ft scattered, estimated 6000 ft broken, 18000 ft broken, visibility 4 mi with fog and haze, wind 200 deg at 5 KTS. However, the aircrew of a preceeding flight that arrived about 8 min earlier said they…Aug 30, 1982 · N2906A · Destroyed NTSB NYC82FA188Accident · 1 fatalField investigationFinal reportCessna 310R · Danbury, CTApproaching the destination arpt, the plt was advised to plan a VOR rwy 24 approach & that he would be turned just inside the faf. At 0055, newark a/c identified the acft 3 mi north of the arpt still at 2,000 ft & asked the plt if he was able to execute the…Aug 9, 1982 · N98841 · Destroyed NTSB MIA82DA139Accident · No injuriesFinal reportCessna 310 · Near Horseshoe, FLThe pilot reported that during an over water flight, he noticed the right engine fuel flow was fluctuating while the engine was cutting in and out. This was followed by intense white smoke which was observed coming out of the louvers on top of the engine…Jun 21, 1982 · N5193C · Destroyed NTSB ATL82DKW06Accident · No injuriesFinal reportCessna 310 · Nashville, TNThe aircraft collided with a Cessna 310, N5253J at night after both planes had been cleared to the same runway. The other pilot stated that the Beech 95-55 was taxiing without lights. Reportedly, the Cessna pilot did not see the Beech 95-55 approaching from…Mar 11, 1982 · N5253J · 2 aircraft · Substantial damage NTSB MIA82FLD16Accident · Serious injuriesFinal reportCessna 310 · Lake Wales, FLThe flt encountered bad wx over the Lake Wales arpt. The plt put the gear down & was maneuvering for an approach. The pax stated that acft then crashed. The fuel tanks had approximately one pint of fuel remaining.Feb 10, 1982 · N5207J · Destroyed NTSB LAX82FA009Accident · 3 fatalClosedCessna 310R · Elsinore, CAOct 28, 1981 · N5467J · Destroyed NTSB ATL81FLT11Accident · No injuriesClosedCessna 310R · Olive Branch, MSJun 11, 1981 · N87241 · Substantial damage NTSB CHI81FA059Accident · 2 fatalClosedCessna 310R · Grand Rapids, MIMay 27, 1981 · N2636L · Destroyed NTSB NYC81FA030Accident · 2 fatalClosedCessna 310R · North Adams, MAFeb 25, 1981 · N5489J · Destroyed NTSB CHI80FEE53Accident · No injuriesClosedCessna 310Q · West Chicago, ILSep 30, 1980 · N310CT · Substantial damage NTSB FTW80FQA38Accident · No injuriesClosedCessna 310 · Clayton, NMJul 30, 1980 · N3161M · Substantial damage NTSB CHI80FEG12Accident · Serious injuriesClosedCessna 310R · Miamisburg, OHApr 24, 1980 · N5029J · Substantial damage NTSB FTW80FPJ13Accident · No injuriesClosedCessna 310R · Norman, OKApr 7, 1980 · N87241 · Substantial damage NTSB MKC80FCJ09Accident · No injuriesClosedCessna 310 · Thedford, NEMar 25, 1980 · N5474J · Substantial damage NTSB CHI80DA017Accident · 2 fatalClosedCessna 310R · Green Bay, WIDec 21, 1979 · N78ST · Destroyed NTSB CHI80FA007Accident · 2 fatalClosedCessna 310 · Bloomington, INOct 22, 1979 · N1320G · Destroyed NTSB NYC80FA002Accident · 2 fatalClosedCessna 310R · Bethlehem, CTOct 3, 1979 · N87369 · Destroyed NTSB DEN79FA031Accident · 2 fatalClosedCessna 310 · Castle Rock, COMar 18, 1979 · N4157A · Destroyed NTSB LAX79FA046Accident · 2 fatalClosedCessna 310R · Heber, AZMar 17, 1979 · N3424G · Destroyed NTSB NYC79FGM17Accident · No injuriesClosedCessna 310R · Latrobe, PAFeb 25, 1979 · N3597G · Substantial damage NTSB CHI79FEM11Accident · No injuriesClosedCessna 310R · Kalamazoo, MIFeb 7, 1979 · N3413G · Substantial damage NTSB CHI79DEE29Accident · No injuriesClosedCessna 310 · Waukegan, ILJan 19, 1979 · N1745G · Substantial damage NTSB MIA79FA035Accident · 1 fatalClosedCessna 310R · Madison, MSJan 5, 1979 · N303LA · Destroyed NTSB MIA79FLA02Accident · Serious injuriesClosedCessna 310 · Tallahassee, FLOct 7, 1978 · N87328 · Substantial damage NTSB IAD78DKM20Accident · Minor injuriesClosedCessna 310F · Liberty, NCAug 16, 1978 · N372WP · Substantial damage NTSB FTW78DQD20Accident · Minor injuriesClosedCessna 310R · Fort Stockton, TXMay 18, 1978 · N1269G · Substantial damage NTSB OAK78FA027Accident · 4 fatalClosedCessna 310R · Lake Tahoe, CAApr 20, 1978 · N3502G · Destroyed NTSB OAK78FVD21Accident · No injuriesClosedCessna 310R · Oakland, CAMar 6, 1978 · N87316 · Substantial damage

Back to Cessna 310R