NTSB investigations, 1982
5 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 19 |
| 1985 | 16 |
| 1986 | 12 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 13 |
| 1990 | 7 |
| 1991 | 22 |
| 1992 | 9 |
| 1993 | 11 |
| 1994 | 15 |
| 1995 | 21 |
| 1996 | 10 |
| 1997 | 9 |
| 1998 | 14 |
| 1999 | 9 |
| 2000 | 10 |
| 2001 | 10 |
| 2002 | 9 |
| 2003 | 9 |
| 2004 | 9 |
| 2005 | 11 |
| 2006 | 5 |
| 2007 | 7 |
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\" = 160)
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" = 160) 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 FTW83IA086Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Memphis, TNDuring a go-around from an ILS approach, the left wing tip was dragged. This resulted in minor damage to the leading edge slats, trailing edge flaps and outboard flap track housing on the left wing. An uneventful landing was made after the go-around. The…NTSB ANC82DA085Accident · No injuriesFinal reportBellanca 7GCBC · Mt. Range, AKDownhill takeoff into gusty crosswind raised wing which pilot could not control with aileron. Wing dragged and aircraft nosed over after 200 foot roll.NTSB SEA82DA133Accident · No injuriesFinal reportCessna A185F · Friday Harbor, WAThe plt reported that while he was making a water landing, everything was normal until after touchdown. As the acft decelerated "off the step," the right float rose off the water as if it road over a swell or encountered an object. When the float contacted…NTSB CHI82DA254Accident · No injuriesFinal reportBeech C35 · Hamilton, OHDuring arrival, the pilot observed a thunderstorm just southof the airport with visible lighting. As the pilot continued his approach to runway 29, he noticed that the wind gusts had picked up. During the flare, a gust lifted his left wing and the right wing…NTSB CHI82DA159Accident · No injuriesFinal reportLake LA-4 · Dowagiac, MIThe pilot stated that while turning the aircraft during taxi to the shore the aircraft ran into the wake of a boat and skipped sideways. When the aircraft encountered a second wave the right wing struck the water shearing off the sponson and bending the wing.