NTSB investigations, 1999
247 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\") = 1999
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") = 1999 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 NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…NTSB LAX00LA056Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Oxnard, CAThe pilot's inadequate compensation for the variable crosswind condition and subsequent failure to maintain directional control of the airplane.NTSB CHI00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Alexandria, MNThe pilot's inadequate inflight decision to continue flight into icing conditions. An additional cause was the directional control not maintained by the pilot. Contributing factors were the viewable area of the aircraft's heated windshield panel, in-flight…NTSB MIA00LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCThe certified flight instructor (CFI) failure to maintain directional control on rough terrain on takeoff. This resulted in the airplane veering to the left, colliding with bushes after the airplane became airborne, and subsequent in-flight collision with…NTSB LAX00LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Shoshone, CAThe pilot's inadequate compensation for the existing strong and gusting wind conditions and his subsequent failure to maintain directional control.NTSB FTW00LA050Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXThe student pilot's failure to maintain control of the airplane during the landing roll.NTSB ATL00FA016Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Geneva, ALThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall and the subsequent collision with trees.NTSB SEA00LA029Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Port Townsend, WACompensation for wind conditions was inadequate. Gusting wind conditions were a factor.NTSB LAX00LA048Accident · Serious injuriesLimited investigationFinal reportOehling Questair Venture · Auburn, CAThe owner/builder's failure to properly bleed the brake system following replacement of the right brake line, which caused the right brake to not function and led to the pilot's inability to maintain directional control.NTSB MIA00LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Morristown, TNThe pilot's failure to maintain directional control during the takeoff phase of a touch and go landing, and the subsequent skid off the runway and collapsed nose landing gear during the attempt to abort the takeoff.NTSB MIA00LA035Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Daytona Beach, FLThe pilot's failure to maintain directional control during an attempted go-around, and the subsequent wing tip strike of the ground and collision with a tree. A factor in the loss of control was the crosswind conditions present during the landing attempt.NTSB LAX00LA046Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Sedona, AZThe pilot's inadequate compensation for the crosswind conditions and subsequent failure to maintain directional control of the airplane.NTSB NYC00LA043Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Grove City, PAThe flight instructor's failure to maintain control of the airplane during the landing rollout.NTSB NYC00LA032Accident · Minor injuriesLimited investigationFinal reportStatz Kitfox II · Ebensburg, PAwas the failure of the pilot to maintain directional control during a bounced landing recovery. A factor was the pilot's lack of experience in make and model.NTSB IAD00LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Hopedale, MAwas the student pilot's improper flare that resulted in a bounced landing and the flight instructor's delay in taking remedial action.NTSB LAX00LA032Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, CAThe pilot's failure to maintain directional control of the airplane during the touch-and-go takeoff.NTSB FTW00LA031Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rose Hill, TXThe pilot's failure to maintain directional control during takeoff roll, which resulted in an inadvertent ground loop.NTSB CHI00LA030Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Saint Charles, MOthe pilot's failure to maintain directional control on landing. A factor was the crosswind.NTSB ATL00LA011Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Hollandale, MSThe certified flight instructor's inadequate supervision of the landing and the student pilot's failure to relinquish the flight controls when the certified flight instructor attempted to recover from a bounced landing.NTSB CHI00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Hannibal, MOthe pilot not maintaining directional of the airplane. Factors were the crosswinds and gusts.NTSB MIA00LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Raleigh, NCThe pilot's failure to maintain directional control on landing rollout for undetermined reasons. This resulted in the airplane veering off the runway and colliding with an airport sign.NTSB DEN00LA014Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bullfrog, UTThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the pilot's lack of total experience in type of aircraft and the fence.NTSB LAX00LA029Accident · No injuriesLimited investigationFinal reportCessna 170A · El Mirage, CAThe pilot's failure to maintain directional control of his airplane, which resulted in an inadvertent ground loop.NTSB CHI00LA019Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Benton, KSthe pilot's failure to maintain aircraft control, and the physiological impairment of the pilot due to a brain anomaly. The pilots improper decision to operate the airplane with a known medical deficiency, and the ditch were contributing factors.NTSB LAX00LA028Accident · No injuriesLimited investigationFinal reportCessna 305A · Torrance, CAThe pilot's loss of directional control during landing rollout due to the failure of the tail wheel control system. A contributing factor was the quartering tailwind condition.NTSB DEN00LA012Accident · No injuriesLimited investigationFinal reportBeech B-60 · Angel Fire, NMThe pilot's failure to maintain aircraft control, and the pilot's inadequate decision to attempt the takeoff. Factors were the strong left rear cross wind, and the dirt embankment.NTSB NYC00LA016Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Somerville, NJThe pilot's inadequate compensation for wind.NTSB DEN00LA011Accident · No injuriesLimited investigationFinal reportCessna 172B · Englewood, COThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the gusty crosswind and the runway light.NTSB SEA00LA009Accident · No injuriesLimited investigationFinal reportCessna 182B · Atlanta, IDDirectional control not maintained by the pilot in command.NTSB LAX00LA026Accident · No injuriesLimited investigationFinal reportBeech D55 · Corona, CAThe pilot's failure to maintain directional control of the aircraft during takeoff.NTSB SEA00LA016Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Bremerton, WALoss of directional control by the student pilot during landing. Factors include inadequate remedial action by the flight instructor, and an airport sign that was struck by the airplane, collapsing the left main landing gear.NTSB NYC00LA017Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orange, MAThe pilot's failure to maintain directional control during a sudden wind shift.NTSB FTW00LA027Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Terrell, TXThe pilot's failure to maintain aircraft control during landing.NTSB ATL00LA001Accident · No injuriesLimited investigationFinal reportCessna 305C · Morganton, NCThe pilot's inadequate compensation for a tailwind which resulted in the loss of control.NTSB SEA00LA003Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Laurel, MTThe pilot's inadequate compensation for wind conditions. Factors include a dust devil/whirlwind at the location where the pilot was trying to land.NTSB DEN00LA008Accident · No injuriesLimited investigationFinal reportFairchild M62A (PT-19) · Gallup, NMFailure by the pilot in command to maintain control of the aircraft during landing roll. Factors were a lack of experience of either pilot in kind and type of aircraft.NTSB SEA00LA002Accident · No injuriesLimited investigationFinal reportBeech F33A · Idaho Falls, IDThe pilot's failure to adequately compensate for wind conditions. Factors include gusty, turbulent, variable crosswinds, and a fence in the vicinity of the runway.NTSB NYC00LA027Accident · No injuriesLimited investigationFinal reportKolb Firestar · London, KYThe student pilot's inability to maintain control of the airplane after inadvertently allowing it to become airborne. A factor in the accident was his lack of total aviation experience.NTSB LAX00LA022Accident · No injuriesLimited investigationFinal reportCessna 210 · Enterprise, NVThe failure of the pilot to maintain directional control of the aircraft during the landing roll, which resulted in a collision with a ditch.NTSB FTW00LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Village, ARThe pilot's failure to obtain/maintain directional control during landing.NTSB CHI00LA011Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Grand Ledge, MIthe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind and the tree which the airplane contacted.NTSB DEN00LA004Accident · No injuriesLimited investigationFinal reportCessna 180D · Denver, COThe excessive taxi speed used by the pilot exiting the runway via a high-speed taxiway resulting in a loss of control. A factor was the crosswind.NTSB LAX00LA007Accident · No injuriesLimited investigationFinal reportPitts S2B · Salinas, CAThe pilot's inadequate compensation for the effects of torque and P-factor during a go-around from a bounced landing, which led to a loss of control and the inadvertent dragging of a wing.NTSB LAX00LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Yuma, AZThe pilot's inadequate compensation for the existing crosswind conditions.NTSB CHI00LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Pleasant Hills, MOThe pilot's loss of directional control during an aborted takeoff.NTSB NYC00LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hoffmeister, NYThe pilot failure to maintain directional control while step-taxiing. A factor in the accident was gusty winds.NTSB DEN00LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Las Cruces, NMThe pilot's inadvertent ground loop/swerve during landing. A factor was his attention being diverted by a malfunctioning throttle control.NTSB FTW00LA013Accident · No injuriesLimited investigationFinal reportChampion 7FC · Powderly, TXThe pilot's inadequate preflight inspection of the airplane, during which he failed to detect the disconnected tailwheel steering assembly.NTSB NYC99LA238Accident · No injuriesLimited investigationFinal reportBeech F33A · Wildwood, NJThe pilot's improper recover from a bounced landing. A factor related to the accident was the pilot's diverted attention due to the loss of a spouse.