NTSB investigations, 1997
33 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 68 |
|---|---|
| 1983 | 54 |
| 1984 | 45 |
| 1985 | 57 |
| 1986 | 34 |
| 1987 | 46 |
| 1988 | 30 |
| 1989 | 40 |
| 1990 | 37 |
| 1991 | 31 |
| 1992 | 27 |
| 1993 | 34 |
| 1994 | 35 |
| 1995 | 45 |
| 1996 | 38 |
| 1997 | 33 |
| 1998 | 46 |
| 1999 | 40 |
| 2000 | 33 |
| 2001 | 35 |
| 2002 | 44 |
| 2003 | 33 |
| 2004 | 44 |
| 2005 | 47 |
| 2006 | 33 |
| 2007 | 39 |
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\" = 320)
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" = 320) 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 NYC98LA050Accident · No injuriesLimited investigationFinal reportBeech 1900D · Windsor Locks, CTThe inadequate snow removal by airport personnel. Contributing factors were the snowbank and whiteout conditions.NTSB ATL98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAfailure of the student pilot to maintain directional control of the airplane, during the landing roll.NTSB ATL98LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe flight instructor's improper short field takeoff procedure and his decision to abort the takeoff after rotation.NTSB ANC98LA009Accident · No injuriesLimited investigationFinal reportCessna 185F · Barrow, AKThe pilot's selection of unsuitable terrain for takeoff, and his delay in aborting the takeoff. A factor in the accident was the presence of gravel/sand in the takeoff area.NTSB FTW98LA035Accident · No injuriesLimited investigationFinal reportPilatus PC-6 · Lexington, TXthe pilot's selection of an unsuitable landing area. A factor relating to the accident was: the uneven terrain (with swales) at the edge of the landing area.NTSB ANC98LA007Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's selection of an unsuitable landing area.NTSB FTW98LA025Accident · No injuriesLimited investigationFinal reportBeech A36TC · Stratford, TXThe pilot's failure to maintain the proper glidepath with the airplane resulting in the airplane not touching down at the proper touchdown point on the runway. A factor was the unfavorable winds.NTSB MIA97LA252Accident · No injuriesLimited investigationFinal reportCessna A188B · Greenwood, MSThe intentional operation of the airplane from an unsuitable takeoff area by the pilot-in-command and inadvertent rotation of the airplane after encountering rising terrain on the runway.NTSB SEA97LA205Accident · No injuriesLimited investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate planning/decision for taking off in the meteorological conditions present at the time. Factors include a high density altitude, gusty winds, downdrafts, and soft terrain in the area of the forced landing.NTSB ANC97LA140Accident · Minor injuriesLimited investigationFinal reportCessna U206F · King Salmon, AKthe pilot's selection of an unsuitable takeoff area. Factors were the sand bar and the pilot's failure to use all available waterway for the takeoff.NTSB FTW97LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Zavalla, TXthe pilot's improper planning/decision, becoming lost/disoriented during the flight, and selection of unsuitable terrain for an emergency/precautionary landing. Factors relating to the accident were: the hazy weather condition, and rough terrain in the…NTSB ANC97LA125Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Karluk, AKthe pilot's selection of unsuitable terrain for landing. Related factors were: the direct left crosswind, and the soft sand.NTSB MIA97LA236Accident · No injuriesLimited investigationFinal reportCessna 182Q · Butler, ALThe failure of the pilot to maintain directional control during a landing attempt after adding power to recover from a bounced landing.NTSB ANC97LA118Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Circle, AKThe inadequate visual lookout by the pilot, and his selection of a landing area with high vegetation in the landing path. Factors which contributed to the accident were fatigue and the high vegatation.NTSB FTW97LA288Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Briggs, TXThe pilot's failure to maintain aircraft control. A factor was the high vegetation on the side of the runway.NTSB CHI97LA237Accident · No injuriesLimited investigationFinal reportCessna 182F · Haviland, KSthe pilot's improper planning/decision and failure to obtain and/or maintain proper runway alignment during a night landing. Factors relating to the accident were: the airplane's inoperative landing lights, the airport's inoperative runway edge lights, and…NTSB LAX97LA233Accident · No injuriesLimited investigationFinal reportCessna 152 · Madera, CAthe student pilot's failure to maintain runway alignment during takeoff.NTSB FTW97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Whitewright, TXThe pilot's selection of an unsuitable area for takeoff. A factor was the dirt bank (terrace).NTSB ATL97LA088Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Ridgely, TNThe pilot's inadequate preflight planning in that he failed to account for the high temperature and high density altitude, which resulted in an aerodynamic stall and loss of control. Factors were the tall crops and the ditch.NTSB CHI97LA176Accident · No injuriesLimited investigationFinal reportMaule M5C · Lino Lakes, MNthe flight instructor's inadequate preflight planning/preparation, his the improper lowering of flaps for takeoff, his failure to use a longer available area for takeoff, and his failure to abort the takeoff before there was an insufficient amount of area…NTSB IAD97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Morgantown, PAThe pilot's improper decision to attempt a landing on and his failure to align with an unlighted runway at night. Factors were the lack of runway lighting and the night light condition.NTSB MIA97LA169Accident · No injuriesLimited investigationFinal reportCessna Wren 182G-460 · Spartanburg, SCthe pilot's inadequate preflight planning/preparation, by failure to survey the takeoff area, and his delay in aborting the takeoff. Upsloping terrain and high vegetation in the takeoff area were related factors.NTSB ANC97LA082Accident · No injuriesLimited investigationFinal reportCessna TU206A · Yakutat, AKthe pilot's selection of unsuitable terrain for landing.NTSB LAX97LA174Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Peoria, AZfailure of the student pilot to maintain proper runway alignment and wing tip clearance from high vegetation beside the runway during landing, and the flight instructor's inadequate supervision of the flight. High vegetation on the runway shoulder was a…NTSB MIA97LA149Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Huntersville, NCThe pilot's failure to maintain a visual lookout on landing rollout, resulting in an on-ground collision with a known obstacle (ditch) and subsequent nose over.NTSB LAX97LA153Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Healdsburg, CAThe loss of pressure in the landing gear normal brake system for undetermined reasons requiring the pilot to make an intentional ground loop to stop the aircraft.NTSB ANC97LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kotzebue, AKthe pilot's selection of unsuitable terrain for taxi and takeoff. Soft/snow covered terrain was a related factor.NTSB ANC97LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Manley Hot Sprn, AKThe pilot's selection of an unsuitable landing area. A factor was the soft snow.NTSB ANC97LA032Accident · No injuriesLimited investigationFinal reportCessna 170A · Willow, AKThe pilot's excessive speed while taxiing. A factor in the accident was flat light conditions.NTSB CHI97LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIthe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the snowbank which the airplane contacted.NTSB ANC97LA020Accident · No injuriesLimited investigationFinal reportCessna 140 · Gustavus, AKthe pilot's selection of unsuitable terrain for landing. The soft terrain was a related factor.NTSB ANC97LA018Accident · No injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKthe pilot's selection of an unsuitable area (terrain) for landing. A factor relating to the accident was: excessive snow cover on the airstrip.NTSB FTW97LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale ATR-42-320 · Houston, TXThe pilot's failure to follow the proper taxi route while taxiing back to the terminal. A factor was the glare radiating from the airport's terminal area.