NTSB investigations, 1984
13 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\") = 1984
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") = 1984 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 FTW84LA380Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Lubbock, TXFailure to complete both the takeoff and landing check-lists resulted in taking off with the elevator trim improperly set and the gear-up landing. According to the plt, as the acft was cleaned-up after takeoff from rwy 17R the nose became very heavy. The…NTSB DEN84LA276Accident · Serious injuriesLimited investigationFinal reportMolino PIK-20 · Calhan, COThe glider struck a barbed wire fence while landing in a pasture. The plt said he encountered a downwash at the edge of a storm that resulted in an 800 fpm rate of descent and forced landing.NTSB MKC84LA265Accident · No injuriesLimited investigationFinal reportHughes 269C · Witts Springs, ARWhile manuevering at an alt of 35 to 40 ft above tree the plt felt a shutter and low frequency shaking of the rotor disk. Rotor RPM and engine RPM decreased and the acft entered a shallow descent. The plt applied forward cyclic, reduced collective and…NTSB CHI84LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Manchester, OHThe accident occurred when the pilot was flying low on a fly-by for photographs. Adjusting her seat, the passenger hit the control yoke, the aircraft pitched down and collided with a tree. The pilot recovered control and completed a safe landing at an airport…NTSB LAX84FA429Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Julian, CAAfter takeoff several 360 deg climbing turns were made to gain alt to clear the mountain ridge. The ridge was approached at 4800 ft MSL with the plt expecting a thermal lift over the 5500 ft level which had been encountered many times before. At 4800 ft MSL…NTSB NYC84LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Bargaintown, NJThe acft was on a banner tow mission. Plt dropped banner and initiated a pull-up manuever to go-around and return for a landing. As the plt pulled up, a downdraft was encountered at the end of the field. Plt initiated a right turn and acft continued sinking…NTSB CHI84LA260Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Geneva, ILThe Balloon descended in an area of thunderstorms and turbulence and collided with trees. The plt said the Balloon 'caved in' and descended rapidly. The plts husband and a passenger revealed that the Balloon was 'vented' by the plt to land before reaching a…NTSB SEA84LA127Accident · No injuriesLimited investigationFinal reportBreezy RLU-1A · Jean, NVThe acft departed on rwy 20 and turned crosswind at an alt of 200 ft AGL. The plt stated that after turning downwind for a non-standard traffic pattern at an airspeed of 60 to 65 mph the acft began to lose altitude. The acft continued the descent even though…NTSB NYC84LA203Accident · No injuriesLimited investigationFinal reportCessna 150K · Warren, VTThe plt stated that while crossing a mountain ridge a mountain wave was encounterd which resulted in a 1000 fpm sink rate. The plt stated this sink rate increased when a turn was made to parallel the ridge. The acft settled into trees.NTSB DEN84LA150Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Nucla, COPlt stated, 'I made one pass on low boundry spreading 100% of seed and began a climbing left turn to make a pass from high side down east boundry. I reached altitude of approximately 300 ft AGL (above ground level) and attempted to pass over telephone draw…NTSB MKC84LA133Accident · No injuriesLimited investigationFinal reportBeech V35B · Lee'S Summit, MOThe plt reported that the acft landed hard, bounced and landed hard again breaking the nose gear off the acft. The pilot stated he encountered a strong downdraft on approach.NTSB CHI84LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Lima, OHHeavy wet snow was falling on the day of the accident. The plt reported that he cleared snow off the wings of the acft, but not off the horizontal surface of the t-tail. Also he reported, a considerable amount of slush remained on the rwy which was thrown up…NTSB NYC84LA139Accident · No injuriesLimited investigationFinal reportBalloon Works Fire FLY 6B · Butler, PADuring a descent to land, the plt of a Balloon tried to level off to reach a desired touch down point. The plt added heat, but the Balloon continued to descend. After a hard bounced landing, the Balloon began to ascend, but it collided with tree limbs & was…