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 CHI93LA040Accident · No injuriesLimited investigationFinal reportCessna 401B · Rice Lake, WIImproper rigging of the right main landing gear retract bellcrank by other maintenance personnel.NTSB CHI93FA038Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brookfield, WISpatial disorientation, and failure to maintain proper glidepath.NTSB CHI93LA006Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Madison, WIWas the pilot's inadequate compensation for wind conditions which resulted in an improper flare. A factor related was the gusty wind condition.NTSB CHI93LA005Accident · Minor injuriesLimited investigationFinal reportUnivair 415C · Waukesha, WIThe pilot's inadequate remedial actions and his misjudged emergency procedure (approach to landing).NTSB CHI93LA004Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mountain, WIThe pilot's failure to refuel the airplane.NTSB CHI92LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Baldwin, WISpatial disorientation as the pilot attempted visual flight procedures in instrument meteorological conditions.NTSB CHI92DEP05Accident · No injuriesFinal reportReif Avid Flyer · Shiocton, WIFailure of the pilot-in-command to obtain a proper climb rate, and his lack of total expereince in the type of airplane.NTSB CHI92DEP04Accident · Minor injuriesFinal reportGrumman 164A · Elkhorn, WIThe pilot-in-command's inadequate compensation for wind conditions.NTSB CHI92LA251Accident · No injuriesLimited investigationFinal reportCessna 182P · Ephraim, WIThe pilot selected the wrong runway for landing.NTSB CHI92DEP03Accident · Serious injuriesFinal reportStuart J. Carter Moni · Eau Claire, WIThe pilot-in-command's failure to maintain airspeed.NTSB CHI92FA231Accident · 2 fatalField investigationFinal reportCessna 120 · Maple, WIThe non-instrument rated private pilot's failure to maintain aircraft control.NTSB CHI92FA223Accident · 2 fatalField investigationFinal reportEdra/Mcdermitt Seabird/Petrel · Oshkosh, WIInadequate quality control during the manufacturing process resulting in the in-flight structural failure of the tailboom.NTSB CHI92LA221Accident · Minor injuriesLimited investigationFinal reportStitts SA-11A · Oshkosh, WIThe pilot's failure to maintain control of the homebuilt airplane during the landing. A related factor was the pilot's improper planned approach.NTSB CHI92FA218Accident · 1 fatalField investigationFinal reportBull KR-2 · Oshkosh, WIA loss of control in flight due to pilot incapacitation as a result of a heart attack.NTSB CHI92FA219Accident · 1 fatalField investigationFinal reportTeal TSC-1A2 · Oshkosh, WIThe pilot-in-command's not following procedures/directives.NTSB CHI92FA215Accident · 2 fatalField investigationFinal reportCessna P210N · Mineral Point, WIThe pilot's inadvertent stall and descent into terrain during a forced landing. Related factors are the manufacturer's undertorqued crankcase halves and inadequate surveillance, the pilot's delay in setting up the proper descent rate, and the altered aircraft…NTSB CHI92LA213Accident · No injuriesLimited investigationFinal reportBeech H35 · Baraboo, WIInadequate maintenance service and aircraft preflight by the pilot. A factor contributing to this accident was a partial failure of the brake system.NTSB CHI92LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Belmont, WIThe pilot's poor planning/decision making. Related factors are the low ceilings and fog, the dark night, the pilot's inaccurate weather evaluation and diverted attention, and the pilot's failure to maintain clearance from the higher terrain encountered.NTSB CHI92FA195Accident · 1 fatalField investigationFinal reportMooney M20K · Oconto Falls, WIThe pilot's failure to maintain adequate clearance from obstructions during a low pass.NTSB CHI92LA206Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Janesville, WIThe captain's delay in issuing instructions to the flight attendants to take their seats, and his poor crew coordination. A factor in the accident was the turbulence in clouds.NTSB CHI92FA188Accident · Minor injuriesField investigationFinal reportBeech 24R · Oak Creek, WIA result of inadequate aircraft maintenance inspection on behalf of the company maintenance personnel.NTSB CHI92LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Ladysmith, WIFailure of the pilot to attain a proper touchdown point and the attempted abort of the precautionary landing attempt.NTSB CHI92FA170Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Sheboygan Falls, WIThe copilot's premature liftoff and the captain's inadequate remedial action resulting in loss of aircraft control at low altitude.NTSB CHI92LA165Accident · No injuriesLimited investigationFinal reportCessna 140 · Howard, WIAn inadequate preflight inspection by the pilot in command and a loss of engine power from contaminated fuel.NTSB CHI92LA158Accident · No injuriesLimited investigationFinal reportAeronca O-58B · Oshkosh, WIThe inadequate inspection by other maintenance personnel, and an inadequate preflight inspection by the pilot in command. A factor contributing to the accident was the reversal of the aileron cables.NTSB CHI92LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Greenbay, WIA fractured rod end bolt which resulted in an unsteerable nosewheel.NTSB CHI92LA144Accident · No injuriesLimited investigationFinal reportErcoupe 415-E · Berlin, WIThe pilot's inadequate compensation for the crosswind during the takeoff roll.NTSB CHI92LA137Accident · Serious injuriesLimited investigationFinal reportBell 47-G2A · Dousman, WIThe in-flight loss of the swash plate drive link bolt which allowed the swash plate drive assembly to disconnect.NTSB CHI92LA134Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · La Crosse, WIVisual lookout inadequate and diverted attention by the pilot. A factor related to the accident was transmission wires crossing flight path.NTSB CHI92LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brookfield, WIFailure of the pilot (CFI) to attain the proper touchdown point for landing. Factors related to the accident were: the unfavorable wind condition, the excessive descent rate that developed on final approach, and the cfi's delay in taking remedial action to…NTSB CHI92FA120Accident · 2 fatalField investigationFinal reportCessna 182 · Port Washington, WIThe continuation of VFR flight into IMC conditions, by a (pilot) unknown, and not maintaining aircraft control by a (pilot) unknown.NTSB CHI92FA119Accident · 1 fatalField investigationFinal reportCessna 172H · Browntown, WISpatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…NTSB CHI92DEP02Accident · No injuriesFinal reportRutan Varieze · Kenosha, WICollapse of the nose landing gear.NTSB CHI92FA110Accident · 2 fatalField investigationFinal reportCessna 310R · Superior, WIInadequate airspeed, which resulted in an inadvertent stall/spin, and failure of the instructor pilot to take sufficient remedial action to prevent the loss of control.NTSB CHI92LA100Accident · No injuriesLimited investigationFinal reportCessna 340 · Ashland, WIThe pilot delayed initiating a go-around. Factors were icing conditions and inadequate windshield anti-ice which resulted in restricted visual lookout.NTSB CHI92LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Zenda, WIDirectional control was not maintained by the pilot. Factors related to the accident were: a gusty surface wind condition and lack of total experience by the pilot.NTSB CHI92FA066Accident · 1 fatalField investigationFinal reportPiper PA-31P · Mosinee, WIAn inflight fire with the cabin heater as the origin, and unsuitable terrain in which to make a forced landing. A factor related to the accident was the soft terrain.NTSB CHI92FA059Accident · 4 fatalField investigationFinal reportCessna 172N · Cumberland, WIFailure to maintain aircraft control by the pilot in commnd. Factors in the accident are the pilot's continued flight into known adverse weather, a blocked pitot static system, lack of total expereince in type of operation, and lack of total expereince in…NTSB CHI92TL#01Accident · Serious injuriesClass 3Final reportCessna 337 · Eau Claire, WINTSB CHI92LA015Accident · No injuriesLimited investigationFinal reportNorth American Navion D · Lake Geneva, WIFatigue failure of the crankshaft. A factor in the accident was inadequate quality control by other maintenance personnel.NTSB CHI92DEP01Accident · No injuriesFinal reportLassiter Swearingen SX300 · Eagle River, WIThe partial loss of engine power, for reasons undetermined which resulted in an aborted takeoff and eventual overrun and landing gear collapse.NTSB CHI92LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Marion, WIThe failure of the exhaust and intake valves. Factors contributing to the accident were downhill terrain and a collapsed nosegear.NTSB CHI91LA299Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Boscobel, WIImproper remedial action by the pilot-in-command (PIC), and inadequate monitoring by the designated pilot examiner (DPE) during a simulated emergency procedure. Factors related to the accident were: the loss of power in one engine due to an undetermined…NTSB CHI91DEP13Accident · Serious injuriesFinal reportMerritt Robertson B1-RD · Menasha, WIInadequate visual look out whih resulted in a wire strike and uncontrolled descent.NTSB CHI91LA284Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Pulaski, WIThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a related factor.NTSB CHI91LA283Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Burlington, WIThe pilot's exceeding the airplane's licensed gross weight and the pilot's improper preflight planning and preparation.NTSB CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.NTSB CHI91LA265Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Mosinee, WIThe pilot's poor preflight planning/preparation, and the selection of unsuitable terrain for takeoff. A related factor was the grassy runway (farm field).NTSB CHI91LA258Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Delavan, WIMisjudged fuel consumption calculations by the pilot which resulted in fuel exhaustion. A factor related to the accident was refueling not performed.NTSB CHI91LA246Accident · 1 fatalLimited investigationFinal reportBeech 35A · Hager City, WIThe failure of the pilot to maintain airspeed above stalling speed while maneuvering.