NTSB investigations, 1989
235 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 372 |
|---|---|
| 1983 | 374 |
| 1984 | 329 |
| 1985 | 295 |
| 1986 | 315 |
| 1987 | 331 |
| 1988 | 295 |
| 1989 | 235 |
| 1990 | 278 |
| 1991 | 244 |
| 1992 | 217 |
| 1993 | 232 |
| 1994 | 213 |
| 1995 | 210 |
| 1996 | 221 |
| 1997 | 219 |
| 1998 | 224 |
| 1999 | 247 |
| 2000 | 229 |
| 2001 | 215 |
| 2002 | 204 |
| 2003 | 240 |
| 2004 | 217 |
| 2005 | 228 |
| 2006 | 213 |
| 2007 | 232 |
Where
Latest 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 year(c.\"eventDate\") = 1989
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 year(c."eventDate") = 1989 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 DEN90LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The snowbank was a related factor.NTSB CHI90LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Chillicothe, OHImproper planning/decision by the student pilot, which resulted in a landing on a slick runway, and his failure to maintain directional control during the landing, which resulted in his inability to maintain runway alignment. Contributing factors were: the…NTSB CHI90LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INFailure of the student pilot to maintain directional control and his improper use of (normal) brakes. His decision to make a running takeoff, his lack of total experience, and the snowbank were contributing factors.NTSB DEN90LA035Accident · No injuriesLimited investigationFinal reportCessna 172P · Billings, MTThe failure of the pilot to maintain directional control during adverse wind conditions.NTSB LAX90LA052Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Placerville, CAThe student pilot's failure to maintain directional control.NTSB FTW90IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Baton Rouge, LAThe captain's excessive speed during a turn off of the runway, and his failure to maintain directional control. The wet taxiway was a related factor.NTSB CHI90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Chicago, ILFailure of the solo student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student pilot's lack of total inexperience, and the runway lights.NTSB BFO90LA016Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Morgantown, WVThe pilot's excessive taxi speed. Ice on the ramp and the location of the fence were related factors.NTSB FTW90LA041Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKPilot's inadequate compensation for existing wind conditions. Contributing to the accident were the gusty tail winds.NTSB LAX90LA044Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Rialto, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the gusty crosswind conditions.NTSB MKC90LA037Accident · No injuriesLimited investigationFinal reportSaint Louis YPT-15 · Creve Coeur, MOThe pilot's failure to maintain directional control of the airplane. Contribuiting to the accident was the sun glare.NTSB SEA90LA024Accident · No injuriesLimited investigationFinal reportCessna A-185-F · Seattle, WAThe pilot did not maintain directional control of the airplane during the landing roll.NTSB MIA90LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Cocoa, FLFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground swerve. Factors related to the accident were the crosswind condition and ditch.NTSB FTW90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Cresson, TXThe failure of the student pilot to maintain directional control of the airplane and the cfi's inability to regain control. Contributing to the accident was the lack of brakes on the cfi's side of the airplane.NTSB NYC90LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Westfield, MALoss of control during landing due to an improper flare and recovery from a bounced landing. A factor relating to the accident was the lack of total experience of the student pilot.NTSB CHI90LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student's lack of total experience, his diversion of too much attention to…NTSB LAX90LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Santa Ynez, CAThe student pilot's loss of directional control during a go-around.NTSB MKC90LA035Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Louis, MOThe pilot's failure to adequately compensate for the wind. The gusty, crosswind condition is considered a contributing factor to the accident.NTSB BFO90LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Mitchellville, MDThe pilot allowed the aircraft to enter an inadvertent porpoise during an aborted takeoff.NTSB LAX90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rancho Calif, CAThe pilot's loss of directional control during a crosswind landing.NTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.NTSB LAX90LA032Accident · No injuriesLimited investigationFinal reportMooney 201 · Concord, CAThe pilot's loss of directional control and subsequent collision with an object during a touch and go landing in visual meteorological conditions.NTSB DEN90LA019Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Fort Collins, COInadequate compensation for wind conditons by the pilot which resulted in his failure to maintain directional control. Factors related to the accident were: the unfavorable wind condition and soft terrain.NTSB NYC90FA024Accident · Serious injuriesField investigationFinal reportCessna 145 · Bayport, NYThe pilot failed to maintain adequate airspeed during a go-around while recovering from a bounced landing. Contributing factor(s) was: an improper level-off and recovery from a bounced landing.NTSB MIA90IA020Incident · No injuriesIncident investigationFinal reportClassic YMF-5 · Marathon, FLThe pilot's incorrect elevator control while taxiing with a quartering tailwind. Contributing to the incident was the tailwind condition.NTSB LAX90LA018Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB NYC90LA022Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Pittstown, NJThe pilot's failure to maintain directional control during landing.NTSB MIA90LA019Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Zellwood, FLImproper planning/decision by the pilot. The crosswind and ditch were related factors.NTSB ATL90LA015Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Florence, SCThe worn steering system.NTSB MKC90LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · St Louis, MODirectional control not maintained by the pilot in command. A contributing factor was the gusty crosswind.NTSB DEN90LA011Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Sterling, COThe pilot failed to correct a ground loop/swerve during landing roll. A strong crosswind was a contributing factor.NTSB SEA90LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · White City, ORThe pilot did not maintain direction control of the airplane during the landing roll and took inadequate remedial action. Factors contributing to the accident include terrain and the pilot's lack of total expereince.NTSB MKC90LA023Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Heafer, ARThe intentional swerve by the pilot during the takeoff roll. Contributing to the accident was the rough and soft terrain conditions.NTSB BFO90LA006Accident · No injuriesLimited investigationFinal reportCessna T310Q · Stevensville, MDThe pilot failed to maintain directional control of the aircraft during the landing roll.NTSB LAX90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Paso Robles, CAThe student pilot's failure to adequately compensate for the cross wind condition.NTSB CHI90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Toledo, OHFailure of the pilot to maintain directional control, which resulted in a ground swerve. Factors related to the accident were: the crosswind and the pilot's improper compensation for wind condition.NTSB SEA90LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Hoonah, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors related to the accident were: unfavorable/gusty wind conditions and the berm.NTSB LAX90DJA01Accident · Minor injuriesFinal reportEmair MA1-B · Hilo, HIThe failure of a main landing gear tire which caused the pilot to apply excessive brake pressure to avoid departing a narrow landing strip. Contributing to the accident was the pilot accepting an aircraft that had a tire worn beyond safe limits and…NTSB LAX90LA003Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Penn Valley, CAFailure of the pilot to maintain directional control during the landing roll-out, which resulted in an inadvertent ground swerve. Uneven terrain beside the runway was a factor.NTSB ATL90LA003Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Albemarle, NCThe pilot's failure to maintain directional control of the airplane.NTSB NYC90LA003Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennington, VTFailure of the student pilot to maintain directional control during landing. Contributing factor(s) was: the crosswind.NTSB MKC90LA003Accident · No injuriesLimited investigationFinal reportStits-Itrich SA6B · Swan, IAThe pilot's failure to adequately compensate for the gusty crosswind conditions which contributed to the accident.NTSB MIA89LA257Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockledge, FLFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. The gusty crosswind and proximity of the parked aircraft were related factors.NTSB LAX89LA330Accident · No injuriesLimited investigationFinal reportCessna 180 · Flagstaff, AZFailure of the left brake. The pilot's failure to maintain directional control with rudder and tailwheel steering was considered to be a related factor.NTSB LAX89DVA11Accident · 1 fatalFinal reportSkilling VARI-EZE · Oakdale, CAThe pilot's failure to maintain directional control and the delayed initiation of the aborted landing. A factor was lack of aircraft familiarity.NTSB CHI89DEE06Accident · Minor injuriesFinal reportHowe Quickie Q2 · Lakeinthehills, ILThe pilot failed to maintain directional control of the airplane during a bounced landing. A factor related to the accident was the pilot's evasive maneuver to avoid rolling into a stone quarry.NTSB SEA89LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · East Sound, WAThe student pilot's failure to maintain directional control.NTSB LAX89LA320Accident · Minor injuriesLimited investigationFinal reportAir & Space 18A · Palo Alto, CAImproper planning/decision by the instructor pilot (CFI), which resulted in a loss of control as the gyroplane went into ground resonance.NTSB DCA89MA074Accident · 2 fatalClass 1 · MajorFinal reportBoeing 737-400 · Flushing, NYThe captain's failure to exercise his command authority in a timely manner to reject the takeoff or take sufficient control to continue the takeoff, which was initiated with a mistrimmed rudder. Also causal was the captain's failure to detect the mistrimmed…NTSB CHI89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Ypsilanti, MIThe failure of the plt to maintain directional control during the takeoff ground roll. Rain softened terrain adjacent to the runway surface is a contributing factor to the accident.