NTSB investigations, WI
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CEN10CA460Accident · No injuriesData collectionFinal reportCessna T210M · Shell Lake, WIThe collision with the deer during landing roll.NTSB CEN10IA447Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301 · Ripon, WIThe inability of either pilot to see the other airplane due to the blind spot created by their respective airplane's wings.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 CEN10LA433Accident · No injuriesLimited investigationFinal reportBeech H35 · Green Lake, WIA total loss of engine power during descent due to the overhaul facility’s inadequate maintenance.NTSB CEN10CA421Accident · No injuriesData collectionFinal reportNord 3202 · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll.NTSB CEN10CA371Accident · No injuriesData collectionFinal reportBrantly B-2B · East Troy, WIThe pilot's failure to maintain control during landing.NTSB CEN10CA344Accident · Serious injuriesData collectionFinal reportAir Creation GTE · Neenah, WIThe pilot's improper landing flare that resulted in a hard landing.NTSB CEN10CA283Accident · No injuriesData collectionFinal reportCessna 182A · Franksville, WIThe pilot’s inadequate preflight inspection and delay in aborting the takeoff.NTSB CEN10LA253Accident · No injuriesLimited investigationFinal reportDearmond Clint RV-6A · Sheboygan, WIThe loss of engine power due to a fuse failure in the ignition system.NTSB CEN10CA251Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Baraboo, WIThe pilot's failure to maintain clearance with crops while maneuvering during aerial application.NTSB CEN10LA208Accident · Serious injuriesLimited investigationFinal reportReed William A Kitfox 4 · Baraboo, WIThe pilot's failure to compensate for wind gusts and maintain sufficient airspeed, which resulted in a stall.NTSB CEN10CA158Accident · No injuriesData collectionFinal reportCessna 172M · Waupaca, WIThe student pilot's failure to maintain directional control while taking off in gusting winds.NTSB CEN10LA145Accident · No injuriesLimited investigationFinal reportHawker Beechcraft A36 · Milwaukee, WIThe pilot's retraction of the landing gear prior to establishing a positive climb rate.NTSB CEN10LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Genoa City, WIA total loss of engine power due to the failure of the bolts that held in place the connecting rods to the engine's No. 3 and No. 4 cylinders as a result of the engine overhaul facility's improper installation of the bolts during a recent overhaul.NTSB CEN10CA094Accident · Minor injuriesData collectionFinal reportEngineering & Research Ercoupe 415-CD · New London, WIThe pilot's decision to land with a tailwind on the snow- and ice-covered runway.NTSB CEN10IA059Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Elk Mound, WIThe loss of engine power due to component failure from excessive heating of the engine connecting rod journals.NTSB CEN10CA038Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Three Lakes, WIThe pilot's improper flare and touchdown during the water landing.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 CEN09CA537Accident · No injuriesData collectionFinal reportRewey William M CH 801 · Cottage Grove, WIA total loss of engine power during initial climb due to fuel starvation from a blocked fuel screen that resulted from the pilot/owner's inadequate inspection and maintenance of the fuel system.NTSB CEN09LA602Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · New Miner, WIA total loss of engine power due to the fatigue failure of the engine torsion shaft. Contributing to the accident was the chrome plating of the shaft by an undetermined maintenance/overhaul facility.NTSB CEN09CA522Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Evansville, WIA jam of the elevator flight control for undetermined reasons.NTSB CEN09LA486Accident · No injuriesLimited investigationFinal reportGallagher Junior ACE · Oshkosh, WIThe failure of a weld joint on the right rudder pedal leading to the loss of directional control during landing.NTSB CEN09LA487Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Black River Falls, WIThe loss of engine power during cruise due to the number two cylinder piston connecting rod failure for undetermined reasons.NTSB CEN09CA478Accident · Minor injuriesData collectionFinal reportP&M Quik GT450 · Oshkosh, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB CEN09CA477Accident · No injuriesData collectionFinal reportCessna A185F · River Falls, WIThe pilot not checking the security of the fuel caps prior to flight leading to fuel exhaustion and the subsequent non-mechanical loss of engine power during descent.NTSB CEN09CA472Accident · No injuriesData collectionFinal reportFisher RV-7A · Brodhead, WIThe pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09LA463Accident · No injuriesLimited investigationFinal reportPilgrim Samuel W JR RV-6 · Oshkosh, WIThe failure of the rudder pedal which resulted in the pilot's inability to maintain directional control of the aircraft.NTSB CEN09LA447Accident · No injuriesLimited investigationFinal reportCessna A188B · Suring, WIA loss of engine power resulting from the fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the engine failure was the operator's failure to overhaul the engine in accordance with the manufacturer's…NTSB CEN09LA424Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Racine, WIThe pilot's improper landing flare that resulted in a hard landing and subsequent separation of the airplane's sponson.NTSB CEN09CA407Accident · No injuriesData collectionFinal reportRemos G-3/6000 · Oshkosh, WIA total loss of total engine power due to fuel exhaustion as a result of the instructor pilot's inadequate preflight inspection. Contributing to the accident was the creased fuel quantity tube.NTSB CEN09CA397Accident · No injuriesData collectionFinal reportWeatherhead Peter L Stol CH 701 · Hayward, WIThe pilot's improper flare resulting in a hard landing during gusty wind conditions. Contributing to the accident was the pilot's lack of experience with the accident airplane.NTSB CEN09CA358Accident · Serious injuriesData collectionFinal reportAerostar International RX-9 · Marathon City, WIA hard landing as a result of unexpected high winds and gusts.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 CEN09CA314Accident · No injuriesData collectionFinal reportJabiru J230-SP · Delavan, WIThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.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 CEN09LA263Accident · 1 fatalLimited investigationFinal reportLaseure Sonerai II · Grantsburg, WIThe pilot's failure to maintain airspeed during initial climb which resulted in a stall/spin. Contributing to the accident was the degraded engine performance.NTSB CEN09GA242Accident · 1 fatalFinal reportCessna 337 · Pittsville, WIThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall at a low altitude.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 CEN09LA095Accident · No injuriesLimited investigationFinal reportCessna 402 · Madison, WIThe pilot’s improper fuel management, which resulted in a loss of engine power during an instrument landing due to fuel exhaustion.NTSB CEN09LA093Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-50 · Madison, WIThe collision between the tug and the airplane during towing as a result of sliding on the snow covered runway.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 CHI08FA293Accident · 2 fatalField investigationFinal reportRobinson R44 II · Kenosha, WIThe pilots failure to maintain clearance from terrain resulting in an in-flight collision with a house. Contributing to the accident was the night instrument meteorological conditions (IMC) and the pilot's lack of experience of flying in IMC.NTSB CHI08LA297Accident · Serious injuriesLimited investigationFinal reportPowrachute Pegasus · New London, WIThe pilot's loss of directional control during landing due to failure of the nose wheel support as a result of an inadequate weld.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 CHI08CA287Accident · Minor injuriesData collectionFinal reportCessna 172M · Three Lakes, WIThe pilot's failure to attain sufficient altitude to avoid the trees during initial climb. Contributing to the accident were the pilot's failure to ensure the security of the entrance door before takeoff and the unintentional opening of the door.NTSB CHI08LA288Accident · No injuriesLimited investigationFinal reportFantasy Air Sro Allegro 20 · Walworth, WIThe pilot's failure to maintain directional control during landing.NTSB CHI08CA241Accident · Minor injuriesData collectionFinal reportFalk Zodiac HDS-601 · Middleton, WIThe pilot's inadequate compensation for the crosswind. The crosswind was a factor.NTSB CHI08LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Tomahawk, WIA total loss of engine power due to a loss of all of the engine's oil as a result of the safety wire on the governor idler gear shaft's oil plug breaking, leading to the oil plug coming unscrewed. Contributing to the accident was the lack of a suitable area…