NTSB investigations, 1997
219 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\") = 1997
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") = 1997 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 FTW98LA077Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Worth, TXthe pilot's improper planning/decision, by allowing the airplane to get in a situation, where he could not compensate for wind conditions. A related factor was the gusty crosswind.NTSB FTW98LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Related factors were: the gusty crosswind condition, icy runway, and proximity of the snowbank.NTSB FTW98LA079Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Englewood, COThe pilot's improper decision to land in wind conditions that exceeded the airplane's crosswind component, and his failure to divert to an alternate airport with runways more nearly aligned with the wind. Factors were the icy runway and crosswind.NTSB SEA98LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Kenmore, WAthe pilot's inadequately planned approach and failure to maintain directional control. The pilot's lack of total experience in kind of aircraft and haze were factors.NTSB ATL98LA028Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Eustis, FLfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in a ground swerve and subsequent collision with a parked airplane. Related factors were: the pilot's lack of experience in tailwheel aircraft, the…NTSB CHI98LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Sidney, NEthe student pilot's inadequate compensation for the crosswind which resulted in a loss of directional control. Factors associated with the accident were the crosswind, the misunderstood radio communication, and the rough terrain which the airplane encountered.NTSB CHI98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hillsdale, MIThe student pilot's failure to maintain. Contributing were icy conditions on the runway and a snowbank.NTSB FTW98LA082Accident · No injuriesLimited investigationFinal reportMooney M20 · Pocahontas, ARfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in an inadvertent ground swerve. A related factor was: the pilot's lack of recent experience in the make and model of airplane.NTSB NYC98LA040Accident · No injuriesLimited investigationFinal reportCessna 172P · Mitchellville, MDThe pilot's improper recovery from a bounced landing.NTSB CHI98LA052Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Vicksburg, MIthe pilot's inadequate preflight preparation and his failure to maintain directional control during takeoff. A factor was the uneven runway at the grass airstrip.NTSB NYC98LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Johnstown, PAthe pilot's failure to maintain direction control of the airplane during the takeoff roll. Factors relating to this accident were: the crosswind condition, and snowbank.NTSB CHI98LA049Accident · No injuriesLimited investigationFinal reportKing Avid Flyer C · Minneapolis, MNThe pilot's failure to maintain directional control. A related factor was the crosswind.NTSB LAX98LA044Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · San Martin, CAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.NTSB FTW98LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesquite, TXthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane, while landing. The gusty crosswind was a related factor.NTSB NYC98LA031Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tiverton, OHthe pilot's failure to properly set the airplane controls prior to hand propping. Factors in the accident were the pilot's failure to properly chock the wheels and his decision to leave the cockpit unmanned during start.NTSB NYC98LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Mount Holly, NJThe student pilot's failure to maintain directional control during the landing roll.NTSB SEA98LA012Accident · No injuriesLimited investigationFinal reportAerostar PA-60-700P · Portland, ORThe pilot's selection of an improper remedial action for an unanticipated yaw excursion during takeoff roll, resulting in the aircraft becoming airborne with inadequate airspeed and consequent loss of aircraft control.NTSB FTW98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Broomfield, COthe pilot's failure to maintain directional control of the airplane during the takeoff roll, due to inadvertently stepping on the brake. A related factor was the pilot's excessive use of rudder for steering.NTSB SEA98LA011Accident · No injuriesLimited investigationFinal reportCessna 150H · Missoula, MTThe student pilot's failure to maintain directional control.NTSB IAD98LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Farmingdale, NYThe student pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A factor was the cross wind condition.NTSB LAX98LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Payson, AZThe pilot's selection of a downwind direction to land and his failure to compensate for the quartering tailwind condition.NTSB FTW98LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · Tooele, UTfailure of the pilot to maintain directional control of the airplane, while landing. Factors related to the accident were: the pilot's improper flare for landing, his delay in attempting to go around (abort the landing), and the encounter with a runway marker…NTSB LAX98LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Prescott, AZThe student's inadvertent application of left brake during touchdown, and the instructor's inadequate supervision of the flight.NTSB IAD98LA011Accident · No injuriesLimited investigationFinal reportSilvaire Luscombe 8B · Bluefield, WVThe pilot failed to maintain control of the airplane.NTSB LAX98LA019Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fullerton, CAthe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an inadvertent ground swerve and subsequent damage to the airplane.NTSB LAX98LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAfailure of the student pilot to maintain directional control of the airplane during a touch-and-go landing, which resulted in an inadvertent ground swerve, an encounter with soft terrain, and a nose over. The sudden gust of wind was a related factor.NTSB IAD98LA006Accident · No injuriesLimited investigationFinal reportAviat A-1 · Duxbury, MAFailure of the pilot to maintain control of the airplane. A related factor was the wind gusts.NTSB SEA98LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Challis, IDThe pilot's failure to maintain directional control during landing. Factors were inattention and fatigue.NTSB FTW98LA020Accident · No injuriesLimited investigationFinal reportCessna 180J · Chama, NMthe pilot's failure to maintain directional control of the airplane during its landing roll. Encounter with an embankment (dirt bank) was a related factor.NTSB NYC98LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Piqua, OHThe student pilot's inadequate compensation for the wind condition. A factor in this accident was the crosswind condition.NTSB LAX98LA011Accident · No injuriesLimited investigationFinal reportCessna 170A · Quincy, CAloss of directional control due to a severe tail wheel vibration, which was induced by an improperly installed and adjusted tail wheel assembly.NTSB LAX98LA003Accident · No injuriesLimited investigationFinal reportCessna 185F · Oakland, CAThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control.NTSB LAX98LA004Accident · No injuriesLimited investigationFinal reportAmerican 8KCAB · Payson, AZDirectional control of the aircraft not maintained through the improper use of landing procedures/techniques. A factor in this accident was the pilot's training regarding the proper techniques to be used during landing.NTSB IAD98FA001Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · College Park, MDThe pilot failed to maintain control of the airplane during landing rollout and his delayed decision to abort the landing.NTSB NYC98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe student pilot's failure to maintain directional control of the airplane.NTSB LAX98LA002Accident · No injuriesLimited investigationFinal reportBlackwell Midget Mustang · Glendale, AZThe pilot's inability to maintain directional control of the aircraft due to the deflation of the right main gear tire. Factors in this accident were the soft sand on the side of the runway and the left crosswind.NTSB FTW98LA017Accident · No injuriesLimited investigationFinal reportCessna A152 · Rockwall, TXThe pilot's improper recovery from a bounced landing and her failure to maintain directional control during the aborted landing. Factors were the wind gust and the turbulence.NTSB CHI98TA023Accident · No injuriesFinal reportCessna A185F · Roseau, MNthe pilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB FTW97LA372Accident · No injuriesLimited investigationFinal reportCessna 170A · Oklahoma City, OKThe pilot's inadequate compensation for the crosswind conditions resulting in an inadvertent groundloop. Factors were the crosswind, the pilot's lack of total experience in make and model, the separation of the left main wheel due to corroded bolts, and the…NTSB NYC97LA189Accident · No injuriesLimited investigationFinal reportCessna 172 · Kutztown, PAthe student pilot's failure to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the student's pilot's selection of the wrong runway, the resultant tailwind, and the encounter…NTSB CHI97LA303Accident · No injuriesLimited investigationFinal reportCessna 172P · Yankton, SDThe pilot's failure to maintain control of the aircraft. A factor contributing to the accident was the wind gusts.NTSB LAX97LA329Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hawthorne, NVThe pilot's inadequate compensation for the existing wind condition and his subsequent failure to maintain directional control.NTSB SEA97LA213Accident · Minor injuriesLimited investigationFinal reportBarrigar RV-6 · Goldendale, WAThe pilot's failure to maintain directional control. Factors contributing to the accident were: the pilot's delayed initiation of a go-around maneuver, downhill, and soft terrain.NTSB ANC97TA152Accident · No injuriesFinal reportPiper PA-18 · Coldfoot, AKThe overservicing/pressurizing of the hydraulic brake system by maintenance personnel that locked the brake system and prevented directional control.NTSB ANC97LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Northway, AKThe pilot's failure to maintain directional control during the landing. A factor in the accident was the pilot's lack of familiarity with the airplane.NTSB ANC97LA149Accident · No injuriesLimited investigationFinal reportMaule M4-210 · Bethel, AKThe pilot's abrupt application of brakes during the landing roll.NTSB MIA97LA244Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Louisville, MSThe failure of the pilot to assure that the rudder trim was properly set for takeoff and his delay in aborting the takeoff when the airplane yawed to the left during the early portion of the takeoff roll.NTSB SEA97LA209Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-1 · Winlock, WAthe pilot's failure to attain proper alignment during touchdown and failure to maintain directional control. A wet runway was a factor.NTSB LAX97LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZthe student pilot's failure to maintain directional control of the airplane and proper alignment with the runway during landing.NTSB LAX97LA323Accident · No injuriesLimited investigationFinal reportNewberg PL-4A · Placerville, CAfailure of the pilot to maintain directional control of the aircraft during the rollout phase of the landing sequence, which resulted in a gound swerve.