NTSB investigations, 1986
12 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\") = 1986
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") = 1986 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 MKC87LA032Accident · No injuriesLimited investigationFinal reportCessna 172P · Pine Bluff, ARThe pilot stated he had flown over trees from the southeast and descended to 50 ft. upon seeing trees in front of the acft he turned left, away from the trees. The left wing touched the ground followed by the nose gear. The acft then flipped forward to the…NTSB NYC87IA014Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Portland, METhe cp was flying the aircraft from the left seat while being observed by the PIC. The PIC was monitoring the approach, which was being made in IMC conditions and noted the aircraft drifting to the left, the cp started to make correction to the right at which…NTSB SEA86LA223Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Caldwell, IDDuring an aerial application flight, the plt entered a right turn during a 'border pass.' While in the right turn, the right wing struck the ground and the aircraft cartwheeled & crashed.NTSB SEA86LA162Accident · Minor injuriesLimited investigationFinal reportLazarini LONG-EZ · Jackpot, NVDuring takeoff at about rotation speed, the pilot diverted her attention to the right wing. The acft drifted to the edge of the runway and caught a wingtip, then nosed over.NTSB SEA86LA158Accident · 1 fatalLimited investigationFinal reportAyres S2RT34 · Jordan Valley, ORWitnesses observed at acft make a 2-5 foot pass over water going north, a 180 degree turn and a 2 foot AGL run to south. The acfts left main landing gear touched water bouncing the right wing on water. Acft pitched up, rolled inverted and crashed on south…NTSB FTW86LRG27Accident · No injuriesFinal reportAyres S2R-600 · Tivoli, TXOn June 27,1987 at approximately 1700 CDT, an Ayres S2R-600 impacted the terrain approximately 5 miles east of Tivoli, TX while conducting agriculture spraying operations. The right wing of the aircraft contacted the ground causing the aircraft to cartwheel…NTSB CHI86FET02Accident · 1 fatalFinal reportPiper PA-28-180 · Syracuse, INThe acft crashed into a lake while making a farewell low pass at friends on the lakeshore. He came over the lake toward his friends at such a low alt that he had to pull up to get over the trees. He commenced a steep rt turn which progressed into a descent…NTSB DEN86LA158Accident · No injuriesLimited investigationFinal reportBeaver Evans VP-1 · Glade Park, COThe plt said that during the take-off roll, high grass restricted the acft from attaining sufficient airspeed to achieve flt. According to the plt the acft struck a barbed wire fence, substantially damaging the acft.NTSB ATL86LA117Accident · No injuriesLimited investigationFinal reportBellanca 7-GCAA · Chester, SCAircraft was being repositioned on airport for glider tow. Tow rope was attached and pilot concentrated his attention on avoiding entangling tow rope on runway lights. When pilot noticed the aircraft was too low he attempted a go-around with insufficient…NTSB LAX86FVD07Accident · No injuriesFinal reportBell 47G-2 · Stockton, CAThe pilot was making a slow pass and dragged one spray boom on the ground. Insufficient airspeed resulted in loss of control. Helicopter crashed.NTSB MIA86LA074Accident · No injuriesLimited investigationFinal reportHughes 269C · Vero Beach, FLDuring auto-rotation practice, the CFI passed control of the helicopter to the student plt. At aprx 10 ft above the ground, the CFI attempted to apply corrective action when it became apparent that the acft was going to make a hard landing. The attempt was…NTSB MIA86LA068Accident · No injuriesLimited investigationFinal reportAerospatiale 350-B · Las Piedras, PRPilot stated that while flaring to enter a hover to reverse direction for takeoff the tail rotor guard struck the ground and separated. The helicopter was nosed over forward and as it was flared a second time the tail rotor struck the ground causing loss of…