NTSB investigations, 1985
16 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
Latest 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\") = 1985
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") = 1985 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 FTW86LRG08Accident · No injuriesFinal reportRobinson R-22HP · Pflugerville, TXThe helicopter rolled over when the right skid contacted the ground during a hover. The plt stated he had landed to and opened the door to check the skid position. After takeoff while in a hover at 2 ft AGL, the door popped open. The right skid contacted the…NTSB NYC86LA005Accident · No injuriesLimited investigationFinal reportBeech BE-99 · Albany, NYA Beech BE-99 N336PL experienced a landing gear collapse while landing on runway 01 at Albany county airport and was substantially damaged. On initial approach to the airport the gear selector was put in the down position, only two green gear lights were…NTSB CHI86LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Troy, MIThe plt landed on rwy 27 with winds from 185 degs at 20 KTS gusting to 30 KTS. The acft ballooned on short final. The plt added pwr but the right wing dropped and hit the rwy. The acft cartwheeled.NTSB MKC85LA219Accident · No injuriesLimited investigationFinal reportCessna A185F · Lincoln, NEShortly after takeoff in an acft with amphibious landing gear. The plt cancelled his flt plan and had the twr check the landing gear. He then made a precautionary landing in a lake with the wheels retracted. One wheel was not fully retracted at touchdown and…NTSB FTW85LA342Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Port Sulphur, LAThe plt stated he initiated his water takeoff run on a canal which had a left bend. When he rounded the bend he observed a 15-20 foot high piling (post) in the middle of the canal and a peninsula of land about 300 yards beyond the piling. He steered to the…NTSB ATL85LA267Accident · No injuriesLimited investigationFinal reportBryan HP-14 · Aiken, SCPlt reported that sailplane was positioned for a tow in tall grass beside the rwy. He said that during the takeoff the left wing was slowed by the tall grass allowing the right wing to accelerate. The sailplane yawed left and rolled left until 90 degrees to…NTSB ANC85LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Drift River, AKApln crashed on gravel bar after wing tip hit ground during low alt turn. The unlicesed plt stated that he WA s in his second 360 deg turn & hit his own wake turbulence.NTSB SEA85LA183Accident · No injuriesLimited investigationFinal reportCessna T-188C · Pasco, WAThe pilot elected to depart an 1800 foot gravel airstrip with a 90 degrdd f temperature. The density altitude was about 3100 feet. The aircraft was heavily loaded, approaching gross weight. The pilot made the decision during the last 1/3 of the runway to…NTSB LAX85FUG04Accident · Serious injuriesFinal reportBriegleb Amature Built BG-12-BD · Hemet, CAIn was reported that Mr. Campbell departed perris airport, perris, CA at approximately 1215 PDT. It is unknown in what area he was flying. Mr. Campbell was sighted a few minutes prior to attempting to land in a field near 36875 menlo street, Hemet, CA. A…NTSB ANC85LA091Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai Lake, AKThe plt stated that the float struck the water during landing resulting in the acft nosing over and sinking in 25 ft of water.NTSB ANC85LA087Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Chugiak, AKWhile landing with a gusty x-wind, the acft bounced, the left wing dragged the ground & the acft went off the rwy. The plt stated that due to the x-wind & his foot slipping off of the rudder pedal, he was unable to maintain directional control.NTSB FTW85FA211Accident · 1 fatalField investigationFinal reportCessna 310H · Avinger, TXThe pilot stated he was flying low over the lake surface. He felt a decelaration to the right and the next thing he was in the water. Witnesses saw the aircraft over the lake at a low altitude and saw the right wing impact the water and cartwheel to the right…NTSB MIA85LA167Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Winter Haven, FLA Schempp-Hirth ventus b, N40EE, was positioned on rwy 29 to be towed on a competition glider flt. The plt reported that before starting his takeoff, the tow plane was positioned to the left of the glider. The wind was from 030 deg at 8 KTS. As the takeoff…NTSB FTW85LA189Accident · No injuriesLimited investigationFinal reportCessna A185F · Slidell, LAThe plt reported that during a water landing, the left float dragged, but he was able to 'pull it out' & started to add power to go around. However, he saw power lines ahead & realized that a go-around was not possible. He said he 'planted it back on the…NTSB BFO85IA036Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCWhile on final for runway 36 at Washington national airport, Washington, d.c., the pilot was given a change of lndg rwys because of traffic on rwy 36. Drng the ensuing realignment the cpt took the ctls and lndg the acft, scraping the right wing on the runway.…NTSB LAX85LA104Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Van Nuys, CAThis was the initial test flt after installation of rebuilt wings. On the takeoff roll, the acft began drifting to the right & the plt corrected with left aileron. He stated that the acft 'whipped violently further to right, caught a wing tip & ground…