NTSB investigations, IN
108 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 11 |
|---|---|
| 1983 | 10 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 9 |
| 1988 | 3 |
| 1989 | 6 |
| 1990 | 11 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 5 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 3 |
Where
Open the mapLatest cases
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\" = 'IN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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" = 'IN' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 CHI06CA170Accident · No injuriesData collectionFinal reportCessna 150G · Indianapolis, INThe pilot intentionally leaving the airplane unoccupied during the engine start and the failure of the tail tie-down, which ultimately resulted in the unoccupied airplane becoming airborne.NTSB CHI06LA150Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Darmstadt, INThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control, and an on-ground collision with terrain.NTSB CHI06CA123Accident · No injuriesData collectionFinal reportCessna 172E · Richmond, INThe pilot's inadequate compensation for wind conditions during the landing. Factors were the crosswind and gusts.NTSB CHI05CA264Accident · Minor injuriesData collectionFinal reportMaule MT-7-260 · Decatur, INThe pilot's improper decision to land on a runway with a tailwind, the improper recovery from a bounced landing, and the loss of control during landing roll. Factors included the tailwind and the post.NTSB CHI05CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · South Bend, INThe student pilot failed to compensate for the crosswind condition and failed to maintain directional control. Factors included the crosswind and the windsock.NTSB CHI05CA072Accident · No injuriesData collectionFinal reportGulfstream American 690C · Indianapolis, INThe pilot's failure to maintain directional control during landing touchdown and rollout. Contributing factors were the pilot's inadequate compensation for the crosswind condition, the runway light which the aircraft struck and the muddy grass area…NTSB CHI04CA226Accident · No injuriesData collectionFinal reportDevereux Mustang II · Elkhart, INThe pilot not maintaining directional control during landing roll. A factor was the soft terrain, and the inadequate training in type aircraft.NTSB CHI03LA324Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Evansville, INThe pilot not maintaining directional control during the landing roll. A contributing factor was the airport sign.NTSB CHI03LA195Accident · No injuriesLimited investigationFinal reportRuminski Ultra Pup · Richmond, INThe pilot failed to maintain directional control and the airplane ground looped.NTSB CHI03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Greensburg, INFailure of the pilot to maintain directional control during the takeoff roll. Contributing factors included inadequate planning/decision by the pilot for attempting to depart from the slush covered runway, the slush covered runway itself, and the falling snow.NTSB CHI02LA142Accident · No injuriesLimited investigationFinal reportBell 47G-4 · Muncie, INThe pilot did not maintain directional control during hover taxi. Inadequate compensation for the crosswind conditions, the light rain, and the light pole were factors in the accident.NTSB CHI01LA058Accident · No injuriesLimited investigationFinal reportCessna 172N · Elkhart, INThe loss of directional control by the student pilot and the inadequate remedial action and inadequate supervision by the certified flight instructor. Factors were the snow and ice covered runway and the snowbank.NTSB CHI00TA306Accident · Minor injuriesFinal reportBell 47G-5A · Economy, INThe pilot failed to maintain control of the helicopter while attempting a landing on unsuitable terrain. A factor associated with the accident was the grass covered, down slope in the terrain.NTSB CHI00LA233Accident · No injuriesLimited investigationFinal reportCessna 180 · Jeffersonville, INThe pilot failed to maintain directional control of the airplane while landing. A factor associated with the accident was the crosswind.NTSB CHI00LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Salem, INthe inadequate compensation for the wind conditions and the failure of the pilot to maintain directional control. A factor to the accident was the crosswind condition.NTSB CHI00LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Goshen, INthe failure of the student pilot to maintain directional control on the takeoff roll. Factors to the accident were the lack of experience of the student pilot and the improper use of the throttle.NTSB CHI99LA203Accident · No injuriesLimited investigationFinal reportCessna 172R · Kokomo, INthe student pilot's failure to maintain directional control during landing. Factors to the accident were the pilot's lack of experience and the VOR station.NTSB CHI99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-L21B · Vincennes, INthe pilot's failure to maintain directional control after landing. Factors which contributed to this accident were the pilot's long touchdown, the rough area on the runway, and the wheat field.NTSB CHI99LA059Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Plymouth, INthe pilot's failure to maintain directional control of the airplane while landing. Factors associated with the accident were the tailwind condition and the pilot landing in the wrong direction.NTSB CHI98LA359Accident · No injuriesLimited investigationFinal reportCessna 152 · West Lafayette, INthe student pilot's failure to maintain directional control during the touch and go takeoff.NTSB CHI98LA324Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Michigan City, INthe pilot departed into known adverse weather and failed to maintain directional control of the airplane. A factor was the fog.NTSB CHI98LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Jeffersonville, INthe pilot's failure to maintain directional control. The crosswind was a factor.NTSB CHI97LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Angola, INthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the tailwind, the pilot's selection of runway, and the misjudged landing flare.NTSB CHI97LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Bloomington, INthe pilot failed to maintain control of the aircraft. Factors included the icy runway and the crosswind.NTSB CHI96LA299Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Portland, INthe aircraft ground looped when the pilot lost control of the aircraft during landing.NTSB CHI96LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Valparaiso, INthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Marion, INthe pilot's failure to maintain directional control during landing.NTSB CHI96LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Zionsville, INthe pilot's failure to maintain directional control of the airplane on the ground. A factor relating to this accident is the snowbank.NTSB CHI96LA061Accident · No injuriesLimited investigationFinal reportCessna 180C · Patoka, INthe pilot's failure to maintain control of the airplane during takeoff.NTSB CHI95DEX01Accident · Minor injuriesFinal reportCraig Long E-Z · Shelbyville, INthe pilot's improper recovery from a bounced landing which resulted in the nose wheel striking the runway first. A factor associated with the accident was excessive airspeed during the landing.NTSB CHI94LA192Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Noblesville, INthe pilot's excessive use of brakes. Factors related to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB CHI94LA127Accident · No injuriesLimited investigationFinal reportBeech 35 · Anderson, INthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the rough terrain encountered following the loss of control.NTSB CHI94LA074Accident · No injuriesLimited investigationFinal reportDouglas DC3C · Anderson, INthe pilot in command's inadequate remedial action after a loss of directional control during the takeoff ground roll. Related factors are the copilot's failure to maintain directional control, and the snow covered, icy runway.NTSB CHI94LA030Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Valparaiso, INThe pilot's inadequate compensation for wind conditions while landing in a gusty crosswind. Factors associated with the accident are the gusty crosswind and the pilot's lack of experience in this type airplane.NTSB CHI93LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Sullivan, INThe student pilot's failure to maintain directional control.NTSB CHI92LA269Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gary, INThe pilot's failure to land at the proper touchdown point on the runway and landing with excessive airspeed.NTSB CHI92LA264Accident · No injuriesLimited investigationFinal reportCessna 170A · Angola, INFailure of the pilot to maintain directional control during landing rollout.NTSB CHI92LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INThe pilot's failure to maintain directional control during the landing roll.NTSB CHI92LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe student pilot's failure to maintain directional control and his delaying the aborted landing.NTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.NTSB CHI92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Indianapolis, INRemedial action was not performed by the cfi/pic. A factor related to the accident was directional control was not maintained by the student pilot.NTSB CHI92LA004Accident · No injuriesLimited investigationFinal reportBeech 95 · Elkhart, INThe inadequate amount of hydraulic fluid present in the normal brake system.NTSB CHI91LA295Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, INFailure of the pilot to maintain directional control during the takeoff ground run from a touch-and-go landing.NTSB CHI91LA082Accident · No injuriesLimited investigationFinal reportCessna 170B · Rochester, INThe pilot-in-command's inadequate compensation for wind conditions. A factor contributing to the accident was the crosswind.NTSB CHI91FA011Accident · 3 fatalField investigationFinal reportCessna 172P · Fort Wayne, INThe failure of the pilot to maintain an airspeed above stalling speed. Factors associated with the accident are premature rotation and the pilot's lack of recent total experience.NTSB CHI90LA248Accident · No injuriesLimited investigationFinal reportCessna 172G · Bloomington, INThe pilot's failure to compensate for wind conditions and maintain directional control. The crosswind was a factor.NTSB CHI90DEX01Accident · Minor injuriesFinal reportSattler Aeroduster SA750 · Columbus, INFailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The pilot's lack of experience in the airplane was a related factor.NTSB CHI90LA120Accident · No injuriesLimited investigationFinal reportCessna 172N · Angola, INFailure of the pilot to maintain directional control of the aircraft, while landing in gusty/crosswind conditions. The adverse wind was a related factor.NTSB CHI90LA100Accident · No injuriesLimited investigationFinal reportCessna 150B · Shelbyville, INThe private pilot's failure to maintain directional control of the aircraft during the landing. The crosswind was a related factor.NTSB CHI90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrett, INThe student pilot's failure to maintain directional control which resulted in a ground swerve. The crosswind and soft runway were related factors.