NTSB investigations, 1990
278 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\") = 1990
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") = 1990 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 SEA91LA040Accident · No injuriesLimited investigationFinal reportSwearingen SA-227 · Kalispell, MTThe flight crew's inablity to maintain directional control after landing in snow-depth conditions that had been erroneously reported as being within operating limitations.NTSB SEA91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe certified flight instructor's inability to regain directional control after it was lost by his dual student on an icy, snowy runway.NTSB BFO91LA020Accident · No injuriesLimited investigationFinal reportCessna 402 · Richland, VAFailure of the left main landing gear scissor assembly.NTSB ATL91LA033Accident · No injuriesLimited investigationFinal reportCessna 310Q · Windsor, SCFailure of the owner of the private sod airport to properly maintain the runway, which precipitated the loss of control of the airplane during the landing roll.NTSB FTW91LA026Accident · No injuriesLimited investigationFinal reportCessna 205 · Medford, OKThe pilot's use of improper starting procedures which resulted in the loss of control of the airplane. A factor in the accident was the airplane's encounter with rough terrain during the unmanned taxi.NTSB CHI91LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Lee'S Summit, MOThe pilot's inability to maintain directional control of the airplane after landing. The icy runway and the pilot's lack to total experience were factors.NTSB SEA91LA035Accident · No injuriesLimited investigationFinal reportCessna 182-E · Anacortes, WAThe poor inflight decision by the PIC to land on a short grass airstrip in strong gusty tailwind conditions.NTSB LAX91LA056Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAThe student pilots failure to maintain directional control during the landing. A factor in the accident was his lack of total experience.NTSB CHI91LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Monroe, MIDirectional control not maintained by the PIC.NTSB MIA91LA041Accident · No injuriesLimited investigationFinal reportCessna 182RG · Orlando, FLFailure of the pilot to maintain directional control during the landing roll.NTSB CHI91LA045Accident · No injuriesLimited investigationFinal reportLaister LP-49 · Warrensburg, MOFailure to maintain directional control by the pilot. Factors related to the accident are lack of total experience in type aircraft, and type of operation.NTSB ATL91LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Humboldt, TNThe student pilot's failure to maintain directional control during landing. A factor was the student's lack of recent experience.NTSB DEN91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Welsh, LAThe pilot's improper compensation for wind conditions. A factor was the gusty wind.NTSB CHI91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskegon, MIDirectional control not maintained by the PIC.NTSB CHI91LA036Accident · No injuriesLimited investigationFinal reportCessna T210M · Marshall, MIDirectional control not maintained by the PIC.NTSB ATL91LA022Accident · No injuriesLimited investigationFinal reportBeech A23A · Franklin, NCThe pilots failure to maintain directional control during landing. The presence of gusting crosswinds was a factor in the accident.NTSB NYC91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taunton, MAThe pilot attempted to land in a strong cross wind, lost control of the airplane, ran off the runway and hit the VASI system.NTSB ATL91LA021Accident · No injuriesLimited investigationFinal reportCessna 150 · Arlington, TNThe student pilot's failure to maintain directional control during landing. A factor in this accident was gusty winds.NTSB FTW91LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · N. Little Rock, ARThe failure of the right brake system to release after application for unknown reasons.NTSB NYC91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · North Hampton, MALoss of directional control after landing.NTSB ANC91LA013Accident · No injuriesLimited investigationFinal reportCessna U-206 · Montague Island, AKPilot-in-command's failure to maintain aircraft control during landing.NTSB FTW91LA014Accident · No injuriesLimited investigationFinal reportCessna 140 · Roanoake, TXThe pilot's failure to maintain directional control. A factor was his lack of flying tail wheel (conventional) gear airplanes.NTSB MIA91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLPilot-in-command's failure to land on a runway that was more aligned with the wind. Factors were: crosswind and lack of total experience.NTSB ANC91LA010Accident · No injuriesLimited investigationFinal reportCessna 182N · Chugiak, AKThe pilot failed to maintain directional control. Contributing to the accident was the gusty crosswinds and slippery runway.NTSB ANC91LA009Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot-in-command's failure to maintain directional control of the airplane during the landing roll.NTSB LAX91LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Torrance, CAThe student pilot failed to properly flare the airplane, made an improper recovery from the subsequent bounced landing. Contributing to this accident was the student pilot's total lack of experience and his improper use of the rudder.NTSB SEA91LA011Accident · No injuriesLimited investigationFinal reportCessna 172G · Anacortes, WAThe pilot poorly compensated for the wind condition.NTSB SEA91LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Blackfoot, IDThe pilot did not adequately recover from a bounced landing. Factors were improper airspeed and lack of total expereince.NTSB FTW91LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Eufaula, OKA restriction in the movement of the right rudder pedal. The restriction resulted from a passenger's inadvertent placement of an object on the cockpit's floor.NTSB ANC91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot-in-command's failure to maintain directional control on landing and the failure to select suitable terrain.NTSB CHI91LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskegon, MIThe pilot's improper remedial action. His lack of total expereince was a factor.NTSB FTW91LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Prairie, TXThe student pilot's improper flare technique and use of rudder.NTSB LAX91LA015Accident · No injuriesLimited investigationFinal reportCessna 172L · Placerville, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB FTW91LA007Accident · No injuriesLimited investigationFinal reportBell 47G · Grand Prairie, TXThe pilot's inadequate compensation for the existing tailwind conditions and his failure to maintain rotor RPM.NTSB CHI91LA021Accident · No injuriesLimited investigationFinal reportCessna 170B · Maquoketa, IAThe pilot's inadequate commpensation for wind conditions.NTSB NYC91LA012Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Wildwood, NJThe student pilot's failure to maintain control of the airplane during landing.NTSB DEN91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Englewood, COThe failure of the pilot to maintain directional control.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 ANC91LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-14 · Port Heiden, AKThe pilot's failure to maintain directional control during takeoff. Contributing to the accident were the crosswind, pilot's failure to compensate for the crosswind, the soft runway, and lack of total experience in type of aircraft.NTSB CHI91LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Mason, MIThe pilot's failure to maintain directional control. A factor in the accident is the pilot's lack of total experience in the accident type airplane.NTSB ANC91LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · King Salmon, AKInadvertant stall during an aborted landing.NTSB SEA91LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Pullman, WAThe student pilot's failure to maintain directional control.NTSB CHI91LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Plymouth, MIThe student pilot's failure to maintain directional control during takeoff ground run. A factor in the accident was the soft terrain.NTSB ANC91LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control. Contributing to the accident was the excessive taxi speed and inadequate maintenance on the brakes by the pilot.NTSB NYC91LA007Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Erwinna, PAThe pilot's failure to maintain directional control during the take off roll.NTSB ANC91LA002Accident · No injuriesLimited investigationFinal reportCessna 185B · Koyuktolik, AKPilot-in-command's failure to properly execute a stabilized approach to the first 1/3 of the runway. Contributing to the accident was the excessive airpseed maintained during the approach and landing.NTSB DEN91LA004Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Englewood, COThe pilot's inadequate preflight inspection.NTSB BFO91LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Westminster, MDThe pilot's failure to maintain positive directional control during the landing. Improper crosswind compensation and a variable, gusty crosswind were contributing factors.NTSB CHI91LA004Accident · No injuriesLimited investigationFinal reportBeech E-18 · Minneapolis, MNFailure of the pilot-in-command to maintain directional control of the aircraft during landing roll.NTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.