NTSB investigations, 1986
4 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\") = 1986
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") = 1986 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 ANC86LA096Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Alexander Creek, AKWhile landing on a river bar, the acft drifted to the left of the normal touchdown zone. Subsequently, the wheels entered soft sand and the airplane turned over.NTSB MIA86LA147Accident · No injuriesLimited investigationFinal reportHughes 269C · Jacksonville, FLThe plt stated that as he was landing on a dolly, the helicopter experienced ground resonance & began to shake violently. It then rolled over on its side, causing the main rotor blades to strike the tail boom & the ground.NTSB LAX86FUG04Accident · No injuriesFinal reportRotorway Scorpion 133 · Corona, CAThe plt stated he was 'running up the engine' after making some adjustments. The helicopter was tied down when the plt lifted off to a 5 to 6 ft hover. The helicopter tipped to the right, the main rotor blades contacted the terrain and the helicopter rolled…NTSB DEN86LA082Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Meeker, CODuring the lift off the right skid toe of the helicopter caught a seismic cable which was covered by aprx 2 ft of snow. The plt stated he brought the acft to a hover after off loading 2 pax & started a right sideward hover. When the slack was out of the…