NTSB investigations, WI
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 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.
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 c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA' 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 CHI82DA230Accident · No injuriesFinal reportPiper PA-28-161 · Ladysmith, WIThe student pilot collided with a fence and rough terrain during a forced landing on a cross-country flight. The student heard a loud knocking from the engine after about 35 minutes of flight. He reduced power which helped but the engine was still noisy. The…NTSB CHI82DA219Accident · Minor injuriesFinal reportPiper PA-28-151 · Pardeeville, WIThe pilot reported that he was making an approach to the sod runway (36). He stated that when he was about treetop high, a gust of wind picked up the left wing of the aircraft and it drifted to the right of the runway. Subsequently, the right wing struck a…NTSB CHI82DA216Accident · Minor injuriesFinal reportPiper PA-28-140 · Dodgeville, WIThe student pilot was on a cross-country flight and had made four landings that day. After visually sighting Dodgeville, the pilot cancelled her VFR flight plan with the flight service station. She reported that nobody answered her numerous calls on UNICOM…NTSB CHI82FA209Accident · No injuriesField investigationFinal reportCessna 421 · Racine, WIThe plt stated he experienced moderate to severe turbulence enroute. A coupled ILS approach was flown without problems, but the plt stated he had to work hard. The flt broke out at about 1,000 ft MSL & at this time he acquired visual contact with the rwy. He…NTSB CHI82DA205Accident · Minor injuriesFinal reportVolmer Sportsman · Pulaski, WIOn his first flight of the aircraft during this calendar year, the pilot aborted his takeoff. On the second attempt he started to abort but the engine surged and the aircraft became airborne. He stated that he continued to have a problem with the engine and…NTSB CHI82DA201Accident · No injuriesFinal reportCessna 140 · Stevens Point, WIDuring arrival, the pilot entered traffic for runway 21. The wind was from 180 degrees at 15 gusting to 35 KTS. The pilot stated that while on final approach, he slipped the plane to the right to land on the grass, but went beyond the smooth grass. After…NTSB CHI82DA192Accident · No injuriesFinal reportErcoupe 415-C · Fort Atkinson, WIThe safety bolt on the propeller hub failed allowing the propeller to separate from the aircraft. The pilot landed in a plowed field.NTSB CHI82DA173Accident · No injuriesFinal reportCessna 210 · Loganville, WIDuring landing approach the engine lost power and the pilot attempted to land in an open field. The aircraft failed to clear a terrace and the nose gear separated from the airplane. The pilot stated, "while concentrating on the various aspects of operation in…NTSB CHI82FA157Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Milwaukee, WIEngine failure forced pilot to land in an open plowed field. Aircraft collided with wires but a successful landing was made. Oil pump gear tooth had failed.NTSB CHI82FA145Accident · 1 fatalField investigationFinal reportCessna 172M · Pardeeville, WIAccording to witnesses the aircraft made a routine takeoff followed by an immediate left climbing turn. The aircraft was observed to lose airspeed and descend into the ground. Witnesses stated that the engine was running until ground impact.NTSB CHI82FA141Accident · 2 fatalField investigationFinal reportCessna 152 · Kenosha, WIThe aircraft crashed in a steep nosed down attitude while the pilot and one passenger were on a local flight. Prior to the accident, witnesses observed the pilot practicing stalls below 1000 ft. no precrash failures were found. The last entry in the pilot's…NTSB CHI82DA140Accident · No injuriesFinal reportBeech BE-19 · Ridgeville, WIThe student pilot departed oshkosh, WI on a round robin cross country flight. The flight was destined for rockford, IL, lacrosse, WI and oshkosh. The aircraft departed oshkosh with full fuel tanks and was not refueled en route. The total duration of the…NTSB CHI82DA138Accident · No injuriesFinal reportCessna 152 · New London, WIThe pilot elected to land on a private strip he was not familiar with. He was not aware of the 3-4 inches of standing water on the sod surface when he touched down. The aircraft nosed over during landing roll.NTSB CHI82DA134Accident · No injuriesFinal reportLuscombe 8A · Dodgeville, WIOn landing roll the aircraft was observed to nose over and invert. The pilot subsequently stated "I didn't land correctly."NTSB CHI82DA105Accident · No injuriesFinal reportAero Commander 100 · Mineral Point, WIThe right main gear collapsed during a landing on runway 22 with the wind from 140 degrees at 15 gusting 22 knots. Subsequently, the aircraft veered to the right and went off of the runway. It continued into a gully and nosed over. An examination revealed…NTSB CHI82DA100Accident · Minor injuriesFinal reportPiper PA-28-236 · Dodgeville, WIThe student pilot was at the controls during the landing approach. The approach was to an upsloping runway, but with a tailwind component. The aircraft was landed long. It continued off the end of the runway and collided with a ditch. The instructor reported…NTSB CHI82DA093Accident · No injuriesFinal reportCessna 210 · Grantsburg, WIDuring landing roll the aircraft struck a windrow and swerved off the runway. The pilot stated that the winds were out of 350 degrees at 15 knots gusting to 30.NTSB CHI82DA083Accident · No injuriesFinal reportCessna 152 · Milwaukee, WIThe student was practicing touch and go landings on a snow covered runway. After applying power for takeoff during the third touch and go, the aircraft veered left and hit a snowbank.NTSB CHI82DA063Accident · Serious injuriesFinal reportBellanca 8KCAB · Franklin, WIAfter a 1.8 hour flight, the fixed base operator serviced the aircraft with 15 gallons of fuel. The pilot stated that he drained the sumps as part of his preflight. The pretakeoff checks and takeoff roll were normal. At about 75 to 100 feet AGL, the engine…NTSB CHI82DA061Accident · No injuriesFinal reportCessna 150 · Franklin, WIWhile practicing a no-flap landing, the student allowed the aircraft to descend below the normal glide path. The instructor told the student that they were going to be low and to add power. Power was added, but soon thereafter, the aircraft touched down short…NTSB CHI82FA059Accident · No injuriesField investigationFinal reportCessna 404 · Oshkosh, WIThe right main gear collapsed on landing. Investigation revealed that the rear trunnion pivot pin, P/N5741112-1, had moved aft & out of the trunnion. The pin had about 1 inch of white paint on the end of the pin that extended into the flap track area. The…NTSB CHI82DA029Accident · No injuriesFinal reportMooney M-20 · Shell Lake, WIThe pilot initiated his takeoff roll on a runway covered with hard packed snow. As the nosewheel was lifted off of the runway, the aircraft started to drift left. The pilot stated that when he applied right rudder and slightly lowered the nose, the plane came…NTSB CHI82DEP14Accident · No injuriesClosedCessna 152 · Pewaukee, WINTSB CHI82FEP13Accident · No injuriesClosedCessna 210C · Baraboo, WINTSB CHI82DEP11Accident · No injuriesClosedCessna 152 · Monroe, WINTSB CHI82DEP12Accident · No injuriesClosedCessna 140 · Hayward, WINTSB CHI82FA016Accident · 2 fatalClosedCessna 182E · Platteville, WINTSB CHI82FEP09Accident · 1 fatalClosedOsprey 2 · Madison, WINTSB CHI82FEP08Accident · No injuriesClosedPiper PA-28 · Dodgeville, WINTSB CHI81DEP07Accident · No injuriesClosedBellanca 7ECA · Neenah, WINTSB CHI82DEP06Accident · No injuriesClosedCessna 152 · Monroe, WINTSB CHI82FEP05Accident · No injuriesClosedPiper PA-28 · Waukesha, WINTSB CHI82FEP03Accident · Serious injuriesClosedCessna 402B · Park Falls, WINTSB CHI82FEP02Accident · No injuriesClosedCessna 150 · Hamburg, WINTSB CHI82DEP04Accident · No injuriesClosedCessna TR182 · Lake Geneva, WINTSB CHI82FEP01Accident · No injuriesClosedCessna 150J · Waukesha, WINTSB CHI81FA104Accident · 3 fatalClosedCessna 210 · Mosinee, WINTSB CHI81DER40Accident · Minor injuriesClosedPiper PA-32 · Crivitz, WINTSB CHI81DEP46Accident · No injuriesClosedPiper PA-22 · La Pointe, WINTSB CHI81DEP47Accident · No injuriesClosedBensen B-8M · Manitowoc, WINTSB CHI81FEP45Accident · Minor injuriesClosedPiper PA-30 · Racine, WINTSB CHI81FEP44Accident · 1 fatalClosedSteen Skyblt · Hartford, WINTSB CHI81FA095Accident · 2 fatalClosedPiper PA-18 · Chippewa Falls, WINTSB CHI81FA091Accident · 3 fatalClosedMooney M20J · La Pointe, WINTSB CHI81DEP42Accident · No injuriesClosedMooney M20C · Dodgeville, WINTSB CHI81FEP41Accident · No injuriesClosedDehavilland DHC-1 · Mequon, WINTSB CHI81FEP43Accident · Minor injuriesClosedMooney M20J · Oshkosh, WINTSB CHI81FER54Accident · No injuriesClosedCessna A185E · Superior, WINTSB CHI81FER53Accident · No injuriesClosedBeech A23 · Superior, WINTSB CHI81DEP39Accident · No injuriesClosedLuscombe 8A · Egg Harbor, WI