NTSB investigations, 1991
29 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\") = 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\" = 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") = 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" = 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 SEA92LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Stanley, IDThe pilot-in-command's selection of unsuitable terrain (snow covered runway) for landing resulting in a nose over on landing rollout.NTSB LAX92LA072Accident · No injuriesLimited investigationFinal reportCessna 172K · Kamuela, HIThe pilots encounter with a wind gust beyond the ground handling capability of the aircraft and his failure to obtain preflight weather information.NTSB SEA92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Ocean Shores, WAThe pilot's misjudgement of wind information. A factor contributing to the accident was high wind conditions.NTSB SEA92LA008Accident · No injuriesLimited investigationFinal reportMcholland XPA-11 · Sandpoint, IDA poor in-flight decision. Contributing to the accident was the rough/uneven terrain.NTSB ANC92LA004Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe student pilot's failure to maintain directional control during the takeoff run.NTSB ATL91LA174Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilsonville, ALThe pilot's inadequate preflight planning, and his improper use of flaps during the takeoff roll. Factors in the accident were: the high density altitude, the rising runway conditions, and the departure end obstructions at the airstrip.NTSB SEA91LA232Accident · No injuriesLimited investigationFinal reportCessna 140 · Gates, ORThe student pilot's excessive remedial action. Factors to the accident were poor supervision by the CFI.NTSB SEA91LA244Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Metaline Falls, WAThe pilot's inadvertent use of the parking brake. A factor contributing to the accident was the absence of the parking brake on the landing checklist.NTSB MIA91LA215Accident · No injuriesLimited investigationFinal reportBell 47G2A · Immokalee, FLThe improper use of the flight controls by the pilot in command, which resulted in a collision with the ground and a nose over.NTSB CHI91LA288Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Afton, MNThe pilot's inadvertent lowering of the wheels during the water landing.NTSB ANC91LA139Accident · No injuriesLimited investigationFinal reportCessna 206 · Kelly River, AKThe pilot's inadequate judgment in deciding to land a tricycle gear airplane on a sandbar.NTSB NYC91LA216Accident · No injuriesLimited investigationFinal reportCessna TU206G · Block Island, RIImproper planning/decision by the pilot by electing to takeoff with a known deficiency with the equipment. The deficiency (cracked/leaking float) was a related factor.NTSB ATL91LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Jenkinsburg, GAThe separation of the nose wheel, during the landing roll, for undetermined reasons.NTSB LAX91LA299Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crows Landing, CAThe pilot Landing his airplane erroneously on the wrong Landing surface. Factors in this accident were: sunglare and its interference with the pilot's vision and the soft terrain.NTSB BFO91LA066Accident · No injuriesLimited investigationFinal reportCessna 175B · Farmington, MDAn aborted takeoff due to the pilot's reported binding of the elevator.NTSB ANC91LA083Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Louise, AKThe pilot not maintaining directional control during the takeoff roll. Contributing to the accident was the rough condition of the airstrip.NTSB SEA91LA140Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newcastle, WYThe fracture failure of the landing gear axle.NTSB LAX91LA271Accident · No injuriesLimited investigationFinal reportClassic YMF · Bullhead City, AZExcessive brake application by the pilot in command. A contributing factor in the accident was the wind gusts.NTSB CHI91LA187Accident · No injuriesLimited investigationFinal reportGrumman American AA1C · Lansing, KSThe pilot became lost/disoriented and attempted a precautionary landing. Factors related to the accident were a low level of fuel and soft terrain (wheat field crop).NTSB ANC91LA070Accident · No injuriesLimited investigationFinal reportCessna 180 · Near Iliamna, AKThe pilot's decision to land on an unimproved area. The soft terrain was a related factor.NTSB ANC91LA069Accident · No injuriesLimited investigationFinal reportCessna 206 · Kahiltna River, AKThe pilot's excessive descent and lack of familiarity with the aircraft. Contributing to the accident was the soft condition of the sand bar.NTSB ANC91LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Cantwell, AKThe pilot in command's poor preflight planning/preparation. A factor in the accident was the snow covered runway.NTSB CHI91LA132Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fibre, MIThe pilot attempting to taxi on unsuitable terrain.NTSB BFO91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Morehead, KYThe pilot's operation of his aircraft in exceedingly high wind conditions.NTSB ATL91LA079Accident · No injuriesLimited investigationFinal reportCessna 120 · Pinebluff, NCThe pilot's delay in aborting the takeoff. The pilot's failure to calculate the aircraft's performance for the existing conditions was a factor related to the accident.NTSB ANC91LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's lack of currency with the type of landing gear involved.NTSB LAX91LA153Accident · No injuriesLimited investigationFinal reportPiper J3 · Arbuckle, CAThat the pilot used excessive brakes during the landing roll-out.NTSB LAX91LA119Accident · No injuriesLimited investigationFinal reportCessna 172G · Reno, NVThe pilot's improper planning/preparation decision. Factors related to the accident were the high wind condition and the pilot in commands inability to compensate for the wind condition.NTSB CHI91LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ashland, NEThe pilot's failure to maintain clearance above the terrain. Factors related to the accident were the low pass and ostentatious display.