NTSB investigations, 1995
21 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\") = 1995
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") = 1995 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 LAX96LA100Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Folsom Lake, CAthe flight instructor's inadequate supervision of the dual student and improper remedial action. A factor relating to the accident was: failure of the student pilot to maintain directional control.NTSB ATL96LA023Accident · No injuriesLimited investigationFinal reportHiller 12C · N. Myrtle Beach, SCThe pilot's improper operation of the flight controls during a practice autorotation, and the certified flight instructor's inadequate supervision of the operationNTSB MIA96IA039Incident · No injuriesIncident investigationFinal reportBoeing 747-212B · Amsterdam, NetherlandsThe failure of the captain to maintain a level wings attitude during a go-around resulting in the right wing dragging on the ground.NTSB SEA96IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Boise, IDthe pilot-in-command's misjudgment of the remedial action necessary to correct the aircraft's misalignment with the runway. The dark night conditions, fog, and the pilot-in-command's failure to maintain proper alignment with the runway were factors.NTSB LAX96LA053Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Fresno, CAfailure of the pilot to maintain proper control of the helicopter, while in a hover.NTSB LAX96LA034Accident · No injuriesLimited investigationFinal reportCessna 310C · Boulder City, NVthe pilot's improper aircraft handling during touchdown which resulted in the right wing and horizontal stabilizer dragging on the runway. The poorly planned landing approach was a factor.NTSB CHI95LA276Accident · No injuriesLimited investigationFinal reportCessna A185E · Dickinson, NDthe pilot's inadequate compensation for the wind conditions, and his improper recovery from the bounced landing. The high wind was a factor.NTSB ANC95LA138Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Togiak, AKThe pilot's inadequate compensation for wind conditions and failure to maintain proper alignment with the intended point of landing. A factor relating to the accident was: the unfavorable wind condition.NTSB CHI95LA233Accident · No injuriesLimited investigationFinal reportCessna 172 · Motley, MNthe pilot's failure to maintain control of the airplane during a soft field takeoff.NTSB LAX95LA242Accident · No injuriesLimited investigationFinal reportMiller, Terry W. Tern · Adelanto, CAthe pilot's inadequate compensation for the existing wind conditions.NTSB ANC95LA085Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta Junction, AKThe pilot's improper compensation for the wind conditions which resulted in dragging the right wing and shearing off the nose gear.NTSB CHI95LA199Accident · No injuriesLimited investigationFinal reportCessna 310L · Crawfordsville, INthe pilot's failure to maintain adequate airspeed during final approach to landing. A factor in the accident was the pilot's delayed action of aborting the landing.NTSB ANC95LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Gulkana, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC95LA084Accident · No injuriesLimited investigationFinal reportLockheed L-382E · Mcgrath, AKFailure of the pilot-in-command to assure the airplane was adequately flared for landing.NTSB ANC95LA051Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's inadvertent water loop/swerve due to the use of improper landing procedures.NTSB MIA95LA125Accident · No injuriesLimited investigationFinal reportFabre Searay Bombadier · Orlando, FLThe abrupt use of the flight controls,by the pilot-in-command while taxiing on water that resulted in the airplane capsizing.NTSB BFO95LA049Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Mount Sterling, KYthe pilot's failure to maintain aircraft control during landing. The gusty, crosswind condition and the pilot's inadequate compensation for the wind condition were factors.NTSB ANC95LA045Accident · No injuriesLimited investigationFinal reportPiper PA-20-125 · Koliganek, AKThe student pilot's inadequate compensation for the wind conditions. A factor in the accident is a crosswind.NTSB FTW95LA144Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Edgewood, NMThe flight's encounter with a downdraft. The lack of a suitable landing area was a factor.NTSB CHI95LA103Accident · No injuriesLimited investigationFinal reportCessna 172H · Atkinson, NEThe pilot's failure to adequately compensate for the gusty crosswind. The wind was a factor.NTSB FTW95LA172Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Elk City, OKThe pilot's failure to maintain proper altitude during a hovering turn. A factor was the low temperature.