NTSB investigations, 1991
22 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\") = 1991
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") = 1991 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 ATL92LA015Accident · No injuriesLimited investigationFinal reportBellanca 8JCAB · Morristown, TNThe pilot's failure to maintain a proper altitude during a low pass. A factor in this accident was the pilot's overconfidence in his personal ability.NTSB SEA91LA251Accident · No injuriesLimited investigationFinal reportBell BH-47-G3B1 · Rock Island, WAThe failure of the pilot to use the proper touchdown point while landing on a trailer.NTSB NYC91LA243Accident · No injuriesLimited investigationFinal reportLake LA-4 · Wilton, METhe pilot's improper recovery from a bounced landing on rough water which resulted in the right wing tip contacting the water causing the airplane to nose over and sink. Factors related to the accident were, the pilot's low time and experience in this type…NTSB LAX91LA392Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Reno, NVThe failure of the pilot to maintain an adequate clearance between the aircraft and the ground while maneuvering around a pylon, which resulted in a loss of control during landing.NTSB DEN91LA123Accident · No injuriesLimited investigationFinal reportCessna A185F · Conchas Dam, NMLanding gear locking mechanism loose, landing gear wheel deployed inadvertently, and maintenance alignment not performed. Factors were: propeller governor underspeed, maintenance adjustment not corrected, and lowering of flaps not performed.NTSB CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.NTSB ATL91LA163Accident · No injuriesLimited investigationFinal reportBell 47D1 · Winton, NCThe pilot's selection of unsuitable terrain for landing the helicopter.NTSB SEA91LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Genesee, IDThe pilot's failure to maintain alignment with the strip. Contributing to the accident was the glare of a bright horizon at dawn.NTSB ANC91LA109Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane on landing.NTSB NYC91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Eagle Lake, METhe pilot's misjudgment of his altitude during a landing on glassy water, which resulted in a loss of airplane control.NTSB CHI91DTG05Accident · No injuriesFinal reportCessna T188C · Bathgate, NDA loss of control inflight which resulted in a collision with the crop.NTSB NYC91LA225Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103B · Marion, OHThe pilot's improper decision to change landing runways with insufficient altitude and airspeed which resulted in a dragged wing and ground loop.NTSB CHI91DTK02Accident · No injuriesFinal reportCessna 188/B · Hecla, SDThe failure of the pilot to maintain aircraft control as he attempted to jettison a load of agricultural chemical after the airplane failed to climb after takeoff. Factors associated with the accident are an attempted downwind takeoff by the pilot.NTSB CHI91LA180Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNBecause of inadequate compensation for the wind conditions, aircraft control was lost by the pilot. A factor related to the accident was a gusty crosswind landing environment.NTSB ANC91LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Kenai, AKThe pilot's failure to maintain directional control. A factor was the gusty wind conditions.NTSB CHI91DEV01Accident · No injuriesFinal reportCessna A188B · Bluffs, ILThe pilot's failure to maintain directional control.NTSB MIA91LA145Accident · Serious injuriesLimited investigationFinal reportCorley Hubert KR-2 · Venice, FLThe pilot's improper use of flight controls.NTSB ATL91LA088Accident · 1 fatalLimited investigationFinal reportCessna 150J · Kure Beach, NCThe pilot's poor judgement, while impaired by alcohol, and his misjudgement of altitude/clearance above the water after initiating a low pass.NTSB CHI91LA131Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Grand Ledge, MIThe student's failure to maintain a proper altitude and clearance from the terrain along with the cfi's failure to adequately supervise the student's actions. A factor contributing to the accident was the inadequate visual lookout available due to the night…NTSB ANC91IA052Incident · No injuriesIncident investigationFinal reportPiper PA-32-301 · Eek, AKThe failure of the center torque link bolt.NTSB CHI91LA109Accident · No injuriesLimited investigationFinal reportCessna 172K · Bridgman, MIThe pilot's failure to correct a descent. A factor in the accident was the pilot's maneuvering at an improper altitude.NTSB ANC91IA028Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Unalaska, AKThe windshear encountered on short final. Contributing to the accident was the rising terrain within 150 feet of the runway, the variable nature of the wind due to the rising terrain, and the pilot's failure to maintain lateral control during the go around.