NTSB investigations, 1991
11 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
Latest 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\") = 1991
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") = 1991 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 FTW92LA044Accident · No injuriesLimited investigationFinal reportHiller-Osborn UH-12D · Rio Medina, TXThe pilot's improper flare during touchdown.NTSB FTW92FA014Accident · 2 fatalField investigationFinal reportBeech A36 · Marble Falls, TXThe pilot's performance of acrobatic maneuvers at an altitude too low to allow for recovery.NTSB FTW92IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Houston, TXThe pilot's failure to attain proper runway alignment prior to touchdown and his failure to initiate a go around to remedy the situation. A factor was the low altitude at which he initiated the side step maneuver for which he was cleared.NTSB FTW92DPJ01Accident · 1 fatalFinal reportAyres S2R-T15 · Cordell, OKInadvertent stall. A factor was that the aircraft weight and balance limitations were exceeded.NTSB ATL91LA171Accident · No injuriesLimited investigationFinal reportCessna 150L · Pickens, SCThe panicked, intentional interference of the flight controls by the student.NTSB DEN91LA122Accident · No injuriesLimited investigationFinal reportStinson 108 · Steamboat Sprin, COA swerve initiated by the pilot in command to avoid a collision with a deer during takeoff roll.NTSB FTW91FA142Accident · 2 fatalField investigationFinal reportCessna 170A · Heath, TXThe inadvertent stall following an abrupt pull up while maneuvering at low altitude, and the pilot's impairment due to to alcohol and drug consumption.NTSB FTW91FA104Accident · 1 fatalField investigationFinal reportCessna C182R · Big Spring, TXThe pilot's failure to recover from an aerobatic maneuver due to insufficient altitude.NTSB LAX91LA250Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Stockton, CAFailure of the pilot to maintain an adequate visual outlook to detect power transmission wires in his flight path resulting in an abrupt maneuver and subsequent inadvertent stall.NTSB NYC91FA123Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Hancock Village, NYThe loss of aircraft control and subsequent collision with trees after the pilot became physically incapacitated.NTSB CHI91DEP03Accident · 1 fatalFinal reportAir Command 503 · Tomahawk, WIThe pilot-in-command's abrupt movement of the flight controls which resulted in loss of rotor RPM and eventual departure from controlled flight. A factor contributing was ice accumulation on the pilot's face resulting in pilot incapacitation (visual…