NTSB investigations, 2002
9 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 16 |
| 1986 | 22 |
| 1987 | 21 |
| 1988 | 10 |
| 1989 | 14 |
| 1990 | 17 |
| 1991 | 15 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 15 |
| 2000 | 12 |
| 2001 | 7 |
| 2002 | 9 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 8 |
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\") = 2002
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\" = 330)
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") = 2002 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" = 330) 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 NYC03LA033Accident · No injuriesLimited investigationFinal reportMBB BK 117 A-4 · Albany, NYThe inadvertent encounter with a downdraft during engine start, which flexed the main rotor blades and subsequently damaged the tail boom assembly. A factor related to the accident was the failure of the operator to comply with a service bulletin.NTSB ANC02LA101Accident · No injuriesLimited investigationFinal reportHelio H-295 · Igiugig, AKThe pilot's inadequate evaluation of the wind/weather conditions resulting in a collision with an embankment during the takeoff run. A factor contributing to the accident was a sudden wind shift to a tailwind.NTSB FTW02LA200Accident · No injuriesLimited investigationFinal reportBell 206L3 · Gulf of MexicoThe pilot's failure to maintain proper rotor RPM during engine shutdown due to high wind conditions, which resulted in the main rotor blades contacting the tailboom. A contributing factor was the gusty wind conditions.NTSB DEN02LA059Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Deming, NMThe loss of aircraft directional control during the landing roll as a result of encountering a dust devil.NTSB ANC02LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's inadequate compensation for wind conditions, and the excessive use of the airplane's brakes, which resulted in a nose over. A contributing factor to the accident was a wind gust.NTSB ANC02TA045Accident · No injuriesFinal reportCessna 185 · Kaktovik, AKThe pilot's inadequate evaluation of the weather conditions during landing at a remote lake, resulting in a downwind landing. Factors contributing to the accident were the presence of a tailwind, and an icy lake surface.NTSB ANC02LA044Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's failure to compensate for a crosswind while taxiing, resulting in the right wing striking the water. A contributing factor in the accident was the presence of a crosswind.NTSB FTW02LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Dalhart, TXThe pilot's failure to maintain aircraft control. Contributing factors were the shifting gusty winds and the ditch.NTSB ANC02LA037Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot's inadequate compensation for a crosswind during the landing roll. A factor was the presence of a crosswind.