NTSB investigations, 1988
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\") = 1988
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") = 1988 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 FTW89DPA03Accident · Serious injuriesFinal reportBell 47-D1 · Allen, TXUnqualified pilot's poor judgement in leveling the helicopter during the flare and contributing to this was his lack of total experience in this type aircraft.NTSB MIA89IA012Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · St. ThomasThe rt wing was dragged while ldg in a crosswind on rwy 10. The crew stated the aprch was normal & the touchdown was smooth on the rt gear with 3 degrees to 5 degrees of rt bank. The capt stated that immed after touchdown, the lt wing came up suddenly and he…NTSB MIA89FA004Accident · No injuriesField investigationFinal reportHughes 269C · Vero Beach, FLThe plt stated that while doing a stuck left pedal maneuver, the helicopter was flown with a 5 degree yaw to the left. As the airspeed zeroed, the collective was brought in to bring the nose around and light contact was made with the ground. He then stated…NTSB FTW88LA159Accident · No injuriesLimited investigationFinal reportCessna 180H · Welsh, LAThe pilot was landing the tailwheel type airplane on runway 6 while the winds were from 270 degrees at 15 knots, gusting to 25 knots. After touchdown, it ballooned several feet, touched on the left wheel, then the left wing tip and flipped forward to the…NTSB SEA88LA133Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAOn the first leg of the scheduled float plane flight the plt had landed on lake union to embark addl pax. As the acft decelerated 'off the step,' a power boat converged on acft path. Plt made rudder input to avoid collision and wingtip contacted water.NTSB LAX88LA228Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Clearlake, CAThe pilot reported the airplane's right wing struck a swell during takeoff from a lake. The surface winds, however, were out of the southwest at 10 knots. The pilot had not flown within the preceding 24 calendar months. There were no reported airplane…NTSB DEN88LA132Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Moriarty, NMThe pvt glider plt was completing a five hr endurance flight. During the turn from base to final, the glider encountered a 15 kt xwind and overshot the turn. The plt attempted to 'buttonhook' back toward the intended touchdown point. Witnesses stated that…NTSB ATL88LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Myrtle Beach, SCThe plt was practicing touch and go ldgs on rwy 23 when he lost control of the airplane just after takeoff when it encountered a gust of wind. The rt wing contacted the terrain adjacent to the runway and the airplane flipped over.NTSB FTW88LA075Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355-F1 · Grand Prairie, TXThe acdt occurred on the 2nd flt of transition trng for an experienced helicopter plt. The trng on this flt included sim tail rotor failure run-on landings. The CFI demonstrated 2 landings and the trainee took the controls for the 3rd. The landings were being…