NTSB investigations, 1996
10 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 19 |
| 1986 | 27 |
| 1987 | 25 |
| 1988 | 19 |
| 1989 | 10 |
| 1990 | 14 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 13 |
| 1994 | 9 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 9 |
| 1998 | 11 |
| 1999 | 5 |
| 2000 | 10 |
| 2001 | 10 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 4 |
| 2005 | 12 |
| 2006 | 4 |
| 2007 | 4 |
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\") = 1996
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\" = 100)
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") = 1996 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" = 100) 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 LAX97LA061Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600N · Flagstaff, AZThe pilot's inattention to the altitude and inadvertent late entry into an autorotation maneuver below the established minimum test altitude with a helicopter operating at maximum gross weight in a high density altitude environment that led to a subsequent…NTSB LAX97LA014Accident · 1 fatalLimited investigationFinal reportCunningham Rotorway Exec · Mather, CAexcessive maneuvering by the pilot, which allowed the main rotor blades to contact and sever the tail rotor system and allowed mast bumping to occur.NTSB CHI97LA010Accident · 2 fatalLimited investigationFinal reportDellicker Starduster TOO SA300 · Eaton Rapids, MIthe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall of the airplane. A factor was the ostentatious display.NTSB IAD96LA137Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Waterford, OHthe pilot's decision to abruptly maneuver the airplane with insufficient altitude to recover.NTSB ANC96LA113Accident · No injuriesLimited investigationFinal reportSportsman 2+2 · Wasilla, AKThe pilot's failure to maintain control of the airplane which resulted in an inadvertent stall/mush. A factor associated with the accident was the pilot's low altitude skidding maneuver.NTSB NYC96LA148Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Westerly, RIinsufficient information from the manufacturer in the airplane flight manual and flightcrew operating manual regarding the hazards of applying force to the control wheel or column while the autopilot is engaged and adjusting the pitch thumbwheel during a…NTSB FTW96LA269Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-340-200 · Dfw Airport, TXThe flightcrew's abrupt maneuver/descent in response to a TCAS RA. Factors were the company assignment of the captain to the crew position with a lack of captain training.NTSB LAX96LA231Accident · Serious injuriesLimited investigationFinal reportVans RV6 · Inyokern, CAthe pilot's failure to maintain control of his airplane and stalled while intentionally performing a low altitude maneuver on base leg in a high density altitude environment.NTSB CHI96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Grand Forks, NDthe instructor pilot used an improper procedure when he demonstrated a rejected takeoff and he misjudged the flare.NTSB LAX96LA207Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Thermal, CAinadequate design of the stress limits for cyclic control of the helicopter.