NTSB investigations, 1996
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\") = 1996
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") = 1996 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 IAD97LA037Accident · No injuriesLimited investigationFinal reportRobinson R22 HP · Islip, NYThe students pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight.NTSB SEA97LA020Accident · Minor injuriesLimited investigationFinal reportKarmy Rotorway Exec · Redmond, ORThe pilot's failure to remove the dolly wheels during the preflight inspection.NTSB LAX97LA021Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Mesa, AZthe selection of an unsuitable landing area by the flight instructor (CFI). Factors relating to the accident were: soft/wet terrain in the selected landing area, and the crosswind condition.NTSB FTW97LA001Accident · Serious injuriesLimited investigationFinal reportContinental Copters EL Tomcat MK-5A · Lafayette, LAthe pilot's failure to ensure a proper preflight and the groundcrew's failure to remove the tiedown. Factors were pilot and groundcrew fatigue.NTSB LAX96LA346Accident · No injuriesLimited investigationFinal reportBell 206B · Fillmore, CAthe flight instructor's inadequate supervision and delay in taking remedial action to stop the aircraft's lateral movement, which resulted in a dynamic rollover after touchdown.NTSB MIA96LA191Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH1100 · Lutz, FLthe pilot's improper use of the flight controls (collective and cyclic), while conducting a ground run, resulting in a roll over.NTSB FTW96LA244Accident · No injuriesLimited investigationFinal reportHughes 269 · Dallas, TXThe student pilot's encounter with dynamic rollover while hovering. Factors were the prevailing high winds and the inadequate supervision provided by the flight instructor.NTSB CHI96LA151Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Big Lake, MNthe pilot's inadequate preflight of the helicopter by not having removed a tiedown strap before attempting takeoff.NTSB FTW96LA192Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKthe student's inadvertent dynamic rollover, and inadequate supervision by the flight instructor.NTSB SEA96TA050Accident · No injuriesFinal reportBell 206B · Kemmerer, WYthe selection of an unsuitable landing zone by the pilot.