NTSB investigations, 1995
6 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\") = 1995
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") = 1995 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 CHI96LA046Accident · No injuriesLimited investigationFinal reportRobert Eckley Rotorway · Salina, KSthe pilot's improper maintenance of the helicopter. Factors in the accident were the pilot's lack of proper certification for the operation of the helicopter and his lack of recent experience in type of aircraft.NTSB LAX95LA271Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Redlands, CAThe company's maintenance personnel improper servicing of the landing skid actuators.NTSB LAX95LA174Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Long Beach, CAthe pilot's misjudged landing flare. A factor in the accident was the illusion of a lower than actual altitude created by the high vegetation which led the pilot to flare early.NTSB LAX95LA136Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Van Nuys, CAthe operation of the helicopter with improper adjustment of the landing gear and main rotor dampers due to the inadequate maintenance inspection of the helicopter by maintenance personnel and an inadequate preflight inspection by the pilot.NTSB BFO95LA031Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDthe helicopter pilot's inadequate control of the aircraft during the attempted takeoff.NTSB LAX95LA081Accident · No injuriesLimited investigationFinal reportRotorway Rotorway · Chandler, AZthe student pilot's improper use of the helicopter's flight controls and the instructor's inadequate supervision of the flight.