NTSB investigations, 1983
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\") = 1983
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") = 1983 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 ATL83LA370Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Berry, ALThe acft dragged a wing during takeoff and collapsed the right main gear in the process. After liftoff the plt said the left wing dipped and contacted soybeans at the end of the rwy. He said he overcontrolled and rolled the right wing into the beans. He…NTSB LAX83LA380Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Jean, NVThe plt took off from the mccarran intl arpt, las vegas, NV & flew to another arpt in the local area at Jean, NV to practice soft field takeoff & landing techniques. During his 1st soft field takeoff, he over rotated the acft & the tail cone contacted the…NTSB SEA83LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Klamath Falls, ORThe acft dragged a wing in a lake and cartwheeled during an aerial application maneuver. The pilot said he had turned away from the field he was spraying to remove the bugs from his windshield. The acfts wing struck a lake surface in the turn, cartwheeled and…NTSB ANC83FA090Accident · No injuriesField investigationFinal reportCessna 185-E · Anchorage, AKThe acft was damaged in a forced landing after a loss of power in cruise flt. The pilot said he checked the throttle position then advanced it with no reaction. The pilot declared an emergency on frequency 121.5 the emergency fuel pump was turned on but…NTSB DEN83FTE10Accident · No injuriesFinal reportDouglas DC-3C · Englewood, COThe acft dragged a wing during landing touchdown in IMC weather conditions. The pilot had broken out misaligned with therwy. As the airspeed decayed during the transition from IFR to VFR the co-pilot took control because he thought he couldsee the rwy better.…NTSB SEA83LA109Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-29D · Ephrata, WAThe plt reported that he was forced to land after thermal activity subsided and he was unable to find an area of lift. He elected to land in the last cultivated field before reaching an area of sage brush. Reportedly, a dust devil was encountered during…NTSB FTW83LA211Accident · No injuriesLimited investigationFinal reportHughes 269B · Forgan, OKThe helicopter hooked a skid and rolled over while trying to land on a trailer. The plt stated that after surveying someproperty he landed next to the trailer used for transporting the acft. He then lifted off and while hovering over the trailer a skid hooked…NTSB ANC83IA069Incident · No injuriesIncident investigationFinal reportCessna U-206 · Old Harbor, AKThe acft rt wing rose during the water takeoff & the left wing struck the water. After impact the aircraft sank. The pilot did not receive a weather briefing & a sigment for lowlevel turbulence was in effect.NTSB FTW83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Mountain Park, OKThe pilot stated that he was taking off to the north on a highway for a crop spraying operation. The aircraft was loaded with 720 pounds of chemical and 36 gal of fuel. He perceived a breeze from the south but took off north because of a hill to the south.…NTSB CHI83LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WIThe student plt was on a supervised, solo, x-country flt from mosinee, WI, to Oshkosh, WI, green bay, WI, then return to mosinee. The first leg of the flight was flown with no problem. Before takeoff at oshkosk, the student was taxiing southbound with a left…NTSB CHI83LA098Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Warsaw, INThe plt reported that during arrival, he contacted UNICOM for an advisory. Reportedly, the wind at that time was from 090 deg at 15 KTS, within the x-wind capability of the acft. During the approach and landing, the plt slipped the plane to a normal…