NTSB investigations, 1992
27 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 68 |
|---|---|
| 1983 | 54 |
| 1984 | 45 |
| 1985 | 57 |
| 1986 | 34 |
| 1987 | 46 |
| 1988 | 30 |
| 1989 | 40 |
| 1990 | 37 |
| 1991 | 31 |
| 1992 | 27 |
| 1993 | 34 |
| 1994 | 35 |
| 1995 | 45 |
| 1996 | 38 |
| 1997 | 33 |
| 1998 | 46 |
| 1999 | 40 |
| 2000 | 33 |
| 2001 | 35 |
| 2002 | 44 |
| 2003 | 33 |
| 2004 | 44 |
| 2005 | 47 |
| 2006 | 33 |
| 2007 | 39 |
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\") = 1992
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\" = 320)
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") = 1992 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" = 320) 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 LAX93LA073Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Long Beach, CAA failure of the dual student (second pilot) to properly perform the touch down, and properly assess the terrain at the point of touch down, of an intentional autorotation. Contributing to the accident was a failure of the flight instructor (first pilot) to…NTSB NYC93LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Danbury, CTThe pilot misjudged the clearance between two snow banks, striking one of the snow banks with the airplane's right wing.NTSB NYC93LA032Accident · Minor injuriesLimited investigationFinal reportLet LF-13 · Readington, NJThe pilot's poorly planned approach for landing which resulted in an off airport landing in unsuitable terrain.NTSB ATL93LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Knoxville, TNThe pilots poor inflight decision to attempt to land the aircraft in an unsuitable area.NTSB DEN92LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Craig, COThe pilot's failure to maintain directional control.NTSB CHI92LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, MIThe pilot's inadequate planning and decision-making.NTSB ANC92LA180Accident · No injuriesLimited investigationFinal reportChampion 7AC · Homer, AKThe pilot in commands inflight planning/decision in selecting unsuitable terrain. A factor relating to the accident was the ditch.NTSB ANC92LA169Accident · No injuriesLimited investigationFinal reportCessna 206 · Chena Marina, AKPilot in commands's poor preflight planning/preparation. Factors contributing to the accident were: lack of understanding of aircraft takeoff performance, lack of recency of PIC experience in type of operation, loss of aircraft performance takeoff…NTSB ANC92LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Seldovia, AKThe failure of the pilot to perform a go around when a tail wind was encountered prior to touch down. Factors related to the accident were: the tailwind and the downdraft.NTSB CHI92LA268Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Harvard, ILFailure of the pilot in command to align the accident airplane with the centerline of the runway during landing.NTSB CHI92LA242Accident · No injuriesLimited investigationFinal reportCessna 182R · Litchfield, MIThe pilot-in-command's failure to use all available runway and his not aborting the takeoff when the wing contacted the corn. A factor was the corn along side the runway.NTSB LAX92LA340Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tolleson, AZThe pilot's selection of unsuitable terrain for takeoff. Contributing to this accident was the ravine that crossed the runway.NTSB ATL92IA151Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Los Angeles, CAThe pilot in command's improper use of the aircraft flight controls (elevator) during the landing, which resulted in the aircraft tail contacting the runway surface.NTSB SEA92LA146Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melstone, MTInadequate in flight planning/decision. Factors to the accident were: unsuitable terrain was selected, rough/uneven terrain and a go around was not performed.NTSB ANC92LA102Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's failure to maintain directional control. Factors include gusty crosswind conditions.NTSB LAX92LA259Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe failure of the pilot to maintain an adequate wing tip clearance between the aircraft and a dirt bank paralleling the airstrip.NTSB LAX92LA256Accident · No injuriesLimited investigationFinal reportLake 200 · Clearlake, CAThe pilot's inadequate weather evaluation of the wind on the Lake and his delay in lift-off. Contributing to the accident was the rough water that existed on the unsheltered section of the Lake.NTSB ANC92LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Old Minto, AKThe pilot's selection of unsuitable terrain. A factor relating to the accident was the ditch in the landing area.NTSB FTW92LA128Accident · No injuriesLimited investigationFinal reportForney F-1 · Mason, TXThe pilot's delay in proceeding to a suitable alternate when his fuel state became questionable and his subsequent loss of control during the off airport precautionary landing. A factor was the gusty wind conditions on landing.NTSB ATL92LA097Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Cartersville, GAThe pilot's failure to operate the flight controls properly during the takeoff attempt and the pilot's planning decision during rollout.NTSB FTW92LA119Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brinkley, ARThe pilot's failure to achieve proper airstrip alignment for landing, and the resultant loss of directional control.NTSB ANC92LA059Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Mccarthy, AKThe pilot's failure to maintain directional control of the airplane. Contributing to the accident were the snow berm and the pilot's lack of total experience in the type of operation (ski equipped airplanes).NTSB CHI92LA125Accident · No injuriesLimited investigationFinal reportBeech K35 · Valley City, NDFailure by airport personnel to remove the snow ridge.NTSB BFO92LA039Accident · No injuriesLimited investigationFinal reportLet L-13 · Lock Haven, PAA tow rope that broke at low altitude.NTSB MIA92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kissimmee, FLThe pilot-in-command's failure to attain the proper touchdown point due to landing before the displaced threshold on the rwy.NTSB CHI92LA076Accident · No injuriesLimited investigationFinal reportCessna 414 · Gaylord, MIDirectional control was not maintained by the pilot. Factors related to the accident were: airport snow removal had not been performed by the airport personnel, a dark night with falling snow and the snowbank on the runway.NTSB BFO92FA020Accident · Serious injuriesField investigationFinal reportDouglas DC-9-30 · Horseheads, NYThe aircraft encountered a sudden wind gust during landing flare, which resulted in a hard landing.