NTSB investigations, 1994
31 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\") = 1994
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") = 1994 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 CHI95LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion Citabria 7-GCBC · Ulysses, KSthe pilots improper use of brakes during practice landings, and his lack of total experience in tail wheel equipped airplanes.NTSB ANC95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's selection of unsuitable terrain for landing/taxi. Factors associated with the accident were the soft and snow covered terrain.NTSB ANC95LA007Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of unsuitable terrain for landing. Snow covered terrain in the landing area was a factor in the accident.NTSB CHI95LA010Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Mt. Horeb, WIthe pilot's excessive braking while taxiing from landing.NTSB FTW94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Galena, AKThe pilot's excessive use of brakes during landing. A factor was the unfavorable winds at the remote landing area.NTSB FTW94LA307Accident · No injuriesLimited investigationFinal reportCessna 140 · Nenana, AKThe pilot's excessive use of the brakes during the aborted takeoff.NTSB LAX94LA343Accident · No injuriesLimited investigationFinal reportCessna 195 · Palo Alto, CAthe pilot's improper use of the airplane's brakes during the landing rollout.NTSB ANC94LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selecting a gravel bar for a normal landing. A factor was the soft spot in the gravel bar.NTSB SEA94LA222Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Caldwell, IDThe jamming of the right main landing gear brake due to an accumulation of a gummy deposit.NTSB SEA94LA224Accident · No injuriesLimited investigationFinal reportCessna 206 · Bliss, IDThe pilot's failure to maintain directional control. Factors include sunglare from the setting sun, and the soft terrain along the side the runway.NTSB LAX94LA328Accident · No injuriesLimited investigationFinal reportCessna 180 · Sedona, AZthe pilot's inadvertant application of wheel brakes during a critical phase of landing rollout.NTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.NTSB CHI94LA278Accident · No injuriesLimited investigationFinal reportCessna 120 · Manitowoc, WIthe private pilot's improper use of brakes during the landing roll. A related factor is his lack of total experience.NTSB ATL94LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vanceboro, NCThe pilot's improper use of wheel brakes.NTSB ANC94LA092Accident · No injuriesLimited investigationFinal reportCessna A185F · Anchorage, AKThe pilot misjudged the landing flare. A factor in the accident was the glassy water.NTSB LAX94LA294Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Ligurta, AZThe pilot's failure to assure the suitability of the landing area prior to the flight. The dark night and the badger hole were factors in the accident.NTSB ATL94LA145Accident · No injuriesLimited investigationFinal reportChampion 7-GCBC · Hartford, ALThe pilot's improper use of the wheel brakes.NTSB ANC94LA081Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Newtok, AKThe pilot's selection of unsuitable terrain.NTSB NYC94LA124Accident · No injuriesLimited investigationFinal reportCessna 140 · Mount Vernon, OHThe pilot's inadequate handling which resulted in the airplane nosing over during the takeoff roll.NTSB ANC94LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's excessive use of the wheel brakes.NTSB LAX94LA238Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Valencia, CAthe pilot's selection of an unsuitable field for an off-airport landing and attempted takeoff.NTSB FTW94LA163Accident · No injuriesLimited investigationFinal reportGulfstream G-164C · Weiner, ARThe pilot selected unsuitable terrain for the takeoff.NTSB LAX94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe pilot's improper use of the brakes.NTSB MIA94LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · Crescent City, FLThe pilot's improper descent rate, and the check pilot's inadequate supervision. The glassy water condition was a factor.NTSB LAX94LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beowawe, NVthe pilot's inadvertent application of the brakes combined with excessive forward control pressure during recovery from a bounced landing.NTSB MIA94LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Parkland, FLImproper planning/decision by the director of operations, and failure of the instructor pilot to take adequate remedial action. A factor related to the accident was: the soft/wet runway condition.NTSB CHI94LA118Accident · No injuriesLimited investigationFinal reportCessna TU206B · Canton, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB CHI94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Benton, ILThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the tailwind.NTSB LAX94LA137Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Carlsbad, CAThe pilot's failure to follow the correct procedures when he released the parking brake. The inadvertently engaged parking brake and the outdated flight manual were factors in this accident.NTSB LAX94LA110Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe cfi's inproper supervision of the flight, the dual student's improper recovery from a bounced landing, and the dual student's improper use of the brakes. The cfi's lack of total instructional experience is a factor in this accident.NTSB SEA94LA050Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Burns, ORThe student pilot in command's application of excessive braking during the landing roll.