NTSB investigations, 1992
217 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
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 year(c.\"eventDate\") = 1992
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") = 1992 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 LAX93LA085Accident · No injuriesLimited investigationFinal reportMooney M20F · So. Lake Tahoe, CAThe pilot's failure to maintain directional control of the aircraft due to gusting cross winds and ice on the runway.NTSB LAX93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Big Bear, CAThe pilot's failure to maintain directional control of the aircraft after touchdown.NTSB LAX93LA082Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Oceano, CAThe pilot's operation of the aircraft with known deficiencies in the brake system.NTSB LAX93LA081Accident · No injuriesLimited investigationFinal reportVarga 2150A · Salome, AZThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the failure of the left brake.NTSB CHI93LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake In The Hls, ILThe student pilot's failure to maintain directional control.NTSB ATL93LA042Accident · No injuriesLimited investigationFinal reportPitts S2B · Tuscaloosa, ALThe failure of the pilot to maintain directional control of the aircraft, during the take off roll. A factor was the wind gust.NTSB CHI93LA057Accident · No injuriesLimited investigationFinal reportBeech V35A · Marshall, MNThe pilot's improper aircraft handling during ground operation with a gusty tailwind.NTSB NYC93LA046Accident · No injuriesLimited investigationFinal reportCessna 150L · Weedsport, NYThe flight instructor did not maintain directional control of the airplane during the after landing roll. Factors in this accident were the strong cross winds and the ice patched runway.NTSB ATL93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Greensboro, NCThe improper flare by the pilot which resulted in a hard landing and ground loop of the aircraft. A factor in the accident was the crosswind at the time of the landing.NTSB ATL93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Atlanta, GAThe student pilot's failure to maintain directional control of the airplane.NTSB NYC93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cheriton, VAThe pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.NTSB NYC93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-301T · Jaffrey, NHAn improper weld by other maintenance personnel which resulted in the nose gear collapsing, and a loss of directional control on takeoff.NTSB LAX93LA064Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Auburn, CAFailure of the pilot to maintain direction control during the landing touchdown. Contributing to the accident inadequate maintenance of the runway safety area by airport personnel.NTSB ANC93LA018Accident · No injuriesLimited investigationFinal reportLuscombe SL8 · Anchorage, AKThe failure of the pilot in command to maintain directional control of his airplane. A factor in the accident was the pilot in commands improper taxi speed.NTSB CHI93LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSThe pilot's improper use of rudder control and subsequent failure to maintain directional control.NTSB DEN93LA013Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Broomfield, COA failure by FBO personnel to properly connect the nose wheel torque link after towing the aircraft.NTSB LAX93LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Clarksburg, CAThe pilot's improper use of the ailerons.NTSB MIA93LA017Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Wiggins, MSThe pilot in command's failure to maintain directional control on landing roll out, resulting in an on ground loss of control (ground loop) and subsequent nose over.NTSB SEA93LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Olympia, WAThe pilot's poor inflight decision, and excessive airspeed on final. Factors include a wet turf runway, and trees adjacent to the runway.NTSB LAX93LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Hawthorne, CAThe pilot's improper use of the brakes. Contributing to this accident was the worn brake pedals.NTSB DEN93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB CHI93LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNThe pilot's failure to maintain directional control.NTSB FTW93LA029Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mcgregor, TXInadvertent stall by the pilot in command. Factors were the pilot's selection of the wrong runway, and the wind conditions.NTSB FTW93LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Vernon, TXThe student pilot's failure to maintain directional control of the airplane. A factor was the stall/mush.NTSB NYC93LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Mallory, WVThe pilot failed to maintain control of the airplane, which resulted in the airplane departing the runway and striking a tree.NTSB NYC93LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monroeville, PAThe pilot's improper compensation for adverse wind conditions during landing, resulting in a loss of directional control and subsequent departure from the runway and collision with trees. Factor related to the accident was: the unfavorable winds.NTSB CHI93LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Carroll, IAThe pilot's failure to maintain aircraft directional control while landing in crosswind conditions.NTSB LAX93LA018Accident · No injuriesLimited investigationFinal reportCessna 305A · Prescott, AZThe pilot not maintaining directional control during landing roll resulting in a ground loop swerve.NTSB CHI93LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Weeping Water, NEThe pilot's failure to maintain directional control.NTSB NYC93LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Princeton, NJThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway, impacting with a wall and subsequently caught fire. A contributing factor was the pilot improperly compensated for a crosswind.NTSB SEA93LA008Accident · No injuriesLimited investigationFinal reportJames R. Prideaux Avid Flyer · Mt. Home, IDDirectional control was not maintained. A factor to the accident was: a tail wind.NTSB FTW93LA011Accident · No injuriesLimited investigationFinal reportCessna L-19A · Brookshire, TXThe pilot's improper compensation for the cross wind. A factor was the crosswind.NTSB NYC93LA014Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · St. Clairsville, OHThe pilot's improper in-flight planning and decision to land on a short grass runway with a tail wind. A factor in this accident was the pilots failure to obtain and evaluate a weather briefing prior to the flight.NTSB NYC93LA009Accident · No injuriesLimited investigationFinal reportAeronca 11-AC · Columbus, OHThe pilot failed to maintain control of the airplane, resulting the airplane departing the runway and impacted with the VASI lights.NTSB CHI93LA007Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Wichita, KSInadequate preflight planning/preparation by the pilot, the pilot's over confidence in his personal ability, and airplane performance data not followed by the pilot.NTSB DEN93LA002Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COFailure of the pilot in command to maintain directional control during landing roll. A factor was excessive airspeed during landing.NTSB CHI93LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · West Branch, MIThe pilot's failure to maintain aircraft control during the landing roll.NTSB LAX93LA002Accident · No injuriesLimited investigationFinal reportCessna 172P · Reno, NVThe student pilot's improper remedial action and improper use of the rudder. Contributing to this accident was the student pilot's improper flare and lack of total experience.NTSB LAX93LA001Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZFailure of the pilot to maintain directional control and improper use of the flight controls and brakes.NTSB CHI92LA296Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Plattsmouth, NEThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control.NTSB BFO92LA148Accident · No injuriesLimited investigationFinal reportMooney M20E · Stow, MAFailure of the pilot to attain proper runway alignment during landing. Factors related to the accident were darkness, a lack of runway lighting on the left side of the runway, and the pilot's lack of visual ques.NTSB CHI92LA285Accident · No injuriesLimited investigationFinal reportCessna 177B · Norcross, MNThe pilot's premature liftoff which resulted in inadequate airspeed for takeoff. Factors related to the accident were the crosswind conditions, the pilot's inadequate compensation for the crosswind, and the pilot's total lack of experience.NTSB SEA92LA213Accident · No injuriesLimited investigationFinal reportCessna 172M · Lloyd, MTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was wind gusts.NTSB LAX92LA392Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Columbia, CAThe failure of the student to maintain directional control of the aircraft during the low speed portion of the landing roll. A factor in the accident was the lack of brake pedals at the instructor's seat position on the right side of the cockpit.NTSB LAX92LA391Accident · No injuriesLimited investigationFinal reportBeech D17S · Reno, NVThe pilots failure to maintain directional control during landing rollout. Contributing to the accident was a variable tailwind condition and the soft, rough nature of the terrain.NTSB SEA92LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lopez, WAThe pilot's faiure to obtain proper assistance and to properly set the throttle.NTSB MIA92LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Belzoni, MSCollapse of the right main landing gear tire due to undetermined reasons.NTSB CHI92LA275Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Caledonia, MIFailure of the pilot in command to maintain directional control during a landing rollout.NTSB ANC92LA165Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Talkeetna, AKThe student pilot's failure to maintain directional control on landing roll.NTSB SEA92LA200Accident · Minor injuriesLimited investigationFinal reportYork Y2 · Mountain Home, IDThe pilot's failure to maintain directional control. Factors include gusty crosswinds.