NTSB investigations, 2006
5 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\") = 2006
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") = 2006 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 MIA07CA021Accident · Minor injuriesData collectionFinal reportRobinson R22 · Lakeland, FLThe flight instructor's failure to maintain control of the helicopter during takeoff resulting in a roll over.NTSB LAX07CA043Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Santa Clarita, CAthe student pilot's inadequate compensation for wind conditions and the instructor's failure to arrest the descent, which resulted in a dynamic rollover. Also causal was the inadequate supervision by the instructor. A factor in the accident was the wind shift…NTSB LAX07CA034Accident · No injuriesData collectionFinal reportBell 206B · Boulder City, NVthe pilot's inadequate planning and decision in his failure to reduce the engine throttle to ground idle prior to exiting the helicopter.NTSB MIA06CA053Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe improper landing flare by the pilot-rated student and the inadequate supervision of the pilot-rated student by the certified flight instructor, resulting in the improper touchdown of the helicopter and the helicopter rolling over.NTSB LAX06CA116Accident · Minor injuriesData collectionFinal reportRobinson R22 · El Monte, CAthe pilot's inadequate compensation for the wind conditions, which resulted in the helicopter dynamically rolling over.