NTSB investigations, 1988
19 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\") = 1988
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") = 1988 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 CHI89DEX01Accident · 1 fatalFinal reportPitts S-15 · Delphi, INFailure to recover from an aerobatic maneuver due to lack of total experience, and lack of recent experience in the type of flight regime.NTSB FTW89DPJ01Accident · 1 fatalFinal reportAutra Scorpion/133 · Mcalester, OKThe homebuilt helicopter was departing on a local flight, when, on initial climbout, the low time, inexperienced student pilot made an abrupt maneuver which sent the helicopter into an uncontrolled descent. It impacted trees and a post crash fire occurred.NTSB MKC89FA004Accident · Serious injuriesField investigationFinal reportHughes 500C · Branson, MOThe flight was conducted for sightseeing with 5 passengers onboard. The pilot turned on final approach with 35 knots of airspeed and encountered a high rate of descent. The pilot reported that he noted a split tach and initiated an autorotation, but was…NTSB SEA89LA003Accident · No injuriesLimited investigationFinal reportLet L-13 · Enumclaw, WAThe pilot allowed the aircraft to become too close to terrain while soaring. A steep turn to reverse direction resulted in entry into an accelerated stall at low altitude. The pilot lowered the nose of the aircraft to recover, however, while lowering the nose…NTSB FTW88DPA07Accident · No injuriesFinal reportBölkow BO-105C · Dallas, TXThe helicopter made its approach to an open area on the westside of the airport to go to a refueling area on the south side of the airport. The pilot changed his mind and decided to go to the northeast side of the airport. He received tower approval but was…NTSB ATL88FA220Accident · No injuriesField investigationFinal reportPiper PA-28-151 · La Grange, GAThe PIC stated he had a hardover in the single axis autopilot which resulted in the acft constantly turning right. Therefore due to the continous bank he elected to make a precautionary landing in a lake versus on land. The acft impacted in a lake left of the…NTSB DEN88LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Fort Peck, MTThe pilot made a takeoff from a muddy, dirt, road. He said that after he become airborne he put his aircraft into a sharp turn in order to avoid some power lines. Although he was successful in avoiding the power lines, he inadvertently stalled the aircraft…NTSB LAX88LA229Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dorris, CADuring a local pleasure flt, just as the airplane touched down, an antelope ran across the rwy. The plt swerved the airplane to avoid the animal, exited the runway and collided with the terrain. There were no mechanical failures or malfunctions with the…NTSB MKC88LA102Accident · No injuriesLimited investigationFinal reportPitts S-2 · Siloam Springs, ARThe pilot said that after takeoff and reaching a safe altitude, he made an immediate hard left turn resulting in a loss of control. Pilot did not recover from the resultant stall.NTSB SEA88FA095Accident · 1 fatalField investigationFinal reportCessna 172L · Ocean Shores, WAThe student pilot departed on his fifth solo flight from the airport where he had been accustomed to originating his instructional flights. After several touch and go landings he proceeded to a nearby airport and conducted at least one more touch and go.…NTSB FTW88DRA10Accident · Minor injuriesFinal reportNew Rutan LONG-EZE · Friendswood, TXThe pilot overrotated the aircraft on takeoff to a nose high attitude, then overcontrolled in the opposite direction to get the nose down. The aircraft touched down nose gear first and all three landing gears collapsed, a wing sheared off, and the aircraft…NTSB FTW88DRA09Accident · 1 fatalFinal reportCurtis Baby Great Lakes · Angleton, TXShortly after liftoff, the acft was observed to enter a rt bank and then a left bank to a course parallel to the t/o rwy. It was subsequently observed to enter a left turn which steepened and the acft nosed over until ground impact. Original turn was executed…NTSB SEA88LA072Accident · 1 fatalLimited investigationFinal reportSteen Skybolt GT-2 · Saint John, WAAfter tkof witnesses said the acft did a maneuver at 50-60 ft AGL that involved a steep (90 degree) banked turn to a snap roll. The biwing acft was capable of aerobatic flt and the plt had discussed aerobatic roll maneuvers on tkof with the acft co-owner. The…NTSB MKC88FA072Accident · 1 fatalField investigationFinal reportBeech H18 · Kansas City, MOThe cargo flt dptd cincinnati enrt to wichita, KS with an intermediate stop at Kansas City dtwn arpt. The flt progressed nrmly to a VOR rwy 03 instrument apch, circling to rwy 01. The PIC had been clrd to commence the apch. Twr pers subsequently advised the…NTSB ATL88FA123Accident · 4 fatalField investigationFinal reportBeech C23 · Sevierville, TNThe aircraft was not certified for acrobatic flight. According to several witnesses the pilot was practicing acrobatics with three passengers on board. The pilot lost control of the aircraft and did not recover.NTSB ATL88FA118Accident · 2 fatalField investigationFinal reportChampion 7BCM · Bishopville, SCThe student pilot, carrying a passenger, attempted a low level maneuver, and stalled the aircraft. He was unable to recover in the altitude available and the aircraft struck the ground. Toxicological tests on the blood/urine were done on the PIC. The blood…NTSB MIA88FA122Accident · No injuriesField investigationFinal reportBoeing 747-200 · Miami, FLAfter landing the Boeing 747-200 airliner, the captain increased the pitch attitude to 11 degrees nose up by pulling the control column aft. The tail struck the ground causing substantial damage. The Boeing airplane flight manual prescribes that the…NTSB MKC88FA040Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Creve Coeur, MOWitnesses stated that the aircraft suddenly started a vertical climb from a straight and level flight attitude. The airplane lost momentum while in the climb, then it nosed down and dove towards the ground. It exploded upon impact and was destroyed in the…NTSB ATL88FA070Accident · 2 fatalField investigationFinal reportCessna 152 · Ravenna, OH