NTSB investigations, 2005
47 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\") = 2005
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") = 2005 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 SEA06CA034Accident · Minor injuriesData collectionFinal reportCessna 182G · Sweet Home, ORThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the paved runway surface, encountering muddy terrain and nosing over. Contributing factors were the night light condition and the muddy terrain.NTSB CHI06CA052Accident · No injuriesData collectionFinal reportCessna 152 · Pelican Lake, WIThe pilot selecting an unsuitable landing area. Factors were the snow and ice covered lake.NTSB CHI06CA056Accident · Minor injuriesData collectionFinal reportChampion 7EC · Platteville, WIThe student pilot not maintaining directional control during the landing. A factor was the snow bank the pilot encountered.NTSB CHI06CA053Accident · No injuriesData collectionFinal reportCessna 172R · Morris, ILThe pilot's improper in-flight decision to land with a quartering tailwind and not maintaining directional control. Factors were the quartering tailwind and the snowdrift.NTSB CHI06CA049Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Spirit Lake, IAThe pilot using an unsuitable runway and not maintaining directional control during the landing leading to the nose over on impact with snow. A factor was the snow that remained on the runway after plowing.NTSB CHI06CA048Accident · No injuriesData collectionFinal reportCessna T210M · North Lima, OHThe pilot not maintaining airspeed and directional control during the landing. Factors were the snow covered soft terrain the airplane nosed over on.NTSB CHI06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Toronto, OHThe pilot's decision to depart from the snow-covered runway, which resulted in the swerve during takeoff roll and subsequent nose over.NTSB LAX06CA021Accident · Minor injuriesData collectionFinal reportDirks Glaser DG-300 · California City, CAthe pilot's inadvertent retraction of the gear and failure to deploy the spoilers, and his subsequent failure to attain a proper touchdown point.NTSB DFW06CA009Accident · No injuriesData collectionFinal reportVans RV7A · Reklaw, TXThe failure of the nose landing gear assembly for undetermined reasons, resulting in a nose over.NTSB ANC06CA003Accident · No injuriesData collectionFinal reportPiper PA-22 · Willow, AKThe pilot's selection of an unsuitable takeoff area, which resulted in an on ground encounter with a river during an aborted takeoff.NTSB ANC06CA004Accident · No injuriesData collectionFinal reportCessna 206 · Seward, AKThe pilot's inadequate compensation for wind conditions, which resulted in an on ground encounter with terrain, and subsequent loss of control while landing. A factor associated with the accident was a crosswind.NTSB CHI06CA007Accident · No injuriesData collectionFinal reportBeech C23 · Higginsville, MOThe airport operator's failure to properly mark the runway construction project, the exposed lip at the runway end, and the pilot's failure to obtain NOTAM information prior to the flight. A factor was the inadequate marking of the runway.NTSB SEA06CA002Accident · No injuriesData collectionFinal reportBeech D35 · Creswell, ORThe pilot's failure to attain a proper touchdown point and worn brakes. Inadequate maintenance was a factor.NTSB DEN05CA146Accident · No injuriesData collectionFinal reportSchleicher ASW-20B · Moriarty, NMthe pilot's failure to maintain control of the glider during the takeoff roll which resulted in a ground loop.NTSB ANC05CA137Accident · No injuriesData collectionFinal reportdeHavilland DHC-2 · Igiugig, AKThe pilot's delay in aborting the takeoff run when he was unable to lift one float off the water, which resulted in a subsequent collision with terrain. A factor contributing to the accident was a river bank.NTSB ANC05CA134Accident · No injuriesData collectionFinal reportChampion 7KCAB · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor contributing to the accident was a depression/ditch in the landing surface.NTSB CHI05CA248Accident · No injuriesData collectionFinal reportPiper PA-28-180 · McConnell, ILThe pilot's inadequate preflight/planning which resulted in the attempted takeoff on the soft airstrip. Factors associated with the accident were the soft terrain, the corn crop, and the inadequate airspeed achieved during the takeoff roll.NTSB ANC05TA126Accident · No injuriesFinal reportPiper PA-18-150 · Cold Foot, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing down during the landing roll. A factor associated with the accident was the rough and uneven terrain.NTSB SEA05CA168Accident · No injuriesData collectionFinal reportHughes 269A · Ashland, ORThe inability of the dual student to maintain directional control of the helicopter during the landing roll when the left skid sank into an area of thick, soft, sticky tar, and the instructor pilot's improper decision to perform a full-down autorotational…NTSB ANC05LA123Accident · Minor injuriesLimited investigationFinal reportBrabandt RV-9A · Palmer, AKThe loss of nose gear strut/fork-to-ground clearance that led to the collapse of the nose gear strut and nose-over during the landing roll. Factors contributing to the accident were an uneven dirt/gravel surface runway.NTSB ANC05CA119Accident · Minor injuriesData collectionFinal reportCessna 182 · Nabesna, AKThe pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with brush, and subsequent loss of control during an aborted landing. Factors associated with the accident were high vegetation, and a jammed elevator control.NTSB MIA05LA145Accident · Serious injuriesLimited investigationFinal reportFox Alfred C. Kitfox IV 1200 · Immokalee, FLThe pilot's failure to detect standing water on the grass strip resulting in a nose over during the landing roll.NTSB ANC05LA127Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tyonek, AKThe instructor pilot's inadvertent touchdown during a low pass, and attempted go-around, which resulted in an in-flight collision with terrain, and nose over.NTSB ANC05CA113Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's selection of unsuitable terrain for taxi, which resulted in the airplane encountering a ditch, and the collapse of the main landing gear. A factor associated with the accident was the ditch.NTSB ANC05CA109Accident · No injuriesData collectionFinal reportMaule MX7-180 · Yakutat, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a nose-over. A factor contributing to the accident was soft terrain.NTSB ANC05CA099Accident · No injuriesData collectionFinal reportCessna 172 · Akiachak, AKThe pilot's delay in aborting the landing, which resulted in the airplane running off the end of the runway and nosing over. A factor associated with the accident was the rough/uneven terrain off the end of the runway.NTSB SEA05LA141Accident · No injuriesLimited investigationFinal reportCessna 206E · Stuart Island, WAThe pilot's excessive airspeed on final for the current runway surface conditions, and the intentional obstruction avoidance maneuver he executed when it became clear the aircraft was about to go off the end of the runway. Factors include the pilot's improper…NTSB IAD05LA088Accident · No injuriesLimited investigationFinal reportCessna T206H · Vineland, NJThe pilot's inadequate preflight planning, which resulted in his decision to land at a closed airport.NTSB NYC05LA092Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Wadsworth, OHThe flight instructor's failure to verify that the engine controls were completely retarded during an aborted takeoff, which resulted in a runway overrun.NTSB ANC05LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain control of the airplane, which resulted in a nose over during the landing roll. A factor contributing to the accident was uneven terrain.NTSB NYC05CA079Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's inadequate recovery from a bounced landing. A factor was the crosswind.NTSB ANC05CA067Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing roll, and a collision with willows and a creek bank. A factor associated with the accident was the soft landing area.NTSB ANC05LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Wasilla, AKThe pilot's selection of an unsuitable landing area, which resulted in a loss of control during the landing roll, and a collision with a ditch. A factor associated with the airplane was a leaking brake assembly and diminished braking efficiency.NTSB ANC05CA066Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground encounter with terrain during the landing roll, and subsequent nose down of the airplane. A factor associated with the accident was soft terrain.NTSB MIA05CA094Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Lakeland, FLThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control during landing resulting in the airplane departing the runway and colliding with a ditch.NTSB ANC05TA058Accident · Minor injuriesFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's selection of unsuitable terrain for taxi after landing, which resulted in the collapse of the main landing gear and structural damage to the right wing and forward fuselage. A factor associated with the accident was the rough and uneven terrain.NTSB ANC05CA059Accident · No injuriesData collectionFinal reportCessna U206E · Yakutat, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose down, and structural damage to the wing. A factor contributing to the accident was the soft sand.NTSB ANC05LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's selection of an unsuitable landing site, which resulted in a loss of control and the airplane nosing over during the landing roll.NTSB CHI05CA096Accident · No injuriesData collectionFinal reportChampion 7ECA · Mexico, MOThe pilot inadvertently using the wrong runway for takeoff, which resulted in a tailwind condition. Factors to the accident were the tailwind, the aborted takeoff, the wet grass runway, and the road embankment.NTSB MIA05CA082Accident · No injuriesData collectionFinal reportPiper PA-23-250 · West Palm Beach, FLThe failure of the pilot to maintain proper alignment with the runway, his failure to perform a go around after recognizing the aircraft was not properly aligned for landing, and his intentionally landing on a taxiway which resulted in a landing overrun and…NTSB LAX05CA111Accident · No injuriesData collectionFinal reportCessna 172A · Emigrant Gap, CAthe pilot's inadequate preflight planning and his selection of an unsuitable landing area, resulting in an encounter with a snow-covered runway.NTSB ATL05CA059Accident · No injuriesData collectionFinal reportEcker Starduster 1 · Millington, TNThe malfunction of the left main landing gear wheel brake during landing roll on a grassy area, resulting in a nose over.NTSB ANC05CA040Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Panama City, FLThe pilot's failure to remove frost from the airplane which resulted in an inadvertent stall/mush during the takeoff/initial climb, and an in-flight collision with trees. Contributing to the accident were the rough and uneven airstrip, and degraded aircraft…NTSB ANC05LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in ski assembly damage during the takeoff run from a frozen, snow-covered lake, and subsequent nose over during an emergency landing. Factors contributing to the accident were an overload…NTSB NYC05CA050Accident · No injuriesData collectionFinal reportCessna 152 · Kelleys Island, OHThe pilot's failure to maintain obstacle clearance during landing.NTSB ANC05CA024Accident · No injuriesData collectionFinal reportPiper PA-19 · Big Lake, AKThe pilot's selection of an unsuitable takeoff/landing/taxi area, which resulted in an on-ground encounter with a berm, a loss of control on the ground, and collapse of the main landing gear. Factors associated with the accident were flat light conditions,…NTSB SEA05LA036Accident · No injuriesLimited investigationFinal reportCessna U206F · Prevost, WAThe pilot not identifying unsafe landing conditions, and his subsequent intentional swerve during the landing roll resulting in impacting a ditch. Contributing factors were the ice/frost on the grass/dirt one-way runway (1,560 feet in length), the unexpected…