NTSB investigations, 2005
11 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\") = 2005
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") = 2005 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 ATL06CA017Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAThe pilot's excessive braking resulted in a nose over during landing roll.NTSB DEN05LA142Accident · Serious injuriesLimited investigationFinal reportShea Vans RV6A · Glendo, WYfailure of the nose gear during the landing roll.NTSB CHI05CA215Accident · No injuriesData collectionFinal reportRosner Acro Sport II · Princeton, MNThe airplane nosed over during landing as a result of the pilot's failure to maintain control of the airplane when he applied excessive braking.NTSB LAX05LA245Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Oroville, CAa binding and/or activation of the brakes that lead to an inadvertent nose over. The underlying root cause of the brake binding/activation could not be determined.NTSB NYC05CA124Accident · No injuriesData collectionFinal reportWaco AQC-6 · Leonardtown, MDThe pilot's inadequate compensation for wind and his failure to maintain aircraft control while landing, which resulted in a nose over. A factor in this accident was the crosswind condition.NTSB ANC05CA103Accident · No injuriesData collectionFinal reportCessna 172 · Kenai, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was swampy terrain.NTSB LAX05CA212Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Pine Valley, CAThe pilot's delay in aborting the takeoff and excessive brake application. A contributing factor was the downsloping terrain used for the landing and takeoff.NTSB NYC05CA080Accident · No injuriesData collectionFinal reportPalen Sopwith Camel · Rhinebeck, NYThe pilot's failure to maintain aircraft control during the takeoff roll. A factor in the accident was the uneven runway, and the pilot's lack of total experience in make and model.NTSB ATL05CA060Accident · Minor injuriesData collectionFinal reportSavage RV-8 · Goldsboro, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.NTSB ATL05CA057Accident · No injuriesData collectionFinal reportLuscombe 8A · Lexington, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.NTSB LAX05LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Desert Center, CAThe instructor's improper decision to land on the dry lakebed without knowing the condition of the landing surface. A factor in the accident was the soft sand surface of the lake bed.