NTSB investigations, 1993
25 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 62 |
|---|---|
| 1983 | 41 |
| 1984 | 42 |
| 1985 | 27 |
| 1986 | 31 |
| 1987 | 25 |
| 1988 | 20 |
| 1989 | 29 |
| 1990 | 25 |
| 1991 | 29 |
| 1992 | 29 |
| 1993 | 25 |
| 1994 | 31 |
| 1995 | 29 |
| 1996 | 24 |
| 1997 | 17 |
| 1998 | 24 |
| 1999 | 16 |
| 2000 | 28 |
| 2001 | 23 |
| 2002 | 22 |
| 2003 | 13 |
| 2004 | 11 |
| 2005 | 11 |
| 2006 | 12 |
| 2007 | 19 |
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\") = 1993
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\" = 300)
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") = 1993 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" = 300) 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 SEA94LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Cheyenne, WYThe pilot's poor in flight decision. Factors include high winds, gusts, and the pilot's lack of total experience operating in high wind conditions.NTSB SEA94LA025Accident · No injuriesLimited investigationFinal reportCessna T210F · Sheridan, WYThe pilot did not obtain proper assistance after landing in high wing conditions. Factors contributing to the accident were the strong, gusty wind conditions.NTSB SEA94LA006Accident · No injuriesLimited investigationFinal reportCessna 177A · La Sal, UTThe pilot in command's failure to abort the takeoff. Factors contributing to the accident were the high (10,000 foot) density altitude and the fence.NTSB SEA93LA203Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Recluse, WYThe brake system locked for undetermined reasons.NTSB LAX93LA344Accident · No injuriesLimited investigationFinal reportCessna 182A · Potrero, CAThe overload failure of the upper nose gear torque link and the subsequent separation of the nose wheel and fork assembly from the nose gear strut. A factor in the accident was the surface irregularity in the dirt landing strip.NTSB ANC93LA169Accident · No injuriesLimited investigationFinal reportCessna 180 · Sweet Lucy Lake, AKThe pilot in command's improper preflight planning and decision making. A factor in the accident was the high wind conditions.NTSB ANC93LA141Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bernard Glacier, AKImproper planning/decision by the pilot, concerning the landing at the remote strip, which resulted in a nose over, while using heavy brakes to stop. A factor related to the accident was: the rough/uneven condition of the landing strip.NTSB ANC93LA135Accident · No injuriesLimited investigationFinal reportLuscombe SL8 · Dillingham, AKThe pilot-in-command's selection of unsuitable terrain for landing. A factor was the soft terrain.NTSB ATL93LA141Accident · No injuriesLimited investigationFinal reportCessna 150F · Wilmington, NCA hidden soft spot on the runway that resulted in a nose over of the airplane during a landing roll.NTSB CHI93LA263Accident · No injuriesLimited investigationFinal reportGrumman G164B · Wyndmere, NDthe pilot's decision to land on unsuitable terrain. Factors in the accident are the wet and soft turf runway.NTSB ANC93LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Uganik River, AKPilot in commands failure to compensate adequately for shifting wind conditions and his selection of unsuitable terrain on which to land. A factor in the accident was the rough uneven terrain landing strip.NTSB ANC93LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe pilot in command selected unsuitable terrain on which to land on. A factor in the accident was the rough/uneven, soft terrain.NTSB FTW93LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dumas, ARThe pilot's inadequate compensation for wind conditions.NTSB ANC93LA082Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Skwentna, AKThe pilot in command not maintaining directional control of the airplane. A factor in the accident was the gusty wind condition.NTSB CHI93FA180Accident · 1 fatalField investigationFinal reportBeech C-18S · North Branch, MNexcessive use of brakes by the pilot-in-command.NTSB ATL93LA094Accident · No injuriesLimited investigationFinal reportBellanca GC-BC · Panama City, FLThe failure of the pilot to maintain control of the aircraft and his poor inflight decision to attempt a downwind landing at the 975 foot airfield. A factor was the tail wind condition which existed at the airfield at the timeNTSB ANC93LA063Accident · No injuriesLimited investigationFinal reportCessna 206 · Deadhorse, AKThe pilot's poor judgment in attempting to land under the existing high wind condition.NTSB CHI93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot's selection of unsuitable terrain on which to land and his excessive use of brakes.NTSB MIA93LA108Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Lakeland, FLThe excessive application of brakes during the landing roll by the PIC. Contributing to the accident was his diverted attention while observing a flagman near the runway.NTSB NYC93LA083Accident · No injuriesLimited investigationFinal reportRobinson R22B · Ronkonkoma, NYThe lack of adequate supervision and delayed remedial action by the flight instructor. A factor related to the accident was the delay in adding power by the student pilot which resulted in a low rotor RPM condition.NTSB LAX93LA156Accident · No injuriesLimited investigationFinal reportCessna 182F · Chandler, AZThe pilot's inadequate weather evaluation resulting in an inadvertent encounter with gusty wind conditions while taxiing.NTSB BFO93LA037Accident · No injuriesLimited investigationFinal reportCessna 182Q · Gettysburg, PAThe pilot's inadequate in-flight decision to land on the snow covered runway that was not currently maintained. Contributing to the pilot's decision was the inadequate report of the runway's condition.NTSB CHI93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-12 · White Bear Lake, MNThe pilot selected unsuitable terrain for landing. The snow covered runway was a factor.NTSB SEA93LA065Accident · No injuriesLimited investigationFinal reportCessna 182C · Huntington, UTThe improper in flt decision by the pilot in command to land on an airstrip unsuitable for landing. A factor relating to the accident was the soft snow covering the airstrip.NTSB SEA93GA049Accident · No injuriesFinal reportPiper PA-18-135 · Council, IDThe pilot's failure to maintain proper altitude during the low pass. The snow covered terrain and the pilot's inadequate preflight preparation were factors.