NTSB investigations, 1984
6 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\") = 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\" = 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") = 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" = 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 ATL84LA294Accident · No injuriesLimited investigationFinal reportHughes 269B · Saluda, SCThe acft crashed during an attempted practice autorotation after power was applied to effect a recovery. The CFI, on theflt, stated that he noticed that the student was going to overshoot and instructed him to make a power recovery at 100 ft AGL. He said that…NTSB SEA84LA218Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Vegas, NVThe instuctor pilot allowed the aircraft to approach mountainous terrain with insufficient altitude to counter wind conditions, reported at 35 mph. Downdrafts prevented climb to higher altitude before forcing a descent. On touchdown on a road, the left wing…NTSB DEN84LA269Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Price, UTThe pilot was following a mountain road through a pass when aircraft performance became insufficient to out climb risingterrain and continued until there was insufficient manuvering room to reverse course. A forced landing was effected on the road and the…NTSB NYC84LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Perkasie, PAThe sailplane lost lift and during a forced landing wires were spotted on the approach. In attempting to fly under the wires the acft was flown into an embankment.NTSB DEN84LA183Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Zugvogel Iiib · Taos, NMAccording to the plt, the winds increased during a flt in a mountainous area & the thermal updrafts 'broke up.' While gliding back to the arpt, he encountered sinking air & was forced to make an emergency landing on rough, sage brush covered, terrain. This…NTSB ATL84LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Snowville, VAThe acft crash landed in a pasture during a go-around attempt after a demonstration forced landing. The go-around was delayed and the terrain rose faster than the acft ascent rate. Since there was a powerline in the way the CFI elected to land the acft.