NTSB investigations, CA

179 cases where the sequence of events included Nose over/nose down.

Cases, newest first

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB WPR15CA207Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Carlsbad, CAThe pilot's failure to manage the fuel system properly during a banner tow operation resulting in a loss of engine power due to fuel starvation.Jul 4, 2015 · N8075P · Substantial damageNTSB GAA15CA113Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Bakersfield, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with terrain.Jun 9, 2015 · N8372 · Substantial damageNTSB WPR15CA100Accident · Minor injuriesData collectionFinal reportCessna U206 - G · Kernville, CAThe pilot's inadequate flare and failure to maintain airplane control during the landing with a tailwind which resulted in a bounce, long landing, and subsequent runway excursion.Feb 9, 2015 · CFGQQ · Substantial damageNTSB WPR15LA085Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · San Luis Obispo, CAThe pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…Jan 16, 2015 · N232LT · Substantial damageNTSB WPR15CA074Accident · No injuriesData collectionFinal reportWaco Classic YMF F5C · San Luis Obispo, CAThe accidental application of the brakes by the passenger during landing roll which resulted in the airplane nosing over.Jan 3, 2015 · N171L · Substantial damageNTSB WPR15LA003Accident · No injuriesLimited investigationFinal reportCorben Baby Ace D · Lincoln, CAThe total loss of engine power due to fuel starvation, which resulted from debris restricting the fuel flow within the fuel system.Oct 5, 2014 · N3RH · Substantial damageNTSB WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.Sep 5, 2014 · N15TE · Substantial damageNTSB WPR14LA267Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Sacramento, CAThe total loss of engine power for reasons that could not be determined because the airplane was not available for postaccident examination.Jun 23, 2014 · N61150 · Substantial damageNTSB WPR14LA250Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alturas, CAThe airplane’s failure to attain rotation speed during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…Jun 19, 2014 · N6091R · Substantial damageNTSB WPR14CA200Accident · No injuriesData collectionFinal reportCessna 180 · Cameron Park, CAThe pilot's failure to maintain directional control during landing which resulted in a ground-loop and nose over.May 21, 2014 · N2443C · Substantial damageNTSB WPR14CA197Accident · Minor injuriesData collectionFinal reportCessna 140 · Vacaville, CAThe pilot's use of excessive brakes during landing, which resulted in a nose over. Contributing to the accident was a partial loss of engine power during takeoff initial climb, likely due to carburetor ice.May 21, 2014 · N2256N · Substantial damageNTSB WPR14LA079Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Lodi, CAThe fatigue failure of the crankshaft, which resulted in a total loss of engine power and subsequent forced landing.Dec 27, 2013 · N8848K · Substantial damageNTSB WPR14CA017Accident · No injuriesData collectionFinal reportBeller Quicksilver Mxlii · Orland, CAThe pilot's failure to maintain aircraft control during taxi with a strong gusting wind condition which resulted in the airplane nosing over.Oct 14, 2013 · N75556 · Substantial damageNTSB WPR13LA392Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-105 Special · Rancho Palos Verdes, CAA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Aug 30, 2013 · N224T · Substantial damageNTSB WPR13LA318Accident · Serious injuriesLimited investigationFinal reportChicco Quicksilver Sport II · Newbury Park, CAThe partial loss of engine power while maneuvering due to the blockage of the exhaust system by broken internal engine baffles that had shifted during the flight, which resulted in a forced landing and subsequent impact with terrain.Jun 29, 2013 · N2812 · Substantial damageNTSB WPR13CA241Accident · No injuriesData collectionFinal reportCessna 172M · Truckee, CAThe pilot’s failure to maintain directional control during the landing roll which resulted in a collision with a tree.May 23, 2013 · N8879V · Substantial damageNTSB WPR13CA207Accident · No injuriesData collectionFinal reportWaco YKS-7 · Rialto, CAThe pilot’s failure to maintain directional control and his improper brake usage during the landing roll in a crosswind condition.Apr 26, 2013 · N17472 · Substantial damageNTSB WPR13CA166Accident · No injuriesData collectionFinal reportBellanca 7ECA · Sonoma, CAThe student pilot’s failure to maintain directional control during the touchdown and landing roll.Mar 16, 2013 · N8564V · Substantial damageNTSB WPR13CA088Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Rialto, CAThe pilot's failure to maintain airplane control while taxiing in gusting wind conditions.Jan 8, 2013 · N1254E · Substantial damageNTSB WPR13CA033Accident · Minor injuriesData collectionFinal reportCessna 140 · Watsonville, CAThe pilot’s failure to maintain airplane control during the landing roll.Nov 2, 2012 · N77227 · Substantial damageNTSB WPR13CA019Accident · Serious injuriesData collectionFinal reportQuicksilver Mfg MXL II Sport · Live Oak, CAThe pilot’s failure to compensate for turbulent conditions, which resulted in a loss of altitude.Oct 20, 2012 · N187AB · Substantial damageNTSB WPR12LA275Accident · No injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Fontana, CAPartial loss of engine power during cruise flight due to a failed engine cylinder rocker assembly clamping bolt. Contributing to the accident was the failure of unknown maintenance personnel to perform a modification to the assembly that would have prevented…Jun 24, 2012 · N523R · Substantial damageNTSB WPR12LA272Accident · No injuriesLimited investigationFinal reportCessna 150F · Jackson, CAThe student pilot's loss of directional control during landing, which resulted in a runway excursion.Jun 21, 2012 · N524CC · Substantial damageNTSB WPR12LA264Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Twentynine Palms, CAA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 29, 2012 · N2435K · Substantial damageNTSB WPR12LA182Accident · No injuriesLimited investigationFinal reportMays Kitfox Lite 2 · Cedarville, CAA loss of engine power during cruise flight due to air in the fuel system. Contributing to the accident was the pilot’s incorrect maintenance that did not properly secure the fuel lines.Apr 22, 2012 · N32122 · Substantial damageNTSB WPR12CA177Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Sierraville, CAThe pilot did not maintain directional control during the landing roll.Apr 20, 2012 · N8451Y · Substantial damageNTSB WPR12LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Dinsmore, CAThe flight instructor's delayed remedial action, inadequate recovery from a bounced landing, and failure to attain/maintain adequate airspeed during an attempted go-around.Feb 3, 2012 · N3879S · Substantial damageNTSB WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.Dec 10, 2011 · N28870 · Substantial damageNTSB WPR12CA011Accident · Minor injuriesData collectionFinal reportCessna 170B · Ramona, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.Oct 14, 2011 · N8261A · Substantial damageNTSB WPR12CA007Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A · San Diego, CAThe pilot's excessive brake application during landing.Oct 13, 2011 · N502GL · Substantial damageNTSB WPR11LA318Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frazier Park, CAThe pilot’s geographic disorientation, which resulted in an off-airport precautionary landing in soft terrain and a subsequent nose over.Jul 8, 2011 · N4901Z · Substantial damageNTSB WPR11LA284Accident · No injuriesLimited investigationFinal reportCessna 172S · Palo Alto, CAA total loss of engine power for undetermined reasons during the landing approach over unsuitable terrain.Jun 24, 2011 · N222MF · Substantial damageNTSB WPR11LA199Accident · Minor injuriesLimited investigationFinal reportZenith CH-750 · Winchester, CAA total loss of engine power during descent for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Apr 14, 2011 · N632DR · Substantial damageNTSB WPR11LA187Accident · No injuriesLimited investigationFinal reportZenith 701 · El Centro, CAA partial loss of engine power during the initial climb after takeoff due to oil starvation because of the failure of the No. 2 oil pump drive coupling.Apr 6, 2011 · N128CF · Substantial damageNTSB WPR11CA157Accident · No injuriesData collectionFinal reportAeronca 7EC · Big Bear City, CAThe pilot's improper maintenance, which resulted in a wheel separating from the airplane during takeoff, and the airplane's subsequent nose over during the landing rollout.Mar 11, 2011 · N2349E · Substantial damageNTSB WPR11CA148Accident · No injuriesData collectionFinal reportCessna A150M · Grass Valley, CAThe aircraft's encounter with deep snow during the landing roll out. Contributing to the accident was the airport manager's failure to update the AWOS recording to reflect the closure of the runway due to snow.Feb 27, 2011 · N7951V · Substantial damageNTSB WPR11LA150Accident · No injuriesLimited investigationFinal reportCessna 140A · Newark, CAA loss of engine power due to water contamination in the fuel system as a result of the pilot’s inadequate preflight inspection to identify and remove the water.Feb 26, 2011 · N5351C · Substantial damageNTSB WPR11CA134Accident · No injuriesData collectionFinal reportBal-Air Inc/Wayne John K Christen Eagle · Groveland, CAThe pilot's failure to compensate for crosswind conditions and maintain directional control during the landing roll, which resulted in a runway excursion.Feb 12, 2011 · N17AJ · Substantial damageNTSB WPR11CA128Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAThe pilot's failure to maintain clearance from an irrigation vent pipe.Feb 5, 2011 · N6725K · Substantial damageNTSB WPR11LA070Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Corona, CAThe total loss of engine power due to oil exhaustion as a result of a broken oil line.Dec 2, 2010 · N11858 · Substantial damageNTSB WPR11LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Suisun City, CAA total loss of engine power for undetermined reasons.Nov 27, 2010 · N5582T · Substantial damageNTSB WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.Nov 24, 2010 · N459CT · Substantial damageNTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Nov 22, 2010 · N6064N · Substantial damageNTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.Sep 2, 2010 · N522PC · Substantial damageNTSB WPR10CA404Accident · Minor injuriesData collectionFinal reportCarr Bryan Vans RV-6A · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point that resulted in an overrun of the runway and nose over.Aug 14, 2010 · N677DS · Substantial damageNTSB WPR10CA403Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 582S · Petaluma, CAThe pilot’s improper flare, resulting in a hard landing and nose over.Aug 14, 2010 · N468DW · Substantial damageNTSB WPR10FA387Accident · Minor injuriesField investigationFinal reportPZL Mielec M18 · Meridian, CALong-term deterioration of multiple engine fuel vaporizers that led to material failure of multiple turbine blades, which resulted in a complete loss of engine power. Contributing to the accident were the exceedance of specified engine inspection intervals…Aug 6, 2010 · N70461 · Substantial damageNTSB WPR10CA428Accident · No injuriesData collectionFinal reportHolmgreen John B RV8A · Carlsbad, CAThe pilot’s inadequate pretakeoff checks and failure to maintain control during the takeoff roll. Contributing to the accident was the pilot’s diverted attention due to the open canopy.Aug 1, 2010 · N525JH · Substantial damageNTSB WPR10LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Columbia, CAThe pilot's failure to maintain directional control during landing roll.Apr 7, 2010 · N2629D · Substantial damageNTSB WPR10CA176Accident · No injuriesData collectionFinal reportCessna 182Q · Fallbrook, CAThe pilot’s failure to maintain directional control of the airplane during landing.Mar 23, 2010 · N735KL · Substantial damage