NTSB investigations, CA
58 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 3 |
| 1984 | 7 |
| 1986 | 3 |
| 1989 | 5 |
| 1990 | 4 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 3 |
| 2007 | 6 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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 LAX08CA015Accident · No injuriesData collectionFinal reportCessna 172N · Daggett, CAThe flight's encounter with a strong gusty wind condition.NTSB LAX07CA166Accident · No injuriesData collectionFinal reportPiper J3C-65 · Quincy, CAThe pilot's excessive use of the brakes, which resulted in a nose over.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 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 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 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.NTSB LAX03LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Twentynine Palm, CAThe pilot's inadequate compensation and his failure to maintain aircraft control. The gusty wind condition was a contributing factor.NTSB LAX02LA260Accident · No injuriesLimited investigationFinal reportCessna 195 · Willows, CAthe pilot's inadequate compensation for crosswind conditions resulting in his failure to maintain runway alignment. Contributing factors to the accident were the pilot's lack of familiarity with the airplane.NTSB LAX01LA132Accident · No injuriesLimited investigationFinal reportCessna 170B · Lincoln, CAThe certified flight instructor's inadequate supervision of his dual student who used excessive braking on landing resulting in the airplane's nose over.NTSB LAX01LA010Accident · No injuriesLimited investigationFinal reportCessna 170B · San Carlos, CAThe pilot's improper and excessive application of brakes resulting from his failure to maintain directional control during landing rollout.NTSB LAX00LA059Accident · Minor injuriesLimited investigationFinal reportQuest II Walsh Aventura II · Antioch, CAThe pilot's inattention to the fact that he had failed to retract the landing gear wheels prior to performing a water landing.NTSB LAX99LA169Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lancaster, CAThe pilot's decision to attempt a ground turning maneuver in wind conditions beyond the capability of the aircraft.NTSB LAX99TA043Accident · No injuriesFinal reportPiper PA-18-150 · Imperial, CAThe pilot's inadequate compensation for the gusty wind conditions while taxiing from landing.NTSB LAX98LA213Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Redding, CAThe pilot's excessive use of the brakes while taxiing, allowing the aircraft to 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 LAX96LA243Accident · No injuriesLimited investigationFinal reportMini Ace CA61-F · Byron, CAThe pilot's encounter with a sudden crosswind gust beyond the capabilities of the aircraft.NTSB LAX96LA225Accident · No injuriesLimited investigationFinal reportCessna 150H · Angels Camp, CAThe attempt by the pilot to operate the aircraft with a float known to be leaking. A factor was the pilot's lack of experience in the operation of float equipped aircraft.NTSB LAX96LA070Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAthe pilot was given an erroneous wind velocity due to a malfunctioning wind gauge in the control tower. Factors relating to the accident were: the high/gusty wind conditions, and the pilot's improper evaluation of the actual wind condition.NTSB LAX95LA166Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Chino, CAfailure of the attachment link for the master cylinder return spring, which allowed the left brake to lock.NTSB LAX95LA071Accident · No injuriesLimited investigationFinal reportCessna 175 · Davis, CAthe failure of the pilot to maintain directional control of the aircraft while on the rollout phase of landing on a dirt road. A factor in the accident was the pilot's intentional selection of the road as a landing site.NTSB LAX94LA343Accident · No injuriesLimited investigationFinal reportCessna 195 · Palo Alto, CAthe pilot's improper use of the airplane's brakes during the landing rollout.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 LAX94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe pilot's improper use of the brakes.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 LAX93LA344Accident · No injuriesLimited investigationFinal reportCessna 182A · Potrero, CAThe overload failure of the upper nose gear torque link and the subsequent separation of the nose wheel and fork assembly from the nose gear strut. A factor in the accident was the surface irregularity in the dirt landing strip.NTSB LAX93LA034Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot's improper use of the brakes.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 LAX91LA153Accident · No injuriesLimited investigationFinal reportPiper J3 · Arbuckle, CAThat the pilot used excessive brakes during the landing roll-out.NTSB LAX90DVG03Accident · Serious injuriesFinal reportSmyth Sidewinder Smyth · Georgetown, CAThe failure of the pilot to abort his landing and execute a go-around.NTSB LAX90LA103Accident · No injuriesLimited investigationFinal reportPitts S1T · Ramona, CAThe pilots loss of directional control during landing.NTSB LAX90DUG03Accident · No injuriesFinal reportGroves Cougar · Banning, CAPilot's improper wind evaluation and improper aircraft handling after landing. The tailwind and wind gusts were factors relating to the accident.NTSB LAX90LA064Accident · No injuriesLimited investigationFinal reportCessna 185 · Agua Dulce, CAPilot's improper weather evaluation which directly led to his attempted takeoff in an excessive tailwind and subsequent loss of aircraft control during the unsuccessful abort.NTSB LAX90LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Concord, CAImproper use of the brakes by the pilot. The crosswind and the pilot's failure to maintain runway alignment were contributing factors.NTSB LAX89LA206Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Big Sur, CAThe pilot elected to attempt a takeoff from a field that he had previously made a forced landing to and the airplane nosed over during the attempt. Contributing to the accident was the high grass that became entangled in the tailwheel and the soft downhill…NTSB LAX89DVG06Accident · No injuriesFinal reportGrumman G-164B · Davis, CAThe pilot failed to properly use his brakes during the off airport landing.NTSB LAX89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lancaster, CAImproper planning/decision by the pilot. Strong/gusty winds contributed to the accident.NTSB LAX89DVG03Accident · Minor injuriesFinal reportEaa WAG-AERO Sport · Placerville, CAThe student's improper application of brakes during the touchdown/flare phase of the landing causing the aircraft to nose over.NTSB LAX86LA300Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · San Jose, CAThe plt applied the brakes heavily during the landing roll. As the aircraft slowed to approximately 5 mph it nosed over on its back.NTSB LAX86LA301Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Pleasant Grove, CAThe pilot said the aircraft had new brakes installed prior to the flight. After touchdown at the conclusion of a local flight, the pilot said he 'applied too much pressure to the pedals and could not release the pressure in time to prevent the aircraft from…NTSB LAX86LA100Accident · Minor injuriesLimited investigationFinal reportErcoupe E · Apple Valley, CAThe plt stated that the acft's eng lost power and the acft flipped over during an attempted forced landing on a dirt road in front of his residence. A witness stated that the acft made three low passes over the dirt road prior to touchdown. A witness…NTSB LAX85LA087Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe plt landed normally & taxied off the rwy. The acft encountered a gust of wind & nosed over. Winds were reported as 300 deg at 20 KTS gusting to 25 KTS.NTSB LAX85FA050Accident · No injuriesField investigationFinal reportCessna 305A · Los Alamitos, CAThe acft nosed over during landing roll. Plt stated he had just completed a glider tow mission and that on touchdown the tail wheel began to shimmy excessively. The acft lifted off and settled back on the rwy, at which time the tail wheel shimmy became worse…NTSB LAX85LA022Accident · No injuriesLimited investigationFinal reportCessna 180 · Santa Monica, CAPlt reproted, descent made to mda of 740 ft MSL and visual contact made with rwy 1/2 mile east of arpt. Slipped acft to within 200 ft of rwy and made a wheel landing midfield. Both wheels locked up and acft nosed over. Plt stated, 'I may have had my feet on…NTSB LAX84LA468Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Van Nuys, CADuring the third touch & go landing the certificated plt receiving dual instruction was at the controls when directional control was temporarily lost. The CFI in the front cockpit regained control. Shortly thereafter the plt under instruction applied heavy…NTSB LAX84LA352Accident · No injuriesLimited investigationFinal reportCessna T210 · California City, CAThe plt felt a vibration as he circled a lake bed, so he decided to make a precautionary landing. During the landing, the nose gear dug into a soft spot and the acft nosed over.NTSB LAX84LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Arbuckle, CAThe ldg was made on an ag airstrip with a right quartering tailwind. Upon touchdown, the plt 'felt what appeared to be either a dragging left brake and/or the rough surface' of the landing strip. The landing was aborted. On the next landing, the acft nosed…