NTSB investigations, 1985
3 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\") = 1985
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") = 1985 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 NYC85LA221Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ronkonkoma, NYDuring a local training flight the student was attempting a lift off and began to drift to the left. The students control input was to the left aggravating the situation. The instructor took control of the aircraft however the roll over had progressed to an…NTSB CHI85LA254Accident · No injuriesLimited investigationFinal reportBell 47G-4 · Lakeville, MNThe acft was being landed on a trailer for transportation. Upon touchdown the right skid hooked on the landing guides and the helicopter rolled to the right side. The main rotor blades struck the ground, the left fuel tank ruptured and an explosion and fire…NTSB CHI85FA198Accident · 1 fatalField investigationFinal reportBell 47G-2 · Burlington, MIThe helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.