NTSB investigations, 1987
11 cases where the first occurrence was “Forced landing”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 11 |
| 1984 | 6 |
| 1985 | 15 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 13 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 5 |
| 1999 | 9 |
| 2000 | 3 |
| 2001 | 5 |
| 2004 | 4 |
| 2005 | 1 |
| 2006 | 6 |
| 2007 | 7 |
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\") = 1987
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\" = 180)
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") = 1987 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" = 180) 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 MIA88LA036Accident · No injuriesLimited investigationFinal reportRaven S-66A · Naples, FLAfter liftoff with the deflation panel partially open, the flt continued towards the landing location. With a high rate of descent established, the plt realized that the balloon would not clear the powerlines that were ahead of the landing location. He then…NTSB ATL88LA018Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Whitwell, TNThe glider plt made an off-arpt ldg after realizing that he didn't have enough altitude to return to his departure point. During ldg rollout on uneven terrain, one of the wingtips contacted the terrain and the glider ground-looped.NTSB DEN87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Steamboat Sprin, CON7494J took off from a high alt arpt and climbed in the vic of the arpt to 9500 feet before proceeding on course. Upon approaching high terrain the plt realized he did not have enough alt to clear the terrain and was in a valley too narrow to turn around. He…NTSB FTW87DRG06Accident · Minor injuriesFinal reportWilliam M. Burge Tern · Refugio, TXOn August 8, 1987, a burge tern, N38826 impacted a transmission wire and subsequently, the terrain while attempting a forced landing to a field approximately 7 miles west of Refugio, Texas. The homebuilt glider had flown approximately 18 miles northwest of…NTSB FTW87LA186Accident · No injuriesLimited investigationFinal reportLet L-13 · Hempstead, TXAcft landed short of threshold following a low release shortly after t/o. release was low due to tow plane's being unable to climb above 200' AGL due to the glider's spoilers being deployed inadvertently during the t/o. the plt stated that he executed a 270…NTSB ATL87LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Goldsboro, NCStudent PIC rpted he followed wrong railroad track to return from the practice area to the airport. Viz was about 6 miles in hazy conditions. Prior to exhausting fuel or daylight he elected to land in a field. Field was soft terrain and acft nosed over.NTSB MIA87LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ruleville, MSWhile maneuvering the acft for a swath run after takeoff the plt stated that it was slow to climb. He then lowered the nose to increase airspeed, & realizing that the acft would not clear trees located ahead of the flt, elected to land in a field. Upon…NTSB NYC87LA136Accident · No injuriesLimited investigationFinal reportBeech BE-18 · York, PAWhile the aircraft was being ferried from massy, Maryland to ankeny, Iowa, a loss of oil pressure on the left engine was experienced. A precautionary landing was made in a cornfield with the landing gear in the up position when the gear failed to extend. Fire…NTSB FTW87LA107Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe pilot reportedly heard an unusual noise in the engine and made a precautionary autorotation to landing. Touchdown was on uneven terrain and in a nose low attitude. This resulted in the tail rotor assembly being chopped off the tail boom by the main rotor…NTSB FTW87FA090Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Uvalde, TXOn 04-02-87, a Piper PA-38-112, N5540E, owned and operated by southwest Texas junior college, impacted the terrain near Uvalde, TX. The flight was conducted for training purposes. Visual meteorological conditions prevailed at the time of the accident. The…NTSB LAX87LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Marana, AZDuring a winch tow, the cable prematurely released the glider at approximately 100 to 150 feet. The glider remained in a nose high attitude momentarily then began a shallow descending right turn. At approximately 75 feet the roll, pitch, and descent rate…