NTSB investigations, 1983
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\") = 1983
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") = 1983 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 NYC84LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Eppingham, NHThe pilot stated that while enroute to north conway, NH with about 10 gal. Of fuel on board he had to alter course to the southeast to find a hole to drop under clouds and avoid the mountains. He could not identify and land marks and lost contact with the…NTSB ANC83LA142Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Palmer, AKThe acft crashed during a go-around attempt to a mountain airstrip at 4000 ft MSL. According to the plt he thought his approach was too flat so he initiated a go-around at low alt and with 60 KTS indicated airspeed. The acft would not outclimb the rising…NTSB FTW83LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft collided with a ditch during a forced landing. This was an instructional flt and the CFI gave the student a simulated forced landing. During the attempted go-around the engine reportedly developed only 1800 RPM and a landing wasmade in a field by the…NTSB NYC83LA190Accident · No injuriesLimited investigationFinal reportLet L-13 · Fredericksburg, PAAfter lift-off from a tow takeoff, the towplane was unable to attain the normal tow airspeed of 65 to 75 mph & continuedat about 55 mph. The glider plt thought the towplane was having engine problems, & as the two acft circled the arpt, theglider plt released…NTSB DEN83LA175Accident · No injuriesLimited investigationFinal reportCessna U206E · Bryce Canyon, UTThe pilot said that while enroute to albuquerque from las vegas he encountered deteriorating weather that he could not get around he tried to climb over it but was unable. Once clear of cloud he descended trying to get back to Bryce Canyon. As the ceiling…NTSB ATL83LA259Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Cirrus · Damascus, MDThe glider collided with a fence during an off arpt forced landing. The plt stated that she did not see the power lines until she was on the final approach. She maneuvered the glider to miss the powerlines but was unable to miss the fence and landed short.…NTSB FTW83LA340Accident · No injuriesLimited investigationFinal reportCessna 152 · Belton, TXThe acft collided with powerlines during a simulated forced landing. The CFI stated that the student was high on approach so he took over to demonstrate a slip. The CFI and student had observed 3 sets of powerlines but failed to see a 4th set of lines.NTSB LAX83LA280Accident · No injuriesLimited investigationFinal reportLet L-13 · Maricopa, AZThe sailplane collided with a small tree and groundlooped during a precautionary landing. The pilot stated the acft had encountered a high sink rate while gliding at 5000 ft. a ridge was between the pilot and the intended route. The pilot elected to land…NTSB LAX83IA257Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Luke Afb, AZWhile descending through 31,600 ft the master caution & the right 'inlet fuel pressure low' lights illuminated. The fuelquantity transfer circuit breaker was found tripped, & when reset the fuel quantity gauges went to zero. An emergency was declared to…NTSB SEA83LA053Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Winthrop, WAThe aircraft was crash-landed in the snow after the pilot flew into a box canyon. The pilot was following a highway oversnow covered terrain and took a wrong turn. By the time the error was realized, it was too late to reverse course or climb out. A forced…NTSB MIA83LA061Accident · No injuriesLimited investigationFinal reportCessna 182D · Near Telogia, FLThe acft collided with a tree during an off airport precautionary landing. The student pilot was practicing a cross country on a day with questionable weather. The clouds were 1000 feet broken 2500 feet overcast at tallahassee which is 30 miles ene of the…