NTSB investigations, 2001
35 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\") = 2001
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") = 2001 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 FTW02LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Ardmore, OKthe flight instructor's selection of an unsuitable area for practicing a full touchdown autorotation, which resulted in a nose over. A contributing factor was the soft ground.NTSB CHI02LA040Accident · Minor injuriesLimited investigationFinal reportLyon Horizon 1 · Richland, MOThe pilot not attaining altitude/clearance from the tree line during the aborted landing. Factors to the accident were the pilot selecting to operate the airplane on the rough/uneven runway, the pilot's lack of total experience in the airplane, and the tree…NTSB FTW02LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Galveston, TXthe pilot's failure to set the parking brake before exiting the aircraft to remove the wheel chocks.NTSB MIA02LA013Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Athens, GAthe pilot misjudged the ailment of the airplane on the active runway, inadvertently taking off from a parallel taxiway, and subsequently departing the hard surface into a 40 foot drop off. A factor in this accident was a dark night, and the pilot's total…NTSB SEA02LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Sulfur Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include the pilot's excessive rotation attitude, and soft/wet terrain conditions.NTSB ANC01LA152Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Arctic Village, AKThe pilot's selection of unsuitable terrain for takeoff. A factor in the accident was rock(s)/boulders in the area of takeoff.NTSB FTW01LA190Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Odom, ARthe pilot's failure to follow the proper procedures for hand-propping an airplane.NTSB NYC01LA213Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Davidsville, PAThe pilot's failure to abort the takeoff attempt. Factors included the pilot's failure to use both magnetos, and his failure to utilize soft field takeoff procedures.NTSB ANC01LA115Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Palmer, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.NTSB ANC01LA107Accident · No injuriesLimited investigationFinal reportCessna 180H · Big Lake, AKThe pilot's selection of an unsuitable area for takeoff.NTSB ANC01LA104Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of an unsuitable area for an off-airport landing.NTSB ANC01LA096Accident · No injuriesLimited investigationFinal reportCessna U206 · Yakutat, AKThe pilot's failure to maintain clearance from high vegetation during the takeoff roll.NTSB ANC01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Haines, AKThe pilot's failure to maintain directional control during the takeoff roll. Factors associated with the accident are the pilot's selection of unsuitable terrain for takeoff, and a rough/uneven takeoff area.NTSB CHI01LA207Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Ionia, MIThe pilot not maintaining clearance from the tall grass during his recovery from the bounced landing. A factor was the tall grass.NTSB LAX01LA242Accident · No injuriesLimited investigationFinal reportCessna 310I · Amargosa Valley, NVThe pilot's attempt to depart on a taxiway unsuitable for takeoff under existing conditions. An additional factor was a berm at the end of the taxiway.NTSB ATL01LA078Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-3 · Titusville, FLThe pilot's failure to maintain directional control during a bounced landing, resulting in a ground loop and subesequent collision with the runway.NTSB SEA01LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fragaria, WAThe pilot's failure to maintain adequate directional control. Contributing factors were the embankment and the deer.NTSB ATL01LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Cedar Key, FLThe pilot's improper in-flight decision to abort the landing resulted in the collision with water. A factor was the variable wind condition.NTSB IAD01LA072Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Berlin, MDpilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB MIA01LA173Accident · No injuriesLimited investigationFinal reportBeech 77 · Rock Hill, SCThe poor weather evaluation by the pilot for landing with a tailwind and failure of the pilot to perform a go-around after the first bounced landing.NTSB ANC01LA072Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Petersburg, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was soft terrain.NTSB ANC01LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Haines, AKThe pilot's selection of unsuitable terrain for takeoff. Factors in the accident were soft terrain, and the pilot's delay in aborting the takeoff.NTSB ANC01LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Egegik, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were a soft area of runway, and sunglare.NTSB SEA01LA107Accident · No injuriesLimited investigationFinal reportHerriford RAF 2000 · Gardiner, MTthe pilot's failure to rotate the aircraft until he was well past the normal takeoff rotation speed, and his abrupt rotation at this higher speed.NTSB ANC01LA060Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Alexander, AKThe instructor pilot's inadequate supervision of the flight. Factors in the accident were the dual student's selection of unsuitable terrain for landing, and the presence of a sand bar in the landing area.NTSB SEA01LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Rogersburg, WAThe pilot's failure to maintain aircraft control while on final approach for landing. A tailwind was a factor.NTSB SEA01LA096Accident · No injuriesLimited investigationFinal reportCessna 180A · Mercer Island, WAthe pilot's inadequate visual lookout during an approach and landing in open water. Factors include a large wave/swell at the location where the pilot elected to land his float-equipped airplane.NTSB ATL01LA051Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ball Ground, GAThe student pilot's failure to maintain directional control during landing roll. A factor is the ditch.NTSB NYC01LA111Accident · Minor injuriesLimited investigationFinal reportKnab-Douglas Jurca MJ5 Sirocco · G. Barrington, MAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun. A factor in this accident was the gusty wind condition.NTSB ANC01LA059Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's selection of an unsuitable area for taxi. A factor associated with the accident was a rough/uneven taxiway.NTSB ANC01LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Cantwell, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose over during the landing flare. Factors in the accident were soft, snow-covered terrain on the runway.NTSB ANC01LA045Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Palmer, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.NTSB ANC01LA052Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was uneven terrain.NTSB CHI01LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sunfield, MIThe pilot's inadequate preflight preparation and the unsuitable terrain for takeoff encountered. Factors included the slushy runway and the snowbank.NTSB IAD01LA023Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJthe pilot's failure to maintain proper runway alignment during landing. Factors in the accident were the night lighting and the snow bank.