NTSB investigations, 2001
7 cases where the first occurrence was “Rotor failure/malfunction”.
Cases per year
| 1994 | 1 |
|---|---|
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 8 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 2 |
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\") = 2001
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\" = 132)
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") = 2001 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" = 132) 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 NYC02TA026Accident · Serious injuriesFinal reportBell 407 · Whitley City, KYThe pilots decision to operate the helicopter at an airspeed in excess of the maximum demonstrated stable airspeed for the water bucket. A factor in the accident was the pilot did not follow the published emergency procedure.NTSB NYC01LA168Accident · No injuriesLimited investigationFinal reportBell 206B · Secaucus, NJUnder torque of a Thomas coupling self-locking nut for undetermined reasons, which resulted in the loss of the corresponding retaining bolt, and subsequent separation of tail rotor drive shaft segments. A factor was the unsuitable terrain beneath the pilot…NTSB CHI01LA162Accident · No injuriesLimited investigationFinal reportGiackino Exec 162F · Manistique, MIThe contamination of the main rotor drive belts causing them to slip. Factors were the low altitude, unsuitable terrain for the forced landing, and the water.NTSB FTW01LA124Accident · No injuriesLimited investigationFinal reportRobinson R22 · Raymondville, TXthe failure of the main rotor drive belts while maneuvering which resulted in a loss of main rotor drive. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA141Accident · No injuriesLimited investigationFinal reportParker Rotorway 162F · Minneapolis, MNThe tail rotor drive belt coming off in cruise flight and it not being possible for the student pilot to maintain aircraft control during the emergency landing attempt. Factors relating to the accident were the loose bearing in the secondary drive unit to the…NTSB FTW01LA087Accident · No injuriesLimited investigationFinal reportBell 47G2 · Ardmore, OKthe loss of tail rotor control during maneuvering resultant from the failure of the tail rotor drive shaft coupling due to a stripped thread which allowed the grease lubricating the shaft to leak out. A factor was the lack of suitable terrain for the forced…NTSB DEN01LA067Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Buffalo, WYfailure of the rotor drive system clutch assembly which rendered the aircraft uncontrollable.