NTSB investigations, 1993
232 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\") = 1993
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") = 1993 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 CHI94LA055Accident · No injuriesLimited investigationFinal reportCessna 185 · Grand Island, NEthe pilot's failure to maintain directional control of the airplane. A factor related to the accident was the gusty quartering tailwind condition.NTSB CHI94LA065Accident · No injuriesLimited investigationFinal reportCessna 210M · Festus, MOImproper planning/decision by the pilot. Factors related to the accident were: the icy runway, crosswind and snowbank.NTSB CHI94LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the pilot's lack of total flight experience.NTSB ANC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Port Lions, AKImproper inflight planning and decision-making by the pilot in command. Factors contributing to the accident were the icy runway condition and the tailwind.NTSB LAX94LA070Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Santa Paula, CAA failure of the pilot to maintain directional control of the tailwheel airplane following touchdown. The pilot's lack of total experience in the type of airplane was a factor in the accident.NTSB MIA94LA038Accident · No injuriesLimited investigationFinal reportCessna 650 · Tampa, FLThe pic's improper decision to taxi the airplane off the taxiway. Contributing to the accident was the improper wiring of the anti-skid system.NTSB FTW94LA040Accident · No injuriesLimited investigationFinal reportCessna A185F · Maybell, COThe pilot's failure to ascertain the condition of the landing area. The snow covered condition of the runway was a factor.NTSB ATL94FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mount Airy, NCThe pilot's improper decision to land downwind, failure to control the aircraft on the ground, and his decision to abort the landing after loss of control and damage to the aircraft on the ground. A factor in the accident was the gusty tail wind at the time…NTSB LAX94LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAwas the student pilot's improper use of the rudder. The student pilot's lack of total experience was a factor in this accident.NTSB CHI94LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Neosho, MOThe pilot-in-command's failure to maintain directional control during landing rollout.NTSB FTW94LA024Accident · No injuriesLimited investigationFinal reportBellanca BL17-31ATC · Pagosa Springs, COFailure by the pilot in command to maintain control of the aircraft during landing roll.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 ANC94LA015Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Goose Bay, AKThe pilot-in-command did not maintain directional control of the airplane. A factor in the accident were the trees adjacent to the side of the runway.NTSB LAX94LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZThe pilot's loss of directional control due to his improper bounced landing recovery technique and the improper use of the rudder controls. A factor in the accident was the pilot's lack of total experience in conventional landing gear aircraft.NTSB NYC94LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Somerset, PAwas the failure of the pilot to adequately compensate for wind conditions, and maintain directional control. A factor related to the accident were the gusting crosswinds.NTSB ATL94LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lexington, NCThe pilot's failure to maintain directional control during a crosswind landing. A factor was the crosswind condition.NTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.NTSB FTW94LA018Accident · No injuriesLimited investigationFinal reportCessna 150L · Athens, TXPilot's failure to maintain directional control due to improper compensation for the wind conditions.NTSB CHI94LA012Accident · No injuriesLimited investigationFinal reportCessna A188B · Wall, SDFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the type (make and model) of airplane.NTSB LAX94LA008Accident · No injuriesLimited investigationFinal reportStinson 108 · Mesa, AZa loose wheel half bolt, due to the inadequate maintenance inspection of the aircraft.NTSB SEA94LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Renton, WAThe student pilot's failure to maintain directional control during landing. The crosswind was a factor.NTSB ANC94LA009Accident · No injuriesLimited investigationFinal reportDouglas C-54GDC · Point Lay, AKThe pilot-in-command's failure to perform proper preflight planning by not computing the required landing runway length.NTSB MIA94LA002Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Opa-Locka, FLImproper servicing of three of the four main landing gear dampers by company maintenance personnel, and innadequate remedial action by the pilot as ground resonance began.NTSB FTW94LA006Accident · No injuriesLimited investigationFinal reportCessna 310I · Southlake, TXAircraft control not maintained by the private pilot receiving instruction. Factors were rough runway, runway edge lights inoperative, dark night conditions, brakes restricted due to an out of rig rudder system, and inadequate CFI supervision.NTSB CHI94LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Benton, KSThe failure of the student pilot to maintain directional control and proper runway alignment during the landing roll. The proximity of the ditch to the runway was a related factor.NTSB FTW94LA002Accident · No injuriesLimited investigationFinal reportMaule M-5-200C · Watkins, COThe pilot's loss of directional control resulting in the inadvertent ground loop. A factor was the instructor's failure to take remedial action on a timely manner.NTSB ANC94LA005Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pilot Point, AKThe Pilot-in-command's failure to compensate for the crosswind during taxi. The crosswind was a factor.NTSB SEA93LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tooele, UTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the fence.NTSB LAX93LA372Accident · No injuriesLimited investigationFinal reportCryder RV-6 · Ely, NVthe pilot's failure to maintain directional control of his conventional gear airplane after the failure of a main landing gear tire.NTSB BFO93LA183Accident · No injuriesLimited investigationFinal reportCessna 170B · Martinsburg, WVThe pilot's failure to maintain directional control.NTSB ANC93LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Pumice Creek, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors were the pilot misjudged the wind information, and the unfavorable wind.NTSB LAX93LA359Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Hawthorne, CAdual student's failure to maintain directional control and improper use of the rudder and the CFI's inadequate supervision of the flight.NTSB BFO93LA181Accident · No injuriesLimited investigationFinal reportCessna 180H · New Philadelphi, OHThe pilot's failure to maintain directional control of the airplane during landing rollout, subsequently causing the airplane to veer off the runway and groundloop.NTSB ANC93LA180Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Yantarni Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. A factor was the crosswind.NTSB BFO93LA168Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Gilbertsville, KYThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. The crosswind was a related factor.NTSB FTW93LA258Accident · No injuriesLimited investigationFinal reportCessna 180 · Watkins, COThe pilot's improper compensation for shifting winds.NTSB FTW93LA254Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Oak Grove, LADirectional control not maintained by the pilot for undetermined reasons. Factors were a fence and trees.NTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.NTSB MIA93LA192Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Greenwood, MSOperation of the airplane by the pilot-in-command/cfi with known deficiencies in equipment and the worn condition of the tailwheel assembly.NTSB CHI93LA349Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Delevan, WIthe excessive use of brakes and rudder by the pilot-in-command. A factor related to the accident was the pilot-in-command's lack of total experience in this type of aircraft.NTSB LAX93LA341Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Willows, CAthe pilot's failure to maintain directional control of the aircraft.NTSB ANC93LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Happy Valley, AKThe pilot's improper preflight planning/decision, and his failure to maintain directional control of the airplane. A factor was the rough/uneven terrain.NTSB LAX93LA334Accident · No injuriesLimited investigationFinal reportCessna A150M · Sacramento, CAThe dual student pilot's failure to maintain directional control, improper use of the flight controls, and failure to relinquish the flight controls to the CFI. The soft dirt was a factor in this accident.NTSB CHI93LA336Accident · No injuriesLimited investigationFinal reportCessna 172M · Adrian, MIan excessive taxi speed used by the pilot-in-command. A factor related to the accident was loose gravel on the ramp and inadequate airport maintenance by the airport personnel.NTSB NYC93LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · London, OHThe student pilot's failure to maintain directional control of the airplane after landing, and subsequent departure from the runway and collision with terrain.NTSB ATL93LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB DEN93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Carr, COFailure of the pilot in command to maintain directional control of the aircraft during landing roll. Factors were the pilot disregarding the tailwind, and rough and uneven terrain off the side of the runway.NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.NTSB NYC93LA160Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Moneta, VAThe pilot's loss of directional control after landing, resulting in a departure from the runway and a collision with trees.NTSB DEN93LA102Accident · No injuriesLimited investigationFinal reportCessna 140A · Lake Arthur, NMThe pilot's failure to maintain directional control of the aircraft during landing roll.