NTSB investigations, 1998
8 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\") = 1998
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") = 1998 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 FTW99LA048Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-BA · San Angelo, TXthe rollover during take off for undetermined reasons.NTSB LAX98LA249Accident · No injuriesLimited investigationFinal reportBell 222B · Tranquility, CAThe pilot's delayed initiation of a go-around when the severity of the dust condition first became apparent. Contributing factors were dark night conditions and the obscuration from the dust.NTSB MIA98LA179Accident · No injuriesLimited investigationFinal reportRotorway Executive 162F · New Port Richey, FLThe pilot's improper use of the collective. Contributing to the accident was pilot fatigue due to lack of sleep.NTSB LAX98LA170Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Luis Obispo, CAThe flight instructor's inadequate compensation for wind conditions, and his failure to maintain aircraft control. Contributing was wind gusts.NTSB IAD98LA057Accident · No injuriesLimited investigationFinal reportHughes 269A · Alexandria Bay, NYFailure of the pilot to maintain rotor rpm during practice autorotation, and the flight instructor's inadequate supervision.NTSB ANC98LA032Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350B · Soldotna, AKThe pilot's inadvertent dynamic rollover while performing a slope landing. Factors associated with the accident are the presence of rough and uneven terrain, and the pilot's improper slope landing technique.NTSB LAX98LA083Accident · No injuriesLimited investigationFinal reportRobinson R22 · Oxnard, CAThe pilot's improper use of the collective during the initiation of the rollover, which prevented the recovery from the condition.NTSB IAD98LA024Accident · Minor injuriesLimited investigationFinal reportKaman K-1200 · Bloomfield, CTThe pilot's failure to maintain control during autorotation, which resulted in an unleveled attitude touchdown, roll over, and collision with the ground.