NTSB investigations, 2000
9 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\") = 2000
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") = 2000 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 NYC01LA043Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Londonderry, NHThe pilot's failure to obtain the proper touchdown point.NTSB MIA01LA007Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Dellwood, FLthe pilot's failure to clear the area, and his attempted takeoff while the helicopter's right skid was entangled with vines, which resulted in inadvertent dynamic rollover and substantial damage to the aircraft.NTSB LAX01LA002Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAThe dual student's improper use of the collective and the flight instructor's inadequate supervision during the practice hovering autorotation maneuver. A factor was the underlying soft dirt terrain, which promoted the rollover event.NTSB LAX00LA248Accident · Serious injuriesLimited investigationFinal reportKashan Michael Berkut 540 · Jackpot, NVthe pilot's loss of control on landing after encountering a dust devil/whirlwind.NTSB MIA00TA189Accident · Serious injuriesFinal reportBell OH-58 · Rome, GAThe pilots failure to ensure the helicopter was on level terrain after landing. The left skid came off the ground after the passenger exited the helicopter, the slope capability was exceeded, the helicopter encountered dynamic rollover, and rolled over on its…NTSB FTW00LA181Accident · Minor injuriesLimited investigationFinal reportBell 206B · Deville, LAthe pilot's failure to maintain clearance with the external load that was setting on the ground while hovering. A contributing factor was the pilot's diverted attention.NTSB NYC00LA152Accident · No injuriesLimited investigationFinal reportSchweizer 269-C1 · Chesapeake, VAthe failure of the student pilot to reduce the friction on the cyclic prior to raising the collective for the magneto check. A factor was the failure of the company to adequately define the steps in the checklist.NTSB FTW00LA161Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cocodrie, LAthe pilot's failure to maintain clearance with the platform's safety fence during takeoff.NTSB MIA00LA095Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · Delray, FLa collision with a fence while at a hover, which resulted in the helicopter rolling over.