NTSB investigations, 1982
10 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\") = 1982
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") = 1982 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 SEA83LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Cascade Locks, ORWhile cruising at 10000 feet MSL, in IMC conditions, the pilot reported that power had been lost. During descent to 2000 feet the engine restarted and failed several times but eventually maintained idle throughout the remainder of the descent. Portland…NTSB NYC83LA024Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-1D · North Conway, NHAfter a tow-release at about 2,000 ft the plt encountered a sink which eventually developed into about a 1,000 fpm sink. The acft struck a fence during the forced landing.NTSB DEN83LA002Accident · No injuriesLimited investigationFinal reportBell 47G3B · Nr. Englewood, COPilot was practicing maneuvers for certification test. He said he made a precautionary landing due to suspected engine trouble and a fire started under the aircraft in the grass. He exited the aircraft but left battery and radio on. This investigation…NTSB ATL82DA283Accident · No injuriesFinal reportGlasflugel Mosquito · Tazewell, VAThe glider pilot was participating in a cross-country contest. As he was passing one of the turn points, he maneuvered to photograph the position. During this time, he went too low and was forced into making an emergency landing. While maneuvering to land, he…NTSB LAX82DA324Accident · No injuriesFinal reportBell 206B · Colorado City, AZThe pilot was demonstrating an autorotation to a company offical. During the flare, when power was applied, the engine did not respond and a hard landing was made. The bendix fuel control was found to be out of limits at certain test points.NTSB SEA82DA115Accident · Minor injuriesFinal reportGrumman AA-5A · Toketee, ORThe pilot calculated the weight of his aircraft to be 90 pounds below the maximum gross weight. The airport density altitude was calculated to be approximately 5000 feet. The pilot stated that after takeoff the aircraft achieved an altitude of 50 to 100 feet…NTSB SEA82FYP08Accident · Serious injuriesFinal reportLark IS28B2 · Springdale, WAThe pilot received an aerial tow to 5000 feet and was able to find lifting currents for approximately 1.5 hours. Unable to obtain adequate lift the pilot decided to attempt an off airport landing on a dirt road crossing a wheat field. At an altitude of…NTSB FTW82FRA24Accident · Serious injuriesFinal reportBlanik L-13 · Katy, TXThe pilot rented the glider after a flight check-out was completed and was given an aerial tow to an altitude of approximately 2000 feet. According to the passenger, the pilot became disoriented and lost sight of the airport. Unable to find any lifting…NTSB FTW82FPG11Accident · 1 fatalFinal reportMoore Bell 47D1 · Amagon, ARThe purpose of the flight was to test the aerial spray equipment. After starting and warming the engine, the pilot took off, flew about 1/4 mi south, then flew north. A motorist stated that he saw black smoke coming from the helicopter. Two teen-agers heard…NTSB DEN82DA022Accident · No injuriesFinal reportBell/Textron 206 L-1 · 36 Sw Laramie, WYAfter a precautionary landing on a road due to snow, wind and reduced visibility the pilot tookoff when he decided conditions had improved. Shortly after takeoff the visibility worsened and during the execution of a 180 degree turn the pilot stated the engine…