NTSB investigations, 1993
11 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\") = 1993
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") = 1993 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 ANC94LA016Accident · No injuriesLimited investigationFinal reportCessna A185F · Chefornak, AKThe failure of the pilot-in-command to adequately compensate for the gusty cross wind condition. A factor in the accident was the wind gust.NTSB FTW94LA020Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · San Antonio, TXThe pilot's failure to maintain a visual lookout. Factors were: inadequate altitude and distracted attention.NTSB SEA94LA010Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Marysville, WAThe student pilot's failure to maintain altitude.NTSB SEA94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orting, WAThe pilot in command's failure to maintain aircraft control.NTSB ANC93LA119Accident · No injuriesLimited investigationFinal reportTaylorcraft TC19 · Resurrect'N Bay, AKThe pilot-in-command's failure to maintain directional control upon landing.NTSB NYC93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wyantskill, NYInadequate supervision and delayed remedial action by the flight instructor. The student pilot's failure to maintain directional control and his inexperience is a contributing factor.NTSB NYC93LA114Accident · No injuriesLimited investigationFinal reportPitts S-2B · East Palestine, OHThe pilot's failure to maintain control of the aircraft. The pilot's improper compensation for the wind condition is a contributing factor.NTSB ANC93LA079Accident · No injuriesLimited investigationFinal reportCessna A185F · Kahiltna Glacie, AKThe pilot-in-command not maintaining directional control. A factor is the rough condition of the glacier airstrip.NTSB SEA93LA108Accident · No injuriesLimited investigationFinal reportGrove GR-2 · Buckley, WAThe pilot's premature liftoff. The pilot's failure to maintain directional control and the high vegetation beside the runway were factors.NTSB CHI93LA164Accident · No injuriesLimited investigationFinal reportGrumman TBM-3E · Spooner, WIThe pilot's failure to maintain directional control.NTSB CHI93LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · La Pointe, WISpatial disorientation of the pilot.