NTSB investigations, 1982
10 cases where the first occurrence was “Roll over”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 10 |
| 1984 | 11 |
| 1985 | 3 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 7 |
| 1989 | 3 |
| 1990 | 12 |
| 1991 | 3 |
| 1992 | 8 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 3 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 14 |
| 2002 | 8 |
| 2003 | 6 |
| 2004 | 8 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 9 |
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\") = 1982
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\" = 380)
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") = 1982 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" = 380) 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 FTW82DA381Accident · Minor injuriesFinal reportRobinson R-22 · Austin, TXDuring practice autorotation with power recovery student was late in applying power and aircraft touched down and rolled over. Instructor tried to recover but was also too late in application of remedial action.NTSB MKC83LA012Accident · No injuriesLimited investigationFinal reportCessna 150 · Nichols, IAThe pilot taxiied into a soft spot on his private airstrip which raised the wing. The wind got under the wing and flipped the aircraft over.NTSB LAX82FA343Accident · Serious injuriesField investigationFinal reportHughes 269C · North Highlands, CAThe purpose of the flight was to conduct a rotorcraft/helicopter certified flight instructor (CFI) check ride for the pilot-in-command (PIC). The check pilot was an FAA inspector with no previous flight time in this make and model; however, he had 1816 hrs…NTSB MIA82DA167Accident · Minor injuriesFinal reportBell 206B · Miami, FLThis was an instructional flight for recurrent training and involved an external load operation with a 10 ft line. While preparing to pick up an 800 lb load, the helicopter was maneuvered over the object with slack in the line. The instructor observed that…NTSB MIA82DA125Accident · No injuriesFinal reportBell 47J-2A · Marathon, FLThe pilot reported that an intermittent vibration was felt during the magneto check before takeoff. During a second magneto check at high power, the nose of the helicopter came up, a loud explosive noise was heard, and a fire erupted near the left fuel tank.…NTSB FTW82DA192Accident · Minor injuriesFinal reportRobinson R22 · Ada, OKThis was a commercial certification check flight for the pilot-in-command. After completing normal hovering maneuvers, the examiner instructed the pilot to execute a hovering autorotation over a level area of grass. The pilot rolled the throttle off on a…NTSB LAX82DA133Accident · No injuriesFinal reportRobinson R-22 · Mesa, AZAfter landing in a practice area the instructor told the student to pick the helicopter up to a hover. The aircraft lifted off the ground to approximately 5 feet and yawed to the right 45 degrees. As the instructor applied left pedal and lowered collective…NTSB ATL82DA091Accident · No injuriesFinal reportCessna 172 · Chantilly, VAThe pilot flew into an area of high forecast winds and altered his destination as a precaution. However, he failed to ask for or take precautionary measures after landing and the aircraft was blown over while taxiing.NTSB SEA82DA077Accident · No injuriesFinal reportRobinson R-22 · Hillsboro, ORThe instructor pilot was demonstrating a hovering autorotation to the student from approximately an 18 inch altitude. Shortly after touchdown, which was level and without movement in any direction, the aircraft started to roll to the left. The pilot reported…NTSB FTW82DA073Accident · No injuriesFinal reportBell 47G · Dallas, TXThe pilot attempted to land on a narrow flatbed trailer. He stated that he encountered some buffeting from the wind funneling between two hangars. On his third attempt to position the helicopter on the trailer, the right skid slipped off. The main rotor…