NTSB investigations, 2002
9 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\") = 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\" = 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") = 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" = 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 IAD03LA011Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Marietta, PAThe flight instructor 's misjudgment of the helicopter's height above the river.NTSB NYC02LA187Accident · No injuriesLimited investigationFinal reportBoeing 757-251 · Baltimore, MDThe captain's failure to follow existing company procedures for stabilized approach, and use of speed brakes.NTSB FTW02LA198Accident · No injuriesLimited investigationFinal reportAirbus Industrie A300-600F · El Paso, TXThe flight crew's failure to obtain the Vr speed prior to rotation which resulted in insufficient lift and the subsequent tail strike.NTSB ATL02LA106Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hernando, MSThe pilot's failure to maintain wing tip clearance during an attempted takeoff that resulted in the collision with the ground.NTSB FTW02LA156Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Frankston, TXthe pilot's failure to adequately compensate for wind conditions while landing on the water which resulted in a water loop/swerve. A contributing factor was a wind gust.NTSB CHI02LA124Accident · No injuriesLimited investigationFinal reportCessna 185F · Cumberland, WIthe failure of the pilot to maintain directional control after encountering high winds and gusty winds during taxi from landing.NTSB MIA02TA081Accident · No injuriesFinal reportBell OH-58C · Punta Gorda, FLDynamic rollover experienced by the pilot while attempting to lift off from a trailer after experiencing skid to trailer contact. A factor in the accident was the inadequate equipment (trailer) which had a 1.1875 inch high lip extending the length of the…NTSB ANC02LA015Accident · No injuriesLimited investigationFinal reportBoeing 727-100 · Kotzebue, AKThe pilot's decision to continue an unstabalized approach to landing. A factor associated with the accident is the pilot's failure to attain proper alignment with the runway.NTSB LAX02LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mammoth Lakes, CAThe onset of variable, gusty, crosswind conditions at the time of departure and the pilot's inadequate and improper compensation for the crosswind conditions.