NTSB investigations, 1989
13 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\") = 1989
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") = 1989 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 CHI90DEE04Accident · No injuriesFinal reportCessna 172RG · Romeoville, ILDual student's inadequate compensation for wind conditions and remedial action not attained by the CFI. A factor related to the accident was: a snow bank adjacent the runway.NTSB CHI90LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · New Lenox, ILFailure of the pilot to attain wind information, which resulted in his selection of an unfavorable (wrong) runway. A factor related to the accident was: the crosswind condition.NTSB ATL89LA199Accident · No injuriesLimited investigationFinal reportHughes 269A · Saluda, SCStudent pilot's improper use of the flight controls during lift-off and inadequate supervision by the flight instructor.NTSB SEA89LA141Accident · Minor injuriesLimited investigationFinal reportKing Osprey II · West Linn, ORThe pilot did not properly recover from a bounced water landing.NTSB ANC89LA111Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. The crosswind and gusts were contributing factors.NTSB FTW89DRG08Accident · No injuriesFinal reportAir Tractor AT-301 · Rio Hondo, TXImproper compensation for wind conditions by the pilot. Factors related to the accident were the adverse wind conditions.NTSB DEN89LA140Accident · No injuriesLimited investigationFinal reportSchweizer 1-26E · Elbert, COThe pilot's improper inflight planning which placed the aircraft too FAR from the runway to complete a normal landing.NTSB SEA89LA097Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Boulder City, NVPoor judgement of the pilot by flying, while impaired from consumption of alcohol, and his delay in initiating a go-around when the aircraft drifted to the right of the runway. Related factors were: light conditions at dusk, unfavorable winds, and failure of…NTSB NYC89LA110Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Farmingdale, NYPilot's failure to control the altitude of the helicopter while demonstrating a quick stop maneuver to a student.NTSB MIA89LA092Accident · No injuriesLimited investigationFinal reportBell 47G · Oklawaha, FLPilot's failure to properly control the helicopter during an attempted landing on the back of a truck. Contributing to the accident was the pilot's lack of experience in performing similar landings.NTSB SEA89LA047Accident · No injuriesLimited investigationFinal reportCessna 180 · Wrangell, AKThe plt's failure to properly compensate for the wind during takeoff on unsuitable terrain. Contributing to the accident were the terrain conditions and gusting winds.NTSB SEA89LA043Accident · No injuriesLimited investigationFinal reportGulfstream 112TCA · Reno, NVThe failure of the pilot to maintain control of the airplane and the cfi's inadequate supervision of the pilot.NTSB SEA89LA033Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKImproper flare attitude at touchdown, causing the left float to dig into the water.