NTSB investigations, 2004
44 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\") = 2004
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") = 2004 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 MIA05CA022Accident · No injuriesData collectionFinal reportChampion 7GCBC · Pierson, FLThe inadequate visual lookout by the pilot-in-command resulting in the airplane encountering uneven terrain, propeller contact to the ground, and subsequent nose over.NTSB ANC05CA012Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over during the landing roll. A factor associated with the accident was deep crusted snow.NTSB DEN05LA022Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pueblo, COThe pilot’s inadequate compensation for wind and his failure to maintain aircraft control which resulted in a gear collapse due to an on-ground collision with terrain. Contributing factors were the wind shear, gusty wind conditions, and rough terrain. This…NTSB ANC05CA013Accident · No injuriesData collectionFinal reportCessna 185 · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over during the landing roll. A factor associated with the accident was deep wet snow.NTSB ANC05LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrrain during the landing roll. Factors contributing to the accident were a rough/rutted and snow-covered airstrip surface, and an inadvertent ground…NTSB LAX05CA001Accident · No injuriesData collectionFinal reportCessna TU206A · Nogales, AZthe pilot's failure to remain on the designated taxiway surface, which resulted in the airplane's collision with the ditch. The dark lighting condition was a factor to the accident.NTSB CHI04LA298Accident · No injuriesLimited investigationFinal reportCessna 208B · Decatur, ILThe pilot's inadequate preflight preparation, and his subsequent selection of a runway for takeoff that was listed as out of service, resulting in a collision with barricades and uneven terrain during takeoff.NTSB ANC04CA111Accident · No injuriesData collectionFinal reportChampion 7GCBC · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the collapse of the right main landing gear during the landing roll. A factor contributing to the accident was rough and uneven terrain.NTSB FTW04CA233Accident · No injuriesData collectionFinal reportSenior Aero Sport D-260 · Mc Kinney, TXThe pilot's failure to obtain and maintain proper alignment with the runway centerline during the landing roll.NTSB ANC04LA097Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's failure to abort the takeoff, which resulted in a collision with a river bank during the takeoff run.NTSB ANC04LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Paxson, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a rock and subsequent main landing gear collapse during the landing roll. A factor contributing to the accident was rough, uneven terrain.NTSB ANC04CA088Accident · No injuriesData collectionFinal reportCessna 182F · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the ensuing aborted landing when the airplane encountered soft terrain. Factors contributing to the accident were the soft, swampy area surrounding the landing zone.NTSB CHI04CA219Accident · No injuriesData collectionFinal reportLake LA4-200 · Oshkosh, WIThe unsuitable rough water conditions encountered during the attempted water takeoff.NTSB CHI04CA200Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33 · Warrensburg, MOThe pilot's inadequate compaensation for the winds, and his inability to maintain directional control of the glider after encountering tall grass during the landing roll. The reported wind gust, tall grass, and the fence were contributing factors.NTSB ANC04LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Yakutat, AKThe pilot's selection of an unsuitable landing area, which resulted in the collapse of the landing gear, and subsequent nose over during the landing roll. A factor associated with the accident was soft terrain.NTSB NYC04LA158Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Batavia, OHThe pilot's inadequate preflight preparation which failed to assure the takeoff performance needed to out climb obstacles. Factors in this accident were the up sloping runway, the high density altitude, and airplane being loaded above it's maximum gross…NTSB DEN04CA100Accident · No injuriesData collectionFinal reportAeronca 7AC · Limon, COthe pilot's inadequate preflight planning/preparation. A contributing factor was the soft terrain in the takeoff area.NTSB CHI04CA175Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Lake City, MIThe pilot selecting the wrong runway for the wind conditions and his delay in executing an aborted takeoff resulting in the airplane running off the departure end of the runway and into a ditch. The tailwind and the ditch were contributing factors.NTSB ANC04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Beluga, AKThe pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with rocks during the landing roll, and the collapse of the left main landing gear.NTSB CHI04CA160Accident · Minor injuriesData collectionFinal reportChampion 7FC · Carmi, ILThe pilot's failure to maintain directional control during the takeoff roll, his decision to continue the takeoff when the aircraft had left the runway surface, and his selection of unsuitable terrain for the continued takeoff. An additional cause was the…NTSB NYC04CA143Accident · No injuriesData collectionFinal reportStearman 4E · Loganton, PAThe pilot's failure to maintain aircraft control during the landing roll, which resulted in a nose over. A factor was uneven terrain.NTSB ANC04LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of soft tundra.NTSB ANC04LA061Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing flare/touchdown. A factor contributing to the accident was soft tundra terrain.NTSB IAD04LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Old Town, METhe pilot's failure to abort the takeoff. Factors were the pilot's incorrect assessment of the airplane's weight and the muddy terrain.NTSB NYC04CA114Accident · Minor injuriesData collectionFinal reportCessna 305 A · Taunton, MAThe pilots inadequate pre-flight planning which resulted in a landing on soft terrain and subsequent nose over. A factor was the soft terrain.NTSB ANC04LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · Skwentna, AKThe pilot's selection of an unsuitable landing site, which resulted in a nose over during the landing roll.NTSB CHI04CA102Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Lake Village, INThe unsuitable terrain the Certified Flight Instructor encountered during the off-field landing. The low altitude, the downdraft or "sink" experienced during flight, and the soft terrain conditions were factors to the accident.NTSB NYC04CA096Accident · No injuriesData collectionFinal reportHughes 269B · Farmingdale, NYThe pilot's failure to maintain aircraft control while hover-taxiing. A factor in this accident was the high wind condition.NTSB ANC04LA037Accident · No injuriesLimited investigationFinal reportPiper PA-31T3 · Kaktovik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane colliding with drifted snow during the landing roll. Factors contributing to the accident were a snow covered runway, airport personnel's failure to remove accumulated…NTSB CHI04LA086Accident · No injuriesLimited investigationFinal reportBeech 1900D · Manhattan, KSThe captain's improper decision due to his attempt to taxi back onto the runway after coming to a stop in the grass, and the resulting collapse of nose landing gear. Contributing factors were the inoperative nose wheel steering, the pilot's inability to…NTSB SEA04LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Eltopia, WARemedial action delayed during the takeoff roll. Factors include rough/uneven terrain.NTSB DEN04LA049Accident · No injuriesLimited investigationFinal reportCessna 182P · Hanksville, UTthe pilot's selection of unsuitable terrain to conduct a precautionary landing. Factors contributing to the accident was the soft, dirt road.NTSB MIA04CA055Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Parkland, FLThe pilot's inadequate preflight planning which resulted in an off-airport precautionary landing to preclude fuel exhaustion, which resulted in damage to the airplane during the landing.NTSB NYC04CA080Accident · No injuriesData collectionFinal reportBellanca 7ECA · Hornell, NYAn inadvertent encounter with soft snow during takeoff.NTSB CHI04LA075Accident · No injuriesLimited investigationFinal reportCessna 120 · Merrill, WIThe pilot's selection of unsuitable terrain to conduct a landing. Factors were the reported flat light conditions and the uneven terrain.NTSB CHI04LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Memphis, MODirectional control not maintained by the flight instructor during the landing roll. The snow on the edge of the runway, and the wind gusts were factors.NTSB IAD04LA011Accident · No injuriesLimited investigationFinal reportCessna 210E · Pittsburgh, PAThe owner/pilot-mechanic's failure to comply with an airworthiness directive, which resulted in a fatigue fracture to the left main landing gear saddle.NTSB LAX04CA130Accident · No injuriesData collectionFinal reportCessna 172S · Riverside, CAthe pilot's inadequate visual lookout, which resulted in his failure to maintain proper alignment with the taxiway. Factors in the accident were the dusk lighting conditions and pilot not understanding the ground control taxi clearance.NTSB SEA04CA041Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Rexburg, IDThe pilot's failure to maintain runway alignment, and clearance from the snow bank. A snow bank adjacent to the runway was a factor.NTSB CHI04LA072Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Sunburg, MNThe pilot's improper in-flight decision to land off-airport. A factor to the accident was the snow covered ditch.NTSB IAD04CA010Accident · No injuriesData collectionFinal reportPiper PA-20 · West Ossipee, NHThe pilot's inability to maintain runway alignment during the landing rollout. Factors included the night lighting conditions and the snow banks that prevented visual reference to the runway lights.NTSB CHI04LA054Accident · No injuriesLimited investigationFinal reportCessna 150E · Princeton, MOThe encounter with the unknown snow drifts during landing. The factors were the snow drifts, night, and the airport's failure to issue a NOTAM on the runway conditions.NTSB DEN04LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glade Park, COthe pilot's inadequate in-flight planning/decision. Contributing factors include the pilot's selection of unsuitable terrain for landing and the snow covered terrain.NTSB LAX04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Hayfork, CAthe pilot's inadequate in-flight decision to attempt a landing on a snow covered runway without ascertaining the depth of the snow cover.