NTSB investigations, 2007
19 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\") = 2007
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") = 2007 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 CHI08CA049Accident · No injuriesData collectionFinal reportCessna 172 · Hastings, MIThe student pilot failed to maintain directional control during landing. Factors were the ditch and the icy runway.NTSB ANC08CA022Accident · No injuriesData collectionFinal reportAeronca 7JC · Wasilla, AKThe pilot's excessive application of the airplane's brakes during the landing roll, which resulted in a nose-over.NTSB NYC08CA035Accident · Minor injuriesData collectionFinal reportCessna 180 · Orlando, FLThe pilot's loss of control on the water after landing, which resulted in the bow of the right float submerging , and a nose-over event.NTSB DEN08CA025Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cortez, COThe passenger's inadvertent application of brakes, causing the airplane to nose over on landing. A contributing factor was the pilot's failure top adequately brief the passenger.NTSB LAX08CA015Accident · No injuriesData collectionFinal reportCessna 172N · Daggett, CAThe flight's encounter with a strong gusty wind condition.NTSB ANC08CA001Accident · No injuriesData collectionFinal reportRittal Glastar · Girdwood, AKThe pilot's excessive use of the brakes during the landing roll, which resulted in a nose over.NTSB ANC07TA080Accident · No injuriesFinal reportPiper PA-18 · McGrath, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was rough and uneven terrain conditions.NTSB NYC07CA169Accident · No injuriesData collectionFinal reportCessna 152 · Vero Beach, FLThe student pilot's failure to maintain directional control during landing, resulting in a runway excursion and subsequent nose over.NTSB CHI07CA178Accident · No injuriesData collectionFinal reportAeronca 7EC · Hillsdale, MIThe aircraft control not maintained by the pilot during landing rollout.NTSB NYC07CA127Accident · Minor injuriesData collectionFinal reportWroblewski Searey · Freeport, PAThe pilot's improper flare, which resulted in a nose over while attempting to land on a river. A factor in this accident was the glassy water landing conditions.NTSB LAX07CA166Accident · No injuriesData collectionFinal reportPiper J3C-65 · Quincy, CAThe pilot's excessive use of the brakes, which resulted in a nose over.NTSB CHI07CA122Accident · No injuriesData collectionFinal reportCessna 140 · Winner, SDThe pilot's excessive use of braking during the landing roll, causing the aircraft to nose over.NTSB DFW07CA092Accident · Minor injuriesData collectionFinal reportCessna 182E · Marietta, OKThe airplane noseover due to the pilot's failure to obtain current NOTAM information on the closed airport. A contributing factor was the unsuitable terrain.NTSB MIA07LA075Accident · No injuriesLimited investigationFinal reportCharles C. Gillis Pitts S2S · Zellwood, FLThe pilot's excessive braking during the landing roll.NTSB LAX07CA100Accident · Minor injuriesData collectionFinal reportHirsch Thorp T-18 · San Diego, CAThe pilot's improper bounced landing recovery and improper use of the flight controls that resulted in a porpoise and a nose over.NTSB LAX07CA076Accident · No injuriesData collectionFinal reportCessna 152 · Aptos, CAthe student pilot's becoming lost and disoriented that resulted in an improper in-flight decision to make a precautionary landing in an unsuitable open field.NTSB SEA07CA054Accident · No injuriesData collectionFinal reportCessna 140 · Murrieta, CAThe pilot's excessive application of brakes during taxi after landing, resulting in a nose over.NTSB SEA07CA047Accident · No injuriesData collectionFinal reportCessna 140 · San Jose, CAThe pilot's excessive use of the airplane's wheel brakes, which resulted in a nose over during landing.NTSB SEA07CA045Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Maricopa, AZThe excessive brake application during landing which resulted in a nose over.