NTSB investigations, 1985
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\") = 1985
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") = 1985 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 MIA86FA027Accident · 2 fatalField investigationFinal reportParsons B/P Gyrocopter · Dunnellon, FLThe instructor plt who was not rated in helicopters or gyroplanes and had an expired instructors certificate was imparting instruction to a student plt in a 2 place homebuilt gyrocopter. When on downwind turn to base leg the student tipped the rotor disc…NTSB LAX86LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fullerton, CADuring an instructional flt the student plt, who had a total of 5 hrs of flt time, attempted to land with the flaps extended to the 20 deg position. The acft ballooned, & the CFI took control & elected to complete the landing. Insufficient rwy remained & the…NTSB NYC86FA017Accident · 1 fatalField investigationFinal reportSchweizer SGS-1-35C · North Conway, NHDuring an off airport landing attempt in a cleared corn field, the glider was approaching a treeline at an altitude of 10 to 20 ft AGL. Witnesses observed the glider pull up and bank to the left before falling nose first into the ground. The pilot's log book…NTSB CHI85LA378Accident · Minor injuriesLimited investigationFinal reportSchweizer 134 · Hampshire, ILThe pilot reportedly failed to use spoilers on final. The approach was high so he attempted a 180 degree turn at the departure end of the runway. The glider stalled and collided with the ground.NTSB LAX85FA385Accident · 1 fatalField investigationFinal reportJonas Humming Bird · Tucson, AZThe experimental homebuilt acft was designed by the plt and incorporated a lifting body symetrical airfoil shaped fuselage. Pitch control was to be accomplished with a narrow chord canard. Witnesses saw the acft lift off briefly to about 10 ft AGL during the…NTSB FTW85FA335Accident · 2 fatalField investigationFinal reportNorth American British Harvard Mkii · Ada, OKTwo fully qualified single engine plts were in the acft at the time of the accidnet. The acft was observed making low passes near the airport after takeoff. One plt's mother lived near the accident site. The acft was in a steep banked right turn when the…NTSB FTW85FA306Accident · 1 fatalField investigationFinal reportCessna A150M · Levelland, TXThe plt had been observed to make takeoffs using maximum up elevator for liftoff. The elevator was found in a nineteen degree up position and both the left horizontal stabilizer and elevator were bent upward at the tip. The down elevator clevis was observed…NTSB LAX85LA319Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Thermal, CAThe acft crashed during a night visual approach while practicing landings. The pax stated that the acft was high on the approach and the pilot was adjusting his rate of descent when the acft went down.NTSB DEN85FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Columbus, MTAfter making a low pass over his pax home, the plt pulled the acft up abruptly and stalled at a very low altitude. The alt was too low for the plt to effect a successful recovery before ground impact.NTSB FTW85LA260Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe pilot stated he first saw another aircraft ahead of and below him on final to the runway. He maneuvered to establish interval, then decided to go around. He added fullthrottles but left the flaps and gear down. Unalbe to climb,he decided to land behind…NTSB CHI85FA218Accident · Serious injuriesField investigationFinal reportCessna 425 · Dayton, OHThe acft involved was experimentally configured with 4-bladed props and was on a test flt to determine handling characteristics following a throttle chop to idle power at 50 ft AGL. This maneuver had been accomplished twice on the test flt without incident.…NTSB CHI85LA181Accident · No injuriesLimited investigationFinal reportCessna 172N · Perrysville, OHAcft landed with quartering tailwind. Acft touched down, ballooned and touched down again with aprx 1000 ft of rwy remaining. Unable to stop on the tall wet grass, plt initiated a groundloop to the left into a plowed field. The acft then nosed over.NTSB ATL85FA147Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Monroe, NCThe acft collided with rwy 23 (aprx 120 ft from the departure end) following a loss of control during an initial takeoff climb. The acft was observed to enter a steep climb on takeoff after which the right wing dropped. The acft then entered a spin prior to…NTSB ATL85LA205Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Union City, TNPilot with 7900 total hours and four hours in gyoplane was on solo cross country training flight. During takeoff at enroute stop rotor blades struck vertical stabilizer. Pilots instructor said witnesses reported that the gyroplane was rotated abruptly during…NTSB MIA85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLDuring a student trng flt the instructor pilot stated that he reduced throttle on takeoff at about 75 ft AGL, to simulate an engine failure. The student pilot pitched the nose of the acft up and the instructor pilot took over control of the acft, lowered the…NTSB MKC85LA081Accident · No injuriesLimited investigationFinal reportEhlers Starduster ESA300 · Kansas City, MOThe plt stated that during the landing roll he noticed an acft landing behind his and therefore veered his acft to the right of rwy 36 traveling about 45 mph. During the maneuver the plt felt the right gear give and the acft consequently ground looped twice…NTSB CHI85FA121Accident · 4 fatalField investigationFinal reportMooney M20K · Coldwater, OHThe flight departed without a pre-flight inspection, engine run up, or radio call on UNICOM. The aircraft was observed doing low altitude aerobatic maneuvers. Witnesses observed the aircraft nose over and impact the ground in a near vertica attitude from…NTSB ATL85LA100Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Hilton Head, SCAcft stalled & crashed from an altitude of about 300 ft. witnesses stated that the acft entered a steep clumb angle upon lift off and climbed to about 300 ft. then the acft nosed over & fell to the ground.NTSB MIA85FA071Accident · Serious injuriesField investigationFinal reportFuji LM-1 "NIKKO" · Odessa, FLThe acft collided with the ground in an acft parking area on the arpt after a low alt loop which was not completed prior to ground contact. The plt had made one low pass down the rwy in formation with another Fuji acft, a 2nd pass ended in an aileron roll,…