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 WPR10CA152Accident · No injuriesData collectionFinal reportCessna 172P · Camarillo Airport, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during landing.Mar 7, 2010 · N23FR · Substantial damageNTSB WPR10LA125Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Byron, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Feb 23, 2010 · N8494K · Substantial damageNTSB WPR10CA101Accident · Minor injuriesData collectionFinal reportCessna 195B · Palm Springs, CAThe pilot's improper use of brakes during landing.Jan 7, 2010 · N2171C · Substantial damageNTSB WPR10CA098Accident · Minor injuriesData collectionFinal reportCessna 172R · Ramona, CAThe pilot's failure to maintain directional control during a touch-and-go landing.Jan 6, 2010 · N35414 · Substantial damageNTSB WPR10CA095Accident · No injuriesData collectionFinal reportCessna 182P · Fallbrook, CAThe pilot's misjudged altitude and airspeed that resulted in his failure to attain the proper touchdown point.Jan 3, 2010 · N7417N · Substantial damageNTSB WPR10CA071Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot’s inadequate compensation for a crosswind condition.Nov 28, 2009 · N83516 · Substantial damageNTSB WPR10CA062Accident · No injuriesData collectionFinal reportCessna 172 · Yucca Valley, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control of the airplane.Nov 21, 2009 · N8504B · Substantial damageNTSB WPR10CA031Accident · No injuriesData collectionFinal reportPiper J4 · El Cajon, CAThe left-seat pilot's failure to maintain directional control during the landing roll.Oct 24, 2009 · N24536 · Substantial damageNTSB WPR09CA456Accident · No injuriesData collectionFinal reportAviat A-1C · McArthur, CAThe pilot's failure to maintain aircraft control during landing due to animals unexpectedly running onto the runway.Sep 18, 2009 · N82PL · Substantial damageNTSB WPR09LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Firebaugh, CAA total loss of engine power due to fuel exhaustion that was due to the failure of company ground personnel to refuel the airplane. Contributing to the accident was unsuitable terrain for a forced landing.Jul 29, 2009 · N23189 · Substantial damageNTSB WPR09LA369Accident · Minor injuriesLimited investigationFinal reportBrown Michael Kitfox IV · Escondido, CAA total loss of power due to an oil exhaustion induced seizure of the engine. The pilot's decision to continue flight to the original destination after becoming aware of the in-flight oil leak instead of landing at an intermediate airport to investigate the…Jul 25, 2009 · N6140S · Substantial damageNTSB WPR09CA365Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Hemet, CAThe student pilot’s failure to maintain directional control during the landing roll and excessive use of the brakes.Jul 25, 2009 · N918ZZ · Substantial damageNTSB WPR09CA243Accident · No injuriesData collectionFinal reportART Lee Delano CH701 · Oakdale, CAThe pilot's inadequate compensation for the gusty crosswind conditions while landing.May 13, 2009 · N701LD · Substantial damageNTSB WPR09LA230Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Santa Rosa, CAA total loss of engine power on final approach for undetermined reasons.May 7, 2009 · N2722T · Substantial damageNTSB WPR09LA215Accident · No injuriesLimited investigationFinal reportStanton Glastar · Redding, CAA loss of engine power during cruise for undetermined reasons.Apr 25, 2009 · N518PV · Substantial damageNTSB WPR09CA183Accident · No injuriesData collectionFinal reportDenny Aerocraft Kitfox III · Oakdale, CAThe pilot's inadequate compensation for the crosswind conditions.Mar 25, 2009 · N392JJ · Substantial damageNTSB WPR09CA147Accident · No injuriesData collectionFinal reportRobert Frisbey RV4 · Santa Rosa, CAThe pilot's inadequate recovery from a bounced landing.Mar 8, 2009 · N424RV · Substantial damageNTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.Mar 3, 2009 · N9166E · Substantial damageNTSB WPR09LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Turlock, CAThe loss of engine power due to carburetor icing resulting from the pilot's failure to apply carburetor heat. Contributing to the accident was the instructor's inadequate supervision of the flight.Feb 18, 2009 · N48761 · Substantial damageNTSB WPR09CA114Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAA loss of engine power due to the number four cylinder base nuts becoming loose, allowing the cylinder to detach from the engine case. Contributing to the accident was the pilot's impaired visibility due to smoke during the forced landing.Feb 12, 2009 · N3626T · Substantial damageNTSB WPR09CA078Accident · Minor injuriesData collectionFinal reportCessna 150L · Pescadero, CAThe pilot's inadequate preflight fuel planning and preparation. Contributing to the accident was the lack of a suitable area for a forced landing.Jan 11, 2009 · N21999 · Substantial damageNTSB WPR09LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · Fremont, CAThe partial loss of engine power during takeoff due to an oil pump/tachometer drive gear failure for undetermined reasons.Jan 10, 2009 · N758FN · Substantial damageNTSB WPR09CA064Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Dinuba, CAThe failure of maintenance personnel to properly install the engine's Py line correctly, which resulted in the total loss of engine power and subsequent force landing. Contributing to the accident was the lack of suitable terrain.Dec 16, 2008 · N1035F · Substantial damageNTSB SEA08LA195Accident · Minor injuriesLimited investigationFinal reportLancair Propjet · Camarillo, CAThe loss of engine power due to air within the fuel system.Sep 2, 2008 · N750PJ · Substantial damageNTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.Aug 20, 2008 · N818CT · Substantial damageNTSB SEA08CA165Accident · No injuriesData collectionFinal reportAntares - Balaban MA33 · Byron, CAThe pilot's failure to maintain an adequate airspeed, which resulted in a stall/mush.Jul 22, 2008 · N92287 · Substantial damageNTSB LAX08LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Butte City, CAA total loss of engine power during takeoff due to fuel exhaustion as a result of the pilot's failure to verify the fuel quantity prior to flight.May 6, 2008 · N703Y · Substantial damageNTSB LAX08CA070Accident · No injuriesData collectionFinal reportCessna 170B · Truckee, CAThe pilot's continued operation with a known mechanical problem and failure to maintain directional control.Feb 29, 2008 · N2571D · Substantial damageNTSB LAX08CA044Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Exeter, CAThe pilot's failure to maintain directional control.Jan 7, 2008 · N30WH · Substantial damage