NTSB investigations, 1997
17 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\") = 1997
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") = 1997 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 NYC98LA054Accident · Minor injuriesLimited investigationFinal reportMayers SEA REY · Gloucester, VAThe pilot's failure to maintain aircraft control during landing, which resulted in a nose over.NTSB LAX98LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Grass Valley, CAthe pilot's inadvertent activation of the aircraft brakes during the landing rollout.NTSB FTW98LA040Accident · No injuriesLimited investigationFinal reportCessna 172G · Elk City, OKThe high winds and the pilot's poor judgment in attempting to taxi in the existing wind conditions.NTSB FTW98LA029Accident · No injuriesLimited investigationFinal reportCessna 185C · Farmington, NMthe pilot's improper preflight of the airplane, by failing to properly set the elevator trim for takeoff, and his improper use use of the elevator flight controls. A related factor was: the pilot's lack of recent experience in the make and model of airplane.NTSB SEA98LA034Accident · No injuriesLimited investigationFinal reportCessna U-206E · Friday Harbor, WAthe pilot's failure to park with the aircraft headed into the wind in high wind conditions. A factor include the high wind condition.NTSB FTW98LA002Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Iberia, LAimproper touchdown by the flight instructor. A related factor was: soft sod in the touchdown/landing area.NTSB ATL97LA146Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay-Varina, NCThe pilot's misjudged flare, improper level-off, and improper recovery from a bounced landing.NTSB ANC97LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKbinding or braking action of the left brake for undetermined reason(s).NTSB FTW97LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Arriba, COfailure of the pilot to properly plan the flight and determine the field conditions before landing. The soft runway condition was a related factor.NTSB ANC97LA116Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Ashton, AKThe pilot's selection of unsuitable terrain. Factors associated with the accident were the tailwind and soft terrain.NTSB FTW97LA283Accident · No injuriesLimited investigationFinal reportWonder RV-6 · Franktown, COthe pilot's failure to maintain control of the aircraft during landing roll. A factor was the uneven runway surface.NTSB SEA97LA134Accident · No injuriesLimited investigationFinal reportCessna 172C · Fall City, WAthe pilot's selection of unsuitable terrain for landing. The soft, wet terrain was a related factor.NTSB SEA97LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Deer Lodge, MTThe pilot's improper decision to abort the takeoff, and his improper use of brakes during the abort. A factor contributing to the accident was the pilot's failure to maintain directional control during the takeoff roll.NTSB CHI97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILthe pilot-in-command's inadequate compensation for the wind conditions. A factor associated with the accident was the gusty crosswind condition.NTSB CHI97LA113Accident · No injuriesLimited investigationFinal reportCessna 185 · Pella, IAthe pilot's selection of an unsuitable area for the landing. A factor relating to the accident was: the soft landing surface of the farm strip.NTSB SEA97LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAthe pilots' inadequate evaluation of the strong winds, when they attempted to turn to taxi with a very strong tailwind. Factors relating to the accident included the high and unfavorable winds.NTSB SEA97LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Toledo, WAThe pilot's excessive application of the brakes on a tailwheel equipped aircraft. Factors include the pilot's inadequate compensation for wind conditions, and a crosswind blowing at the time of the landing.