NTSB investigations, 1991
13 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\") = 1991
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") = 1991 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 LAX91LA414Accident · No injuriesLimited investigationFinal reportLet L-13 · Adelanto, CAImproper planning/decision by the pilot. Loss of thermal lift was a related factor.NTSB DEN91LA134Accident · Serious injuriesLimited investigationFinal reportAbernathy LONG-EZ · Raton, NMPhysical impairment of the pilot. Factors were: rough terrain.NTSB SEA91LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ellensburg, WAThe pilot's failure to maintain terrain clearance. Contributing to the accident was the pilot's overconfidence in the aircraft's ability, and flight in a box canyon where remedial action was not possible.NTSB NYC91FA235Accident · 1 fatalField investigationFinal reportPiper PA38-112 · Akron, OHThe pilot lost control of the airplane and inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Factors related to the accident were; the pilot's improper preflight and planning, which resulted in fuel exhaustion, a loss of…NTSB CHI91LA283Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Burlington, WIThe pilot's exceeding the airplane's licensed gross weight and the pilot's improper preflight planning and preparation.NTSB DEN91FA111Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Colorado Spring, COThe pilot exceeded weight and balance limitations. Factors were: high density altitude and unsuitable terrain.NTSB LAX91LA346Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 126E · Sutcliffe, NVThe pilot's inadvertent stall of the glider.NTSB SEA91LA192Accident · No injuriesLimited investigationFinal reportCessna 172M · Little Rock, WAA delayed go-around, and airspeed not being maintained. Factors include the pilot's overconfidence in the aircraft's ability, the pilot's lack of total experience in this type of operation, misjudged clearance, and the use of improper procedure.NTSB DEN91LA096Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Colorado Spring, COThe pilot attempting to operate the helicopter outside the design operating envelope. Factors were: high altitude, high temperature, and high density altitude.NTSB DEN91FA083Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus C · Durango, COThe absence of thermal lift, the pilot's apprehension, and his lack of familiarity with the geographic area.NTSB DEN91FA072Accident · Serious injuriesField investigationFinal reportBeech C23 · Boulder, COInadvertent stall/mush due to the passengers's delay in relinquishing aircraft control, and inadequate supervision of the flight by the pilot in command. Factors were: mixture not leaned, and a high density altitude takeoff with a slight quartering tailwind.NTSB FTW91DPG04Accident · No injuriesFinal reportGrumman G-164B · Vanndale, ARThe pilot's failure to verify his weight and balance. A factor was the soft terrain.NTSB ATL91LA053Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Grantham, NCThe pilot's improper planning/decision, and his attempt to fly the aircraft while it was loaded over its maximum allowable gross weight.