NTSB investigations, 1994
15 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\") = 1994
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") = 1994 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 FTW95LA055Accident · No injuriesLimited investigationFinal reportBoeing 757-24APF · Tulsa, OKThe pilot's failure to maintain vref during approach and his improper flare touchdown that resulted in an excessive pitch up attitude following touchdown.NTSB NYC95LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Center Harbor, NHThe pilot's inadequate compensation for a crosswind condition.NTSB MIA94LA208Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Deland, FLThe pilot in command's failure to maintain ground clearance while maneuvering over the runway threshold resulting in the left wing contacting the ground.NTSB LAX94LA345Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Agua Dulce, CAthe pilot's failure to maintain control of the aircraft while reaching cross cockpit for the flap control.NTSB ANC94LA126Accident · No injuriesLimited investigationFinal reportCessna 208 · Cape Sabine, AKThe pilot's improper preflight planning, inadequate compensation for the wind conditions, not following procedures and directives, and overconfidence in his abilities, and the operators inadequate surveillance of the operation.NTSB CHI94LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Butte Des Mort, WIA delayed remedial action by the instructor. A factor in this accident was a proper airspeed not being attained by the dual student.NTSB LAX94FA292Accident · 1 fatalField investigationFinal reportCessna 414 · Taft, CAThe pilot's inadequate preflight planning/preparation and selection of the wrong runway for takeoff. Factors related to the accident were: the uphill slope of the runway, tailwind, high density altitude, and failure of the pilot to correctly configure the…NTSB NYC94LA127Accident · Minor injuriesLimited investigationFinal reportHawk RUL-1 · Lucasville, OHThe pilot's improper use of flight controls during the landing flare. A factor related to the accident was the pilot's lack of recent flight experience in this type airplane.NTSB ANC94LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe pilot's inadequate compensation for the wind condition. A factor in the accident was the gusty wind condition.NTSB CHI94LA217Accident · Minor injuriesLimited investigationFinal reportHunsberger Glasair · Lapeer, MIthe pilot's failure to maintain aircraft handling. A factor related to the accident was the gusty wind conditions.NTSB SEA94LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prineville, ORThe pilot's inadequate compensation for wind conditions. A factor was gusty wind conditions.NTSB CHI94LA195Accident · 1 fatalLimited investigationFinal reportCanadair T-33 · Mount Clemens, MIThe pilot's failure to maintain clearance from terrain during an aerobatic maneuver. His improper execution of the maneuver was a factor.NTSB ANC94LA067Accident · No injuriesLimited investigationFinal reportCessna 185 · Kassan Bay, AKThe pilot's inadequate compensation for the wind. Factors were the rough water and the gusty wind condition.NTSB LAX94LA231Accident · 1 fatalLimited investigationFinal reportCessna 172N · Roosevelt, AZthe pilot's selection of an inadequate terrain clearance altitude while maneuvering over a lake. A factor in the accident was the calm glassy water conditions which may have affected the pilot's perception of his actual height above the water.NTSB MIA94LA102Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Key West, FLThe failure of the pilot-in-command to ensure the aircraft was at an adequate altitude above the water before initiating a turn which resulted in the right float contacting the water during the turn and the aircraft cartwheeling.