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 CHI00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Amery, WIthe pilots failure to maintain directional control. Factors to the accident were the icing conditions, the snow and ice covered runway and the snowbank.NTSB CHI00IA087Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC9-32 · Milwaukee, WIthe chafing of the internal water heater wire. A factor was the missing ground strap.NTSB CHI00LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · East Troy, WIThe proper alignment not being maintained by the dual student during an attempted running takeoff and the inadequate supervision of the pilot-in-command (CFI).NTSB CHI00IA062Incident · No injuriesIncident investigationFinal reportBritish Aerospace Jetstream 3101 · Milwaukee, WIthe hold-short clearance not being followed by the flightcrew, which resulted in a near collision with the departing Boeing 727-200.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 CHI00FA050Accident · No injuriesField investigationFinal reportIsrael Aircraft Industries 1124A · Milwaukee, WIThe failure of the first stage pressure reducer in the oxygen regulator assembly.NTSB CHI00LA034Accident · No injuriesLimited investigationFinal reportTaylorcraft F-21 · Houlton, WIthe mechanic failed to torque the rod cap bolt during the major engine overhaul. Factors relating to the accident included the rough field and the collapsed landing gear.NTSB CHI00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Crandon, WIthe deer that ran out onto the runway and collided with the airplane. A factor associated with the accident was the night lighting conditions.NTSB CHI00LA008Accident · No injuriesLimited investigationFinal reportCessna 150F · East Troy, WIthe pilot not maintaining directional control and not obtaining a proper climb rate. Factors were the gusts, and the ground loop that was encountered. A finding was the pilot atempted a go-around.NTSB CHI99LA334Accident · Minor injuriesLimited investigationFinal reportBell 206B · Nekoosa, WIthe pilot's inadequate compensation for wind gusts. Factors were the wind gusts and the two vehicles parked nearby.NTSB CHI99LA320Accident · Serious injuriesLimited investigationFinal reportCessna 172D · South Wayne, WIthe pilot's improper selection of an emergency field and failure to maintain clearance from the trees. The cause of the loss of engine power was not determined.NTSB CHI99LA316Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Osceola, WIthe pilot's improper preflight decision to attempt a takeoff with one engine inoperative.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 CHI99LA300Accident · No injuriesLimited investigationFinal reportMaule MXT7-180A · Lapointe, WIthe pilot not maintaining control of the airplane during a crosswind landing. A factor in this accident was inadequate remedial action by the pilot.NTSB CHI99LA295Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Eagle River, WIthe pilot's inadequate compensation for the crosswind conditions and the subsequent failure to maintain directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions, and the rough/uneven terrain encountered.NTSB CHI99LA294Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Johnson Creek, WIthe pilot's failure to maintain directional control of the airplane.NTSB CHI99LA302Accident · No injuriesLimited investigationFinal reportCessna 150K · Kenosha, WIThe pilot's attention being diverted into the cockpit and not maintaining visual separation with the fuel truck. A factor in the accident was the fuel truck.NTSB CHI99FA296Accident · 1 fatalField investigationFinal reportJohannes-Robert Acrosport RJ-2 · Campbellsport, WIThe loss of control during initial climb for undetermined reasons.NTSB CHI99FA276Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Lake Geneva, WIthe aborted takeoff not performed by the safety-pilot and airspeed not obtained/maintained by the safety-pilot. Factors to the accident were directional control and runway alignment not maintained by the pilot-in-command, the inadequate supervision of the…NTSB CHI99LA270Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Port Washington, WIthe loss of engine power for undetermined reasons.NTSB CHI99LA271Accident · No injuriesLimited investigationFinal reportCessna 180K · Shawano, WIthe failure of the pilot to maintain directional control. Factors were the misjudged flare and improper recovery from the bounced landing by the pilot, and the ditch.NTSB CHI99FA266Accident · Serious injuriesField investigationFinal reportChance Vought F4U-4 · Oshkosh, WIThe pilot of the other airplane not following the instructions briefed by the formation leader, and the pilot's maneuvering his airplane to avoid the airplane in front of him.NTSB CHI99FA263Accident · No injuriesField investigationFinal reportUnderwood Brokaw Bullet · Oshkosh, WIthe pilot failed to maintain directional control of the airplane.NTSB CHI99FA260Accident · No injuriesField investigationFinal reportBurns Pietenpol AIR Camper · Oshkosh, WIthe pilot failed to maintain directional control and ground looped the airplane. Factors included the crosswind and the turbulence from the DC-3.NTSB CHI99FA252Accident · Minor injuriesField investigationFinal reportCessna 182D · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations and the subsequent fuel exhaustion. Factors associated with the accident were the crops and the soft field conditions.NTSB CHI99LA282Accident · No injuriesLimited investigationFinal reportCessna 152 · Superior, WIthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the gusty wind condition, the student's lack of experience, and the soft terrain encountered.NTSB CHI99LA273Accident · No injuriesLimited investigationFinal reportMooney M20B · Hayward, WIthe pilot's failure to maintain clearance with the surface of the lake. Factors associated with the accident were the low level flight, dusk light conditions, and the glassy water.NTSB CHI99LA248Accident · No injuriesLimited investigationFinal reportRobinson R22 · Spring Green, WIthe pilots failure to maintain clearance with the wire. A factor was the wire.NTSB CHI99LA246Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Boscobel, WIthe pilot's improper approach to landing. Factors included the carburetor icing, the delayed use of carburetor heat, the unsuitable terrain for landing, and the ditch.NTSB CHI99LA244Accident · No injuriesLimited investigationFinal reportCessna 182N · Green Bay, WIThe pilot's delayed flare and his improper recovery from a bounced landing.NTSB CHI99LA242Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bristol, WIthe pilot's failure to perform a proper recovery from the bounced landing, resulting in the airplane's nose gear striking the runway. A factor relating to the accident was the excessive airspeed maintained during the landing.NTSB CHI99LA255Accident · Minor injuriesLimited investigationFinal reportBuss Avid Flyer Mark IV · New London, WIthe inadequate preflight planning/preparation by the pilot. Factors to the accident were the powerplant seizing and the misjudged flare by the pilot.NTSB CHI99LA220Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Sylvania, WIthe misjudged planned approach and the evasive maneuver attempted by the pilot-in-command. A factor was the presence of trees.NTSB CHI99FA222Accident · 1 fatalField investigationFinal reportCessna 182E · Menominee Falls, WIthe pilots failure to maintain adequate clearance. A factor was the static wire.NTSB CHI99FA208Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-32 · Milwaukee, WIThe vehicle driver's inadvertent application of the accelerator pedal while backing towards the aircraft.NTSB CHI99LA189Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Hartford, WIthe reason for the occurrence was undetermined. Factors were the pilot's deploying of the drogue chute, the drogue chute malfunctioning, a dirt embankment, and encountering unsuitable terrain during landing.NTSB CHI99LA186Accident · No injuriesLimited investigationFinal reportNorth American Navion L-17A · Osceola, WIthe pilot's mismanagement of the fuel system in that he had the fuel selector positioned to a tank which did not contain sufficient fuel for the flight. Factors associated with the accident were the crop and the ditch which the airplane encountered during the…NTSB CHI99LA184Accident · Serious injuriesLimited investigationFinal reportBoeing 777-222 · Madison, WIthe pilot-in-command's inadequate evaluation of the weather conditions. Factors associated with the accident were the turbulence encountered and the seat belt sign was not illuminated.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 CHI99LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Mineral Point, WIthe inadequate planning and decision by the pilot and the exceeded crosswind capability of the airplane. Contributing factors were the crosswind and the gusts.NTSB CHI99LA157Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · East Troy, WIThe pilot's improper approach to landing A factor associated with the accident was the pilot's inadvertent settling with power.NTSB CHI99TA149Accident · Minor injuriesFinal reportCessna 180J · Necedah, WIThe pilot's failure to maintain compensation for the wind conditions. A factor was the gusting tailwind.NTSB CHI99LA132Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lake Geneva, WIthe student pilot's failure to maintain directional control during the landing. Factors contributing to this accident were the variable winds and the ditch.NTSB CHI99FA129Accident · 2 fatalField investigationFinal reportCessna 152 · Superior, WIthe Certified Flight Instructor failed to maintain control of the airplane.NTSB CHI99LA109Accident · No injuriesLimited investigationFinal reportPiper J5A · Wausau, WIthe loss of engine power for undetermined reasons and the lack of suitable terrain for landing. A factor to the accident was the aircraft owner not performing necessary maintenance to the aircraft.NTSB CHI99LA099Accident · No injuriesLimited investigationFinal reportCalkins Kitfox 5 · Waunakee, WIthe fracture of the trim actuator.NTSB CHI99LA097Accident · No injuriesLimited investigationFinal reportCessna 182E · East Troy, WIthe collapse of the right main landing gear from a preexisting fatigue crack.NTSB CHI99LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Milwaukee, WIthe in-flight collision with a bird.NTSB CHI99LA069Accident · No injuriesLimited investigationFinal reportCessna 150C · Middleton, WIinadequate aircraft preflight by the pilot and the ice in the fuel system. A factor associated with the accident was the ravine which the airplane contacted during the forced landing.NTSB CHI99LA068Accident · No injuriesLimited investigationFinal reportCessna P210N · Eau Clare, WIthe delayed gear extension by the pilot. Contributing factors were the checklist not used by the pilot, the inoperative gear warning, and the maintenance replacement of the throttle control/gear warning interconnect cable not performed by company/operator…