NTSB investigations, 1985
10 cases where the first occurrence was “Altitude deviation,uncontrolled”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 5 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 7 |
| 1990 | 2 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 4 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 1 |
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\" = 110)
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" = 110) 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 CHI86LA018Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Comstock Park, MIAccording to the pilot she received wind information from a flight service station, the noaa and ATIS approximately 1.5 hours prior to takeoff. All these sources predicted winds to be less than 7 knots. Winds were 'very light' during Balloon inflation. The…NTSB CHI85LA189Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tyler, MNPlt stated he was about to abort the takeoff during the long ground run when the acft lifted off. At 30 to 40 ft AGL acft began to sink. Acft contacted a fence post and touched down in a plowed field. Nose gear collapsed and acft nosed over. Plt previously…NTSB ATL85LA125Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Blairsville, GAThe private pilot and his student plt passenger were departing the a/p when the plt made a sharp turn downwind at about 100 ft of alt. The a/c mashed into the ground bounced and landed in small trees. The nearest reported winds were recorded at 19 KTS. The…NTSB SEA85IA080Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-14 · Reno, NVAfter a ground time of 36 minutes during rain/wet snow the aircraft departed Reno. During the climb in below freezing conditions the crew experienced elevator pitch control difficulties which persisted until the descent into seattle. Examination of the…NTSB FTW85LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bartlesville, OKAfter one uneventful full-stop landing the plt re-entered the pattern for a second landing. The plt truned to final at about 500 ft AGL and 65-70 KTS with the rwy lights in sight. Shortly thereafter, according to the plt, the landing light illuminated two…NTSB FTW85LA129Accident · No injuriesLimited investigationFinal reportRotorway Exec · Bethany, OKThe owner/builder had a single engine, multi-engine, land rating, but did not have a helicopter rating. While practicing hover flt in his experimental helicopter, he unexpectedly allowed the helicopter to reach a higher than normal alt. He attempted to…NTSB LAX85LA155Accident · Serious injuriesLimited investigationFinal reportRobinson R-22A · Santa Barbara, CAStudent plt stated that while flying the last leg of a solo cross country flight he was flying along the coast at 50 to 75 feet, he diverted his attention to look at the a man on the beach and when he looked back at the instruments he noticed the helicopter…NTSB DEN85LA086Accident · No injuriesLimited investigationFinal reportCessna 210 · Fort Bridger, WYThe acft encountered moderate turbulence and IFR conditions while en route over Fort Bridger, WY. The plt stated he attempted to climb on top but the acft had accumulated ice and the altimeter and VSI indicated a rapid descent. A forced landing was then…NTSB SEA85LA059Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126E · Reno, NVStudent glider pilot was ridge flying in thermals then lift dropped off. The acft turned downwind, away from rising terrain and the plt made an emergency off arpt landing.NTSB ANC85LA039Accident · No injuriesLimited investigationFinal reportCessna C-207 · Nome, AKPlt obtained a special VFR to land at Nome arpt. Plt saw apch lights and made a left circle to line up with rwy. Plt stated, ceiling was 300 ft AGL, low visibility and freezing drizzle was present. Aprx 3/8 inch of ice was on airframe and windshield. Plt…