NTSB investigations, 1998
224 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\") = 1998
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") = 1998 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 LAX99LA062Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Furnace Creek, CAThe pilot's inadequate preflight inspection when he failed to remove the gust lock from the flight controls.NTSB LAX99LA060Accident · No injuriesLimited investigationFinal reportAegerter, Simon Velocity 173E-RG · San Diego, CAThe pilot's inadequate modification to the control systems, which resulted in a restricted elevator control.NTSB SEA99LA024Accident · No injuriesLimited investigationFinal reportCessna 120 · Omak, WAThe pilot-in-command's failure to maintain directional control. Contributing factors were the snow covered runway and a snowbank (berm) at the runway's edge.NTSB CHI99LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Appleton, WIThe pilot's failure to maintain directional control. A related factor was the crosswind.NTSB NYC99LA038Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Cincinnatti, OHThe flight instructor's delay in initiating remedial action. Factors include a wet runway, and the student's inability to maintain airplane directional control during a simulated, on-ground engine failure.NTSB MIA99LA049Accident · No injuriesLimited investigationFinal reportCessna 170 · Lawrenceville, GAThe pilot's failure to maintain directional control.NTSB ANC99LA017Accident · No injuriesLimited investigationFinal reportCasa C-212 · Mcgrath, AKThe flightcrew's inadequate compensation for wind conditions. A factor associated with the accident was a crosswind.NTSB CHI99LA055Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Traverse City, MIThe crew's failure to execute a missed approach and the flying pilot's (captain) failure to maintain directional control upon touchdown with a seven degree left bank and a right quartering tailwind. Factor's were the snow covered runway/landing area and the…NTSB SEA99LA021Accident · No injuriesLimited investigationFinal reportElliott RAF 2000 · Walla Walla, WAThe pilot's failure to maintain directional control after landing.NTSB FTW99LA050Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Mesquite, TXThe student pilot's failure to maintain directional control during a simulated engine failure during takeoff maneuver and the instructor's inadequate supervision. Factors were; the student's lack of total flight time in multiengine airplanes, and the soft…NTSB NYC99FA037Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Greenville, PAThe pilot's failure to maintain directional control during touch-and-go landing, and his failure to maintain obstacle clearance. A factor was the tree.NTSB LAX99LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Tucson, AZFailure of the instructor pilot to maintain directional control and properly supervise the landing. A contributing factor was the unavailability of brakes on the instructor's side (the right side) of the airplane.NTSB NYC99LA034Accident · No injuriesLimited investigationFinal reportUnivair 7GC-AA · Garner, VAA jammed right wheel for undetermined reasons.NTSB CHI99LA049Accident · No injuriesLimited investigationFinal reportCessna 150 · East Troy, WIthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, and the ditch.NTSB FTW99LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Springdale, ARThe pilot's improper recovery from a bounced landing resulting in a ground loop. A factor was the pilot's improper landing flare.NTSB MIA99LA040Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Star, NCThe failure of the pilot to use proper short-field landing procedure, resulting in an extended flare and touchdown by the nose wheel and right main wheel simultaneously, and the subsequent loss of directional control and collision with trees.NTSB FTW99LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot's loss of directional control due to improper use of the rudder. A factor was the hilly terrain beyond the departure end of the runway.NTSB LAX99LA045Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Inyokern, CAThe failure of the pilot to maintain control of the aircraft while landing.NTSB FTW99LA037Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Stuttgart, ARThe separation of the left main landing gear bolt.NTSB CHI99LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · East St. Louis, ILThe student pilot's failure to maintain directional control.NTSB LAX99LA041Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Vacaville, CAThe pilot's inadequate compensation for the existing variable wind conditions and his failure to maintain directional control.NTSB DEN99LA021Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Aurora, COThe pilot's failure to maintain directional control. Factors were the gusty crosswind and terrain.NTSB CHI99LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Tower, MNthe student pilot's failure to maintain directional control of the airplane after landing. Factors contributing to this accident were the icy runway and the snowbank.NTSB FTW99LA026Accident · No injuriesLimited investigationFinal reportBell 206B · Matagorda 713The pilot's loss of control due to his failure to untie ground straps. A factor was his inadequate preflight inspection.NTSB LAX99LA031Accident · No injuriesLimited investigationFinal reportCessna 172N · Lancaster, CAThe failure of the pilot to maintain directional control of the aircraft.NTSB LAX99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Santa Barbara, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain proper runway alignment during landing flare.NTSB IAD99LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-C · Caldwell, NJThe pilot-in-command's failure to maintain directional control resulting in a ground-loop.NTSB CHI99LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Cahokia, ILthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the quartering tailwind and the ditch that the airplane contacted.NTSB FTW99LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Tomball, TXThe student pilot's failure to maintain directional control of the airplane.NTSB LAX99LA021Accident · No injuriesLimited investigationFinal reportCessna 185E · Tucson, AZFailure of the pilot to properly secure the seat which subsequently slid back on the takeoff roll and lead to the pilot's loss of aircraft control.NTSB CHI99LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-150 · Mason, MIwas the pilot not maintaining control of the airplane. A factor in this accident was the pilots lack of total experience in the airplane.NTSB CHI99LA014Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEthe pilot failed to maintain directional control. A factor was the uneven runway condition.NTSB MIA99LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Cartersville, GAFailure of the student pilot to maintain directional control during landing resulting in the aircraft running off the left side of the runway and colliding with a parked aircraft. Factors in the accident were his distraction while raising wing flaps during…NTSB IAD99FA008Accident · Minor injuriesField investigationFinal reportLearjet 45 · Wallops Island, VAThe failure of the pilot to obtain/maintain alignment with the water pool, which resulted in the loss of control. Factors in the accident were the inadequate preflight planning of the flight test facility and the airplane manufacturer which resulted in…NTSB SEA99LA008Accident · No injuriesLimited investigationFinal reportCessna 172K · Dillon, MTThe student pilot-in-command's failure to maintain directional control. Contributing factors were rough terrain and crosswind conditions.NTSB CHI99LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · Rugby, NDthe pilot failed to maintain directional control.NTSB MIA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chamblee, GAThe pilot's excessive use of right wheel brake to correct for a left drift during landing rollout resulting in a ground loop to the right and the left wing contacting the runway.NTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.NTSB SEA99LA009Accident · No injuriesLimited investigationFinal reportPitts S-1 · Mccall, IDThe pilot-in-command's failure to maintain directional control. Contributing factors were the uneven taxiway, inadequate airport maintenance (temporary threshold marking) by the airport management, and a ditch alongside the taxiway.NTSB SEA99LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB MIA99LA011Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilot's decision to attempt a flight with an unairworthy condition (leaky brake) and improper use of brakes on landing rollout. This resulted in a loss of brake fluid, directional control, ground loop, and on ground collision with terrain.NTSB LAX99LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Carson City, NVThe pilot's failure to verify the wind direction and speed, his selection of the wrong runway for the existing wind conditions, and, his inadequate compensation for those wind conditions.NTSB NYC99LA001Accident · No injuriesLimited investigationFinal reportCessna 150M · Wiley Ford, WVWas the failure of the pilot to maintain directional control during an unforecast change in wind velocity. Factors were the gusts and the lack of recent experience for the pilot.NTSB FTW98LA416Accident · No injuriesLimited investigationFinal reportCessna 551 · Pueblo, COThe pilot's delayed flare, improper recovery from a bounced landing, and failure to maintain directional control. A factor was the rough uneven terrain.NTSB SEA98LA187Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Medford, ORDirectional control was not maintained.NTSB SEA98LA195Accident · No injuriesLimited investigationFinal reportEvarts Kitfox IV 1200 · Sula, MTAn excessive brake application by the pilot. Factors included a narrow landing area, the pilot's failure to maintain directional control during a 180-degree taxi turn, and a tailwind.NTSB LAX98LA313Accident · No injuriesLimited investigationFinal reportGrumman HU-16C · Sedona, AZThe pilot in command's selection of the wrong runway for the prevailing wind conditions, and the second pilot's inadequate compensation for the winds. Factors in the accident were the second pilot's lack of experience in the aircraft and the…NTSB ATL98LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Farmville, NCThe pilot's failure to maintain directional control of the aircraft and his improper use of the brakes, which led to the aircraft departing the left side of the runway. Contributing factors were the wet runway and the vehicle.NTSB ANC98LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's failure to maintain directional control. Contributing factors were the gusty crosswind conditions.NTSB FTW98LA418Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Alpine, TXThe pilot's failure to maintain directional control of the airplane for undetermined reasons. A factor was the loose gravel composition of the runway.