NTSB investigations, 1982
7 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\") = 1982
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") = 1982 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 NYC83LA031Accident · No injuriesLimited investigationFinal reportCessna 172RG · Middletown, PAAfter landing the tower directed the pilot to back taxi on the runway. After clearing the runway the pilot taxied straight ahead with proper control deflections for a 10 degree strong wind behind the left wing. A strong gusty wind was encountered causing the…NTSB DEN82DTK07Accident · Serious injuriesFinal reportRaven RX-7 · Phillip, SDAfter the fourth landing, the balloon had been on the ground about 8 minutes when a whirl wind suddenly hit the envelope. The balloon lifted up about 2 to 3 ft and was blown into the side of a chase vehicle. One of the passengers was thrown out of the…NTSB LAX82DA206Accident · No injuriesFinal reportCessna 172 · Mojave, CAWhile the pilot was boarding the aircraft, 2 linemen were holding the wings down. During taxi, the pilot was having difficulty controlling the aircraft. As the aircraft was turning to the runway heading, the wind raised the right wing, the spinning prop hit…NTSB DEN82DA043Accident · No injuriesFinal reportCessna 172 · Broomfield, COAfter landing the aircraft was taxiing to the ramp when a gust of wind lifted the left wing up and tipped the Cessna over on its back. Wind was gusting over 40 KTS.NTSB LAX82DA104Accident · Serious injuriesFinal reportCessna 172 · Las Vegas, NVWhile preparing to takeoff, the pilot was cautioned to beware of wake turbulence from a departing jet and was cleared into position to hold. Preceding the accident, the winds were reported to be from 230 deg gusting to 29 KTS. While turning to align with the…NTSB MIA82DA065Accident · No injuriesFinal reportCessna 152 · Opa Locka, FLWhile doing touch and go landings the pilot observed a squall line approaching the airport. He proceeded to make a full stop landing and was taxiing to operations, when a strong gust of wind picked up the tail of the aircraft and flipped it over. The pilot…NTSB MIA82DA040Accident · Minor injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot elected to land on runway 080 with winds from 170 degrees at 14 knots gusting to 25 knots. The aircraft ran off the side of the runway into soft sand where the nose wheel collapsed and the aircraft nosed over.