NTSB investigations, 2007
39 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\") = 2007
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") = 2007 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 CHI08CA058Accident · No injuriesData collectionFinal reportCessna 172F · Crystal Falls, MIThe rough, unsuitable terrain encountered during the landing which resulted in the total failure of the nose landing gear.NTSB ANC08LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's selection of unsuitable terrain for taxi. Contributing to the accident were rough and uneven terrain, and an excessive taxispeed.NTSB DFW08CA048Accident · Minor injuriesData collectionFinal reportPortman RV-7A · ELmendorf, TXThe failure of the nose landing gear. A contributing factor was the mound/uneven runway surface.NTSB DFW08CA047Accident · No injuriesData collectionFinal reportCessna 210 · Medford, OKThe pilot's decision to attempt a night landing without runway lighting. A contributing factor was inoperative runway lights.NTSB ANC08CA024Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Seward, AKThe pilot's failure to maintain directional control during takeoff.NTSB NYC08CA040Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNThe flight instructor's inadequate remedial action and failure to maintain runway alignment.NTSB ANC08CA019Accident · No injuriesClass 4 · Data collectionFinal reportAmerican Champion 8GCBC · Wasilla, AKThe pilot's misjudged touchdown point during landing.NTSB DEN08CA026Accident · No injuriesData collectionFinal reportCessna 140 · Poultney, VTThe pilot's attempt to land on an unimproved airstrip resulting in a ground loop/swerve. Factors contributing to the accident were the pilot's poor judgement in attempting to land on an unsuitable runway and the unsuitable runway conditions.NTSB SEA08CA018Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot's failure to maintain clearance from a ditch while taxiing. Contributing factors were the pilot's inadequate visual lookout and the ditch.NTSB ANC08CA008Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe pilot's selection of an unsuitable landing area which resulted in an on ground encounter with terrain, and a nose over.NTSB DFW08CA009Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Columbia, LAThe pilot's selection of an unsuitable landing area. Contributing factors were the tall vegetation on the sides of the airstrip and the short and confined landing area.NTSB ANC08TA006Accident · No injuriesFinal reportAviat A1B · Palmer, AKThe flight instructor's failure to maintain clearance from high vegetation during the off-airport landing.NTSB CHI07CA306Accident · No injuriesData collectionFinal reportPiper PA-12 · Detroit Lakes, MNThe reduced airplane climb performance capability resulting in the pilot not obtaining a proper climb rate during takeoff and the inadequate flare by the pilot during the aborted takeoff. Additional causes were the inadequate preflight planning/preparation by…NTSB ANC07CA107Accident · No injuriesData collectionFinal reportPiper J3 · Tyonek, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an encounter with soft terrain and a loss of control during the takeoff roll.NTSB ANC07CA105Accident · No injuriesData collectionFinal reportPiper PA-32 · Chenega Bay, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch during the landing roll. A factor associated with the accident was the ditch.NTSB ANC07LA095Accident · No injuriesLimited investigationFinal reportShort Bros. SC-7 · McGrath, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose gear collapse during the landing roll. Contributing to the accident was the soft terrain.NTSB ANC07LA090Accident · No injuriesLimited investigationFinal reportCessna 150G · Kenai, AKThe pilot's excessive flap setting during takeoff.NTSB MIA07CA134Accident · Minor injuriesData collectionFinal reportCessna 152 · Labelle, FLThe student pilot's attempted precautionary landing on unsuitable terrain which resulted in damage to the airplane during the landing.NTSB ANC07CA087Accident · No injuriesData collectionFinal reportMaule M7 · Bettles, AKThe pilot's selection of an unsuitable landing site, which resulted in an encounter with soft terrain, and a nose over during the landing roll.NTSB SEA07CA235Accident · No injuriesData collectionFinal reportCessna 172B · Seattle, WAThe private pilot's failure to see the approaching large wake swell, both during his landing and the subsequent takeoff, and the failure of the instructor pilot to insure that the private pilot's visual lookout was effective enough to detect the oncoming…NTSB CHI07CA265Accident · No injuriesData collectionFinal reportMooney M20-C · Hicksville, OHThe pilot failed to execute a go-around.NTSB NYC07LA191Accident · No injuriesLimited investigationFinal reportBass RV-6A · Harrisonburg, VAThe limited fork-to-ground clearance provided by the nose gear design. Contributing to the accident was the uneven turf/dirt surface of the runway.NTSB ATL07LA110Accident · 1 fatalLimited investigationFinal reportCessna T206H · Lovell, METhe pilot's failure to retract the amphibious floatplane's landing gear during a water landing.NTSB DFW07CA174Accident · No injuriesData collectionFinal reportCessna A188B · Garwood, TXThe pilot's failure to maintain proper clearance from terrain/obstacles. A contributing factor was the runway conditions.NTSB ANC07LA064Accident · No injuriesLimited investigationFinal reportChampion 7GCB · King Salmon, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in the right main landing gear collapsing during takeoff. Factors contributing to the accident were rough/uneven terrain, and the collapse of the main landing gear.NTSB SEA07CA180Accident · No injuriesData collectionFinal reportRobinson R22 · Tucson, AZThe certified flight instructor's inadequate supervision of the practice autorotation. Contributing factors included the terrain drop off and the failure of the pilot undergoing instruction to maintain adequate rotor rpm.NTSB ATL07CA098Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Coats, NCThe CFI's failure to maintain a visual look out while taxiing resulting in an on ground collision with a hole on the grass runway and collapse of the right main landing gear.NTSB ANC07CA049Accident · No injuriesData collectionFinal reportBritten-Norman BN2A26 · Egegik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage during the landing roll when the airplane encountered soft sand.NTSB SEA07CA168Accident · No injuriesData collectionFinal reportCessna 172D · Halls Crossing, UTThe pilot's failure to select suitable terrain for landing. A contributing factor was the rough/uneven terrain.NTSB SEA07CA150Accident · No injuriesData collectionFinal reportCessna 182P · Aurora, ORThe pilot's misjudged flare during landing, and his improper recovery from a bounced landing, resulting in collision with the runway.NTSB SEA07LA131Accident · No injuriesLimited investigationFinal reportCessna 150M · Spanish Fork, UTThe student pilot's inadequate compensation for gusty crosswind conditions, and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds, and a ditch near the runway environment.NTSB DFW07LA111Accident · Minor injuriesLimited investigationFinal reportBell 206B · Horseshoe Bay, TXThe pilot's loss of control as result of dynamic rollover while attempting to takeoff. Facrots were the landing skid becoming snagged and the soft terrain.NTSB DFW07CA104Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Benoit, MSThe pilot's failure to maintain clearance with the crops which resulted in a ground loop. A contributing factor was the narrow airstripNTSB SEA07CA116Accident · No injuriesData collectionFinal reportCessna 172M · Astoria, ORThe student pilot's failure to adequately correct for changing wind conditions, leading to a loss of directional control during the takeoff ground roll. Factors include wet, soft terrain along the side of the runway.NTSB ANC07CA024Accident · No injuriesData collectionFinal reportCessna 177 · Gridwood, AKThe pilot's selection of a snow-covered runway for landing, which resulted in a quick stop and damage to the airplane. A factor associated with the accident was the snow-covered runway.NTSB NYC07CA069Accident · No injuriesData collectionFinal reportCessna 172 · Utica, NYThe pilot's failure to maintain directional control of the airplane, during an aborted takeoff, which resulted in a collision with a snowbank.NTSB DEN07CA057Accident · No injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Craig, COThe pilot's improper in-flight planning and unsuitable area selected for landing. A contributing factor was the snow covered terrain and runway.NTSB ANC07LA014Accident · No injuriesLimited investigationFinal reportCessna 207 · Kipnuk, AKThe pilot's failure to maintain adequate clearance from terrain during the landing roll, which resulted in a collision with a snow berm with the left main landing gear, and subsequent damage to the right wing. Factors contributing to the accident were dark…NTSB CHI07CA055Accident · No injuriesData collectionFinal reportCessna 150M · Bristol, WIThe pilot's selection of unsuitable terrain to taxi on for takeoff. A factor was the soft terrain condition.