NTSB investigations, WI
88 cases where the sequence of events included Loss of control in flight.
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA15CA122Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Elk Mound, WIThe pilot's failure to maintain a positive rate of climb after taking off from the service truck, which resulted in the helicopter impacting terrain.NTSB CEN15FA249Accident · 2 fatalField investigationFinal reportMonnett John T JR Sonex SA · Oshkosh, WIThe pilot's failure to maintain sufficient airspeed following a loss of engine power during initial takeoff climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the loss of…NTSB CEN15LA195Accident · 1 fatalLimited investigationFinal reportQuad City Challenger - II · Chippewa Falls, WIThe pilot’s incapacitation due to a cardiovascular event, which resulted in a loss of control and subsequent impact with terrain.NTSB CEN15FA027Accident · 1 fatalField investigationFinal reportCessna T210M · Bay City, WIThe non-instrument rated pilot’s continued visual flight into instrument flight rules conditions, which resulted in an in-flight loss of control.NTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.NTSB CEN14FA396Accident · Serious injuriesField investigationFinal reportRender RV 9A · Oshkosh, WIThe pilot's failure to establish a stabilized approach and to maintain airspeed during final approach over obstacles resulting in a stall/mush.NTSB CEN14LA336Accident · 1 fatalLimited investigationFinal reportNorthwing Design Apache Sport · Omro, WIThe pilot’s failure to maintain adequate airspeed to compensate for a newly installed wing, which resulted in the aircraft stalling and the subsequent loss of control.NTSB CEN14FA266Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Stevens Point, WIThe pilot's failure to maintain airplane control during the aerobatic flight, which resulted in the airplane exceeding its critical angle of attack and entering an accelerated stall at a low altitude.NTSB CEN13FA351Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · La Pointe, WIThe pilot’s failure to maintain airplane control after deciding to go around after a gear-up landing, resulting in an aerodynamic stall.NTSB CEN12FA617Accident · 1 fatalField investigationFinal reportBeech A36 · Kansasville, WIIn-flight loss of control for reasons that could not be determined because postaccident examination of the pilot and testing of the airplane did not reveal any anomalies that would have led to the loss of control.NTSB CEN12CA598Accident · No injuriesData collectionFinal reportMooney M20E · Gresham, WIThe pilot's failure to maintain airplane control and clearance from field corn during takeoff.NTSB CEN12CA469Accident · Serious injuriesData collectionFinal reportPurtee Kevin M Pietenpol Aircamper · Broadhead, WIThe pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power during takeoff, and his decision to initiate a turn back to the runway with insufficient airspeed, which resulted…NTSB CEN12LA153Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Madison, WIThe pilot’s failure to ensure that ice and snow were removed from the airplane’s surfaces during the preflight inspection, which resulted in an inadvertent aerodynamic stall after takeoff and loss of control of the airplane.NTSB CEN12LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Denmark, WIThe pilot’s loss of control due to his alcohol impairment. Contributing to the accident was the pilot's decision to fly at night with a known interior lighting malfunction.NTSB CEN12LA129Accident · Minor injuriesLimited investigationFinal reportAviat A-1C-180 · Chetek, WIThe passenger’s interference with the flight controls, which resulted in the airplane’s failure to climb after an aborted landing. Contributing was the pilot's failure to maintain directional control during landing roll, which resulted in the need to abort…NTSB CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.NTSB CEN11LA549Accident · No injuriesLimited investigationFinal reportAerosport Ikarus C42E · East Troy, WIThe flight instrctor's delayed remedial action during landing. Contributing to the accident was the student pilot’s loss of directional control when he became distracted with the open door.NTSB CEN11LA536Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Stoughton, WIThe pilot’s improper preflight planning and his failure to gain proper airspeed during takeoff from a grass airstrip resulting in a stall, the loss of control, and subsequent impact with the trees. Contributing to the accident was the pilot operating the…NTSB CEN11FA531Accident · 1 fatalField investigationFinal reportEdwards Douglas L SKY Ranger · Wautoma, WIThe pilot’s failure to maintain proper airspeed and attitude control of the airplane in the turn, which resulted in an aerodynamic stall.NTSB CEN11LA506Accident · No injuriesLimited investigationFinal reportGottschalk John R John 1 · Oshkosh, WIThe pilot's inadequate preflight planning, which led to the power required exceeding the power available and resulted in a loss of lift and subsequent hard landing.NTSB CEN11FA505Accident · 2 fatalField investigationFinal reportPiper J3L-65 · Van Dyne, WIThe pilot’s inability to maintain airplane control while maneuvering for reasons that could not be determined from the available evidence.NTSB CEN11FA310Accident · 1 fatalField investigationFinal reportJurmu Stol CH701 · Pulaski, WIThe pilot did not maintain control of the airplane during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of recent flight experience.NTSB CEN11CA290Accident · No injuriesData collectionFinal reportCessna 182H · Park Falls, WIThe student pilot's failure to maintain aircraft control during an aborted landing.NTSB CEN11CA128Accident · No injuriesData collectionFinal reportCessna 340A · Madison, WIThe pilot's failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to check the de-ice fluid level prior to takeoff, which resulted in the failure of the de-ice…NTSB CEN10FA557Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Woodruff, WIThe pilot's decision to attempt an instrument approach in turbulent night instrument meteorological conditions with a recently-identified deficiency with his instrument flight proficiency, which resulted in a loss of airplane control as a result of spatial…NTSB CEN10FA443Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 390 · Oshkosh, WIThe pilot's decision not to advance the engines to takeoff power during the go-around, as stipulated by the airplane flight manual, which resulted in an aerodynamic stall at a low altitude.NTSB CEN09CA566Accident · No injuriesData collectionFinal reportPiper J3C-65 · Mondovi, WIThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an aerodynamic stall.NTSB CEN09FA340Accident · 2 fatalField investigationFinal reportGulfstream American AA-5B · Humbird, WIThe pilot's decision to attempt a visual flight rules flight into an area of known instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB CEN09CA279Accident · Minor injuriesData collectionFinal reportAmerican AA-1 · Cumberland, WIThe pilot's failure to maintain control of the aircraft during takeoff in crosswind conditions.NTSB CEN09FA146Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Menomonie, WIThe pilot's failure to maintain control of the airplane while flying at night in instrument meteorological conditions.NTSB CEN09CA078Accident · No injuriesData collectionFinal reportCessna 172S · Waukesha, WIThe pilot's failure to maintain aircraft control during takeoff and his failure to ensure that the elevator trim was properly set before takeoff. Contributing to the accident was the pilot's lack of autopilot system knowledge.NTSB CEN09FA070Accident · 3 fatalField investigationFinal reportPiper PA46-500TP · Marshfield, WIThe pilot's failure to maintain control of the airplane during final approach for landing in night, visual meteorological conditions for undetermined reasons.NTSB CHI08FA282Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Woodruff, WIThe pilot’s failure to maintain airspeed during a missed approach leading to the inadvertent stall. Contributing to the accident were the pilot’s lack of experience in the type of operation conducted, the certificate holder’s loss of operational control, and…NTSB CHI08LA272Accident · 1 fatalLimited investigationFinal reportSocata TB-20 Trinidad · Cassville, WIThe left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.NTSB CHI08CA241Accident · Minor injuriesData collectionFinal reportFalk Zodiac HDS-601 · Middleton, WIThe pilot's inadequate compensation for the crosswind. The crosswind was a factor.NTSB CHI08FA224Accident · 2 fatalField investigationFinal reportMoser Georg Lancair Legacy FG · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08FA222Accident · Minor injuriesField investigationFinal reportPiper PA-22 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed while taking off in gusting winds, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08CA192Accident · Minor injuriesData collectionFinal reportBell 47G-3B · Port Edwards, WIThe pilot failed to maintain control of the helicopter when he inadvertently flared the helicopter and the rotor rpm decayed as a result of sustaining bee stings during an aerial application flight. Contributing to the accidnet included the bees and the low…