NTSB investigations, 1990
14 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\") = 1990
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") = 1990 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 LAX91DXQ01Accident · Minor injuriesFinal reportPitts S-1E · Carson City, NVThe pilot's failure to maintain directional control during takeoff roll and the abrupt pullup to a premature takeoff.NTSB CHI91GA014Accident · 1 fatalFinal reportCessna 172P · Williamsburg, IAThe pilot-in-command's abrupt pull-up to avoid an obstacle. Contributing was the pilot-in-command's diverted attention to activities on the ground.NTSB NYC91LA002Accident · 2 fatalLimited investigationFinal reportForney 415D · Morrisville, NYThe pilot executing a left turn at an altitude insufficient to clear a corn field located in close proximity to the departure runway.NTSB LAX90DUQ02Accident · 1 fatalFinal reportFolland Gnat T-1 · Mojave, CAThe pilots failure to correct a descent during a low level aerobactics.NTSB DEN90LA175Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-19 · Alamogordo, NMThe pilot's failure to maintain control of the glider, which resulted in the pilot induced oscillations.NTSB CHI90DEV07Accident · 2 fatalFinal reportPitts S2B · Springfield, ILThe pilot's failure to maintain flying speed and allowed the aircraft to stall during the break turn to downwind.NTSB LAX90LA257Accident · No injuriesLimited investigationFinal reportCessna A185F · Discovery Bay, CAThe pilot's improper visual lookout to assure the area was clear of boats before departing.NTSB FTW90GA137Accident · Minor injuriesFinal reportCessna 404 · San Angelo, TXImproper use of powerplant controls by the pilot-in-command (PIC). Factors related to the accident were: the pic's inadequate crew coordination, and the excessive airspeed and rate of descent that resulted, when the PIC maneuvered the aircraft back on course…NTSB MKC90DCJ01Accident · 1 fatalFinal reportK. W. Jeffers Varieze · Brainard, NEPilot used poor judgement in attempting aerobatics with inadequate altitude which resulted in loss of aircraft control. Contributing factors were a low pass performed, over confidence in personal ability and ostentatious display by the PIC.NTSB BFO90LA042Accident · No injuriesLimited investigationFinal reportBell 47D · Baltimore, MDThe pilot applied excessive cyclic control, causing the main rotor to flex and severe the tail cone.NTSB DEN90FA099Accident · 2 fatalField investigationFinal reportPiper PA-22-160 · Scranton, NDPilot factor in that he failed to maintain aircraft control while performing an inflight maneuver.NTSB CHI90LA115Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Milwaukee, WIThe utilization of improper procedures on the part of the pilot in command by attempting to execute a coupled approach outside the parameters of the autopilot.NTSB LAX90LA151Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Creston, CAThe inadvertent intrusion of wildlife on the runway environment and the pilot's application of brakes resulting in a nose down attitude and propeller strike.NTSB DEN90FA059Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260C · Agoura, CALoss of control of the aircraft during acrobatic flight and the pilot's failure to recover from a spin.