Fatal NTSB investigations, 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 c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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' AND c."highestInjuryLevel" = 'Fatal' 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 CHI04FA203Accident · 1 fatalField investigationFinal reportKnoepflein Lancair Legacy 2000 · Madison, WIA loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…NTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…NTSB CHI04FA045Accident · 2 fatalField investigationFinal reportMooney 20E · Webster, WIThe pilot's inadequate decision to conduct a low altitude flight maneuver without sufficient altitude to maintain clearance from the terrain. Low altitude flight and ostentatious display are contributing factors.NTSB CHI03FA301Accident · 1 fatalField investigationFinal reportAeronca 11BC · Colfax, WIThe pilot failed to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall. A factor associated with the accident was the low altitude at which the pilot was maneuvering.NTSB CHI03LA201Accident · 2 fatalLimited investigationFinal reportMcIlraith Sea Rey · Tomah, WIThe loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed resulting in a stall/spin during the forced landing.NTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.NTSB CHI03FA138Accident · 4 fatalField investigationFinal reportPiper PA-31P · Woodruff, WIThe pilot's failure to follow the before take-off checklist which led to an improper selection of the auxilliary fuel tanks for the takeoff leading to the subsequent fuel starvation of the left engine. Additional causes were the pilot not maintaining minimum…NTSB CHI03FA018Accident · 2 fatalField investigationFinal reportPiper PA-24 · Fond du Lac, WIThe pilot failed to maintain obstacle clearance from the power lines while on a night VFR approach. Factors to the accident included the dark night and the power lines.NTSB CHI02LA268Accident · 1 fatalLimited investigationFinal reportRebholz Rans S-10 · Cottage Grove, WIThe pilot's decision to turn back to the airport following the loss of engine power during initial climb, the pilot not maintaining airspeed and aircraft control, which resulted in the stall at a low altitude. An additional cause was the seizure of the engine…NTSB CHI02FA247Accident · 1 fatalField investigationFinal reportCessna 172N · Shell Lake, WIThe pilot's failure to refuel the airplane prior to departure leading to fuel exhaustion during the flight, the inadequate preflight/inflight planning, and the unsuitable terrain encountered by the pilot during the forced landing attempt. Contributing factors…NTSB CHI02FA120Accident · 1 fatalField investigationFinal reportCessna 182S · Sheboygan, WIThe pilot failed to maintain control of the airplane during the go-around for undetermined reasons.NTSB CHI02FA093Accident · 1 fatalField investigationFinal reportCessna 208B · Alma, WIThe pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…NTSB CHI02FA049Accident · 1 fatalField investigationFinal reportRobinson R44 · Waukesha, WIThe pilot's continued flight into adverse weather and not maintaining altitude/clearance from the static line during cruise flight. Factors were the static wire, the darkness of night, the low ceiling, and the vehicle.NTSB CHI01FA329Accident · 3 fatalField investigationFinal reportCessna 414 Riley Super-8 · Marshfield, WIThe pilot's failure to maintain adequate airspeed (Vmc) which resulted in a loss of control. Contributing factors were the improper in-flight planning/decision not to land at a closer airport and the lack of recent experience in multiengine airplanes by the…NTSB CHI01FA297Accident · 3 fatalField investigationFinal reportBeech A23 · Stevens Point, WIthe pilot not obtaining/maintaining aircraft control.NTSB CHI01LA243Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Wheeler, WIThe pilot not maintaining altitude/clearance from the power transmission line. A factor to the accident was the power transmission line.NTSB CHI01FA244Accident · 1 fatalField investigationFinal reportSchuchart Stoddard HamiltonSH3 · Oshkosh, WIThe inadvertent stall/spin by the pilot.NTSB CHI01FA235Accident · 1 fatalField investigationFinal reportPayne Giles G-202 · Oshkosh, WIThe pilot failed to maintain aircraft control which resulted in an inadvertant stall. Factors with the accident were the pilot misjudged the approach and the pilot's lack of total experience in the Giles G-202.NTSB CHI01FA218Accident · 1 fatalField investigationFinal reportCessna 310R · Oak Creek, WIThe pilot not maintaining clearance from objects during an ILS approach in low night IFR conditions and his descent below decision height. Factors were the dark night, mist, low ceiling, and the trees west of the approach.NTSB CHI01FA180Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 · La Crosse, WIThe fatigue failure of the aircraft's left wing tip fuel tank rear attachment, while the aircraft was being maneuvered in a low approach, leading to the tank's in-flight separation and subsequent in-flight break up of the airplane and the aircraft's control…NTSB CHI01LA138Accident · 1 fatalLimited investigationFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot allowed the airspeed to get too low and inadvertently stalled the airplane.NTSB CHI01FA117Accident · 1 fatalField investigationFinal reportBeech F35 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed which resulted in a stall. The low altitude was a contributing factor.NTSB CHI01FA111Accident · 1 fatalField investigationFinal reportCessna 501 · Ashwaubenon, WIThe pilot not maintaining aircraft control while maneuvering after takeoff and the pilot's inadequate preflight planning and preparation. Factors relating to the accident were the pilot's diverted attention while maneuvering after takeoff, the pilot's…NTSB CHI01FA089Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Webb Lake, WIthe pilot not maintaining altitude/clearance from the trees during takeoff. Factors were the trees, transmission wire, and the dark night.NTSB CHI01FA085Accident · 1 fatalField investigationFinal reportCessna 152 · Horicon, WIthe inadvertent stall/spin. Additional factors included the aerobatic manuevers, low altitude, and the procedures not followed.NTSB CHI01FA044Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Milltown, WIThe flight instructor's inadequate supervision of the flight, the flightcrew not maintaining control of the airplane, and the flight instructor's delayed remedial action which resulted in the inadvertent spin. Factors to the accident were the inadvertent spin…NTSB CHI00FA284Accident · 2 fatalField investigationFinal reportBeech K35 · Manitowish Watr, WIthe pilot not maintaining altitude/clearance from the trees during an approach on a dark, low overcast night, the pilot's improper use of an IFR procedure without clearance, and the pilot's improper in-flight decision to attempt an IFR approach without…NTSB CHI00FA262Accident · 2 fatalField investigationFinal reportBell OH-58C · Watertown, WIThe spatial disorientation by the pilot during continued flight into instrument conditions and the inadequate surveillance by the operator. The inoperative attitude indicator and night conditions were contributing factors.NTSB CHI00FA263Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Watertown, WIAircraft control not being maintained during initial climb resulting in a stall/mush. Factors to the accident were the pilot's inadequate preflight planning/preparation, the pilot operating over the airplane's certified maximum gross weight, and the pilot…NTSB CHI00FA227Accident · 4 fatalField investigationFinal reportCessna 182A · Sauk City, WIVFR flight into IMC encountered by the pilot and exceeding the design limits of the aircraf. A factor was flight to a destination alternate not performed by the pilot.NTSB CHI00FA129Accident · 3 fatalField investigationFinal reportCessna 172M · Cornell, WIthe pilot not maintaining aircraft control and the stall/spin he encountered. A factor was the extended flaps.NTSB CHI00FA057Accident · 1 fatalField investigationFinal reportBeech D-95A Travelair · Dunbar, WIthe pilot failed to maintain a proper glidepath and obstacle clearance during an instrument approach. Additional factors to the accident included the dark night, icing conditions, flight into known adverse weather, and conditions conducive to pilot fatigue.NTSB CHI99FA311Accident · 1 fatalField investigationFinal reportWalker Breezy · Janesville, WIthe inadvertent stall. A factor relating to this accident was the pilot's excessive climb rate.NTSB CHI99FA296Accident · 1 fatalField investigationFinal reportJohannes-Robert Acrosport RJ-2 · Campbellsport, WIThe loss of control during initial climb for undetermined reasons.NTSB CHI99FA222Accident · 1 fatalField investigationFinal reportCessna 182E · Menominee Falls, WIthe pilots failure to maintain adequate clearance. A factor was the static wire.NTSB CHI99FA167Accident · 1 fatalField investigationFinal reportChampion 7ECA · Comstock, WIThe pilot's failure to maintain aircraft control. A factor contributing to this accident was the airplane's low altitude.NTSB CHI99FA129Accident · 2 fatalField investigationFinal reportCessna 152 · Superior, WIthe Certified Flight Instructor failed to maintain control of the airplane.NTSB CHI99FA042Accident · 2 fatalField investigationFinal reportCessna 172F · Coleman, WIpilot's failure to maintain clearance from the trees and his intentional flight into IMC conditions. Factors contributing to this accident were the pilot's lack of instrument certification, his becoming lost in the poor weather, his inadequate preparation for…NTSB CHI99LA007Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Superior, WIthe pilot not maintaining clearance with the terrain, and his improper decision to enter maneuvers too close to the terrain. Factors contributing to this accident were the aerobatic maneuvers, the trees and the berm.NTSB CHI98FA349Accident · 3 fatalField investigationFinal reportBeech 58 · Oakdale, WIThe installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.NTSB CHI98FA356Accident · 2 fatalField investigationFinal reportCessna 310R · Seymour Twp., WIthe pilots of both airplanes not maintaining visual separation from the other airplane.NTSB CHI98FA343Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Beaver Dam, WIThe continued flight into adverse weather conditions and aircraft control not maintained by the pilot-in-command. Contributing factors were the improper preflight planning/preparation and lack of certification by the pilot-in-command in addition to the…NTSB CHI98FA344Accident · 2 fatalField investigationFinal reportCessna A185F · Phillips, WIThe pilot's failure to maintain adequate altitude/clearance with trees. Contributing factors were fog, rain showers, and the trees.NTSB CHI98FA288Accident · 1 fatalField investigationFinal reportHispano Aviacion A10B-37 · Oshkosh, WIthe pilot's failure to maintain adequate altitude which resulted in in-flight collision with trees and subsequent compressor stall for undetermined reasons.NTSB CHI98FA287Accident · 1 fatalField investigationFinal reportNavion A · Coloma, WIFailure of the pilot to maintain proper altitude, and his failure to maintain adequate visual lookout to see and avoid obstructions. The transmission wire was a contributing factor.NTSB CHI98FA153Accident · 4 fatalField investigationFinal reportCommander 114-B · Lagrange, WIthe pilot not maintaining aircraft control during cruise flight and exceeding the airplane's design stress limits. Factors in this accident was the pilot's lack of total experience in the airplane and the clouds.NTSB CHI98FA123Accident · 1 fatalField investigationFinal reportCessna 180J · Ashland, WIthe pilot failing to maintain separation from the trees. Factors contributing to this accident were the trees and the pilot being too low in altitude.NTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.NTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…NTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.