NTSB investigations, 1985, WI

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
  WHERE year(c.\"eventDate\") = 1985
    AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
  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.

NTSB CHI85LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Broadhead, WIThe plt stated that during arrival, he entered a traffic pattern for what he thought, according to his directional gyro, was rwy 9. Rwy 9 was 2500 ft long; however, he landed on rwy 3, which was 1520 ft long. During the landing, the plt was unable to stop on…Apr 29, 1985 · N25227 · Substantial damageNTSB CHI85FA176Accident · 1 fatalField investigationFinal reportCessna R182 · Prairie Dusac, WIThis midair collision occurred approx 2 mi NE of sauk-Prairie apt. The pilots of the Cessna were in a climbing right departure turn at approx 1600 ft MSL heading approx 120 deg when a collsion occurred with a Piper heading approx 270 deg and descending. One…Apr 26, 1985 · N4707T · 2 aircraft · Substantial damageNTSB CHI85FA170Accident · No injuriesField investigationFinal reportBeech E18S · Janesville, WIOn April 20,1985 at approx. 2100HRS local time a Beechcraft model E185 N68Y owned and operated by blackhawk airways inc. was conducting a normal runup in preparation for a flight from Janesville, WI. (Jvl) to chicago IL. (Ord). At the completion of the of the…Apr 21, 1985 · N68V · Substantial damageNTSB CHI85LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Stevens Point, WIDuring a low level flt over a river, the plt initiated a turn to reverse direction at 300 ft AGL. The acft contacted the water during the descending turn and nosed over.Apr 14, 1985 · N4609X · Substantial damageNTSB CHI85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIThe acft collided with a snowbank during takeoff after the plt lost directional control. The takeoff was attempted on rwy 22. The wind was from 180 degrees at 13 KTS.Mar 6, 1985 · N2365F · Substantial damageNTSB CHI85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Markesan, WIAlthough the pilot believed he had enough visibility to land at this unlighted airfield at dusk, he, in fact, aligned the aircraft up approximately 20 feet to the right of the runway. He landed in a shallow snowbank that paralleled the entire length of the…Feb 27, 1985 · N54815 · Substantial damageNTSB CHI85LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ephriam, WIThe aircraft began drifting to the right during the landing flare. As the aircraft touched down the right wheel entered an area of slush. The aircraft then slid off the runway to the right into a snowbank, damaging the landing gear and left wing tip. The…Feb 25, 1985 · N15652 · Substantial damageNTSB CHI85LA117Accident · No injuriesLimited investigationFinal reportCessna 177RG · Janesville, WIThe acft collided with a snowbank during lndg. An investigation by a qualified A&P mech found the lock-o-seal in the master cylinder had improper clearance. Lack of proper clearence restricted return flow of brake fluid to the reservoir. This led to locking…Feb 17, 1985 · N8ME · Substantial damageNTSB CHI85LA106Accident · No injuriesLimited investigationFinal reportCessna 150D · Siren, WIThe acft collided with a snow bank during landing. This was a solo student flt for the plt. The wind was 20 degrees off the rwy heading and varying bet 7-12 KTS in velocity. The student reported that either more brake & aileron or a running takeoff would have…Feb 11, 1985 · N4267U · Substantial damage