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 WPR19LA054Accident · 1 fatalClass 3 · LimitedFinal reportProgressive Aerodyne Searey · Sacramento, CAThe pilot's failure to properly configure the landing gear before performing a water landing.Jan 2, 2019 · N24YD · Substantial damageNTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.Dec 12, 2018 · N5800U · Substantial damageNTSB GAA19CA075Accident · No injuriesData collectionFinal reportDarren M. Vinelli Sopwith PUP · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll in gusting tailwind conditions.Nov 26, 2018 · N1916Z · Substantial damageNTSB GAA19CA073Accident · No injuriesData collectionFinal reportBeech C23 · Porterville, CAThe pilot's improper landing flare, which resulted in an abnormal landing and subsequent porpoise.Nov 25, 2018 · N66710 · Substantial damageNTSB GAA19CA013Accident · No injuriesData collectionFinal reportCessna 140 · Marina, CAThe pilot’s inadvertent application of the brakes, which resulted in a nose-over.Oct 10, 2018 · N89266 · Substantial damageNTSB GAA18CA523Accident · Minor injuriesData collectionFinal reportEggleston Daniel S-18 Thorp · Porterville, CAThe pilot’s failure to maintain directional control during the takeoff roll.Sep 1, 2018 · N575DG · Substantial damageNTSB GAA18CA455Accident · No injuriesData collectionFinal reportCessna 140 · Healdsburg, CAThe pilot's improper brake application during the landing roll, which resulted in a nose-over.Jul 26, 2018 · N1902V · Substantial damageNTSB WPR18LA189Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164B · Colusa, CATotal loss of engine power for reasons that could not be determined based on the available information.Jul 9, 2018 · N6696K · Substantial damageNTSB GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.Jul 5, 2018 · N75SY · Substantial damageNTSB WPR18LA128Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G 164C · Maxwell, CAA total loss of engine power due to an uncommanded closing of the fuel shutoff valve, which terminated fuel to the engine. The reason for the fuel shutoff valve’s closure could not be determined based on the available information.Apr 29, 2018 · N6674K · Substantial damageNTSB GAA18CA191Accident · No injuriesData collectionFinal reportPiper PA18 · Dorris, CAThe pilot’s failure to maintain directional control during takeoff.Mar 30, 2018 · N101EB · Substantial damageNTSB GAA18CA120Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Paula, CAThe pilot’s failure to maintain directional control during landing due to being distracted by another airplane and her delayed initiation of a go-around, during which the right wing struck a parked helicopter.Feb 2, 2018 · N519AC · Substantial damageNTSB GAA18CA103Accident · Minor injuriesData collectionFinal reportHarrop Blake RV 7 · Death Valley National Park, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.Jan 14, 2018 · N4163B · Substantial damageNTSB WPR18LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 150L · Perris, CAThe presence of debris in the carburetor and blockage of the fuel delivery system, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the lack of maintenance to the carburetor.Dec 25, 2017 · N6627G · Substantial damageNTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.Nov 19, 2017 · N69656 · Substantial damageNTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.Oct 22, 2017 · N83512 · Substantial damageNTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.Sep 27, 2017 · N9346G · Substantial damageNTSB WPR17LA197Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Santa Paula, CAA partial loss of engine power during initial climb for reasons that could not be determined based on the available information.Sep 4, 2017 · N75753 · Substantial damageNTSB GAA17CA445Accident · No injuriesData collectionFinal reportCessna 170 · San Andreas, CAThe pilot’s improper landing flare during an aborted go-around in gusting wind conditions, which resulted in a hard landing.Jul 27, 2017 · N5596C · Substantial damageNTSB GAA17CA352Accident · No injuriesData collectionFinal reportPiper PA 18 · Red Bluff, CAThe pilot’s failure to maintain pitch control during the landing roll in gusting wind conditions, which resulted in a nose-over.Jun 18, 2017 · N4420Z · Substantial damageNTSB GAA17CA354Accident · No injuriesData collectionFinal reportPiper PA28 · Big Bear, CAThe pilot’s improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.Jun 4, 2017 · N9238W · Substantial damageNTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.May 24, 2017 · N708PV · Substantial damageNTSB GAA17CA280Accident · Minor injuriesData collectionFinal reportWeaver Stanley R/Robinson Scot Vans RV-8 · Vacaville, CAThe pilot’s failure to maintain directional control while landing in crosswind conditions.May 15, 2017 · N184ME · Substantial damageNTSB GAA17CA301Accident · No injuriesData collectionFinal reportZwicker Murray R Glastar · Napa, CAThe amphibious float-equipped airplane's encounter with a submerged object during a water landing, which resulted in a nose-over.Apr 30, 2017 · N89SR · Substantial damageNTSB WPR17LA094Accident · Minor injuriesLimited investigationFinal reportYakovlev YAK 52 · Porterville, CAA partial loss of engine power due to contaminants in the fuel system that decreased the fuel flow, the source of which could not be determined.Apr 29, 2017 · N132MD · Substantial damageNTSB GAA17CA230Accident · No injuriesData collectionFinal reportCessna 180 · Manchester, CAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the total loss of engine power.Apr 12, 2017 · N7945V · Substantial damageNTSB GAA17CA171Accident · Minor injuriesData collectionFinal reportSmith Douglas J. Sonex · Mercey Hot Springs, CAThe sport pilot’s unstabilized approach with a tailwind, which resulted in touchdown short of the runway and a subsequent nose-over.Mar 1, 2017 · N801SX · Substantial damageNTSB GAA17CA168Accident · Minor injuriesData collectionFinal reportMaule MX7 · Live Oak, CAThe pilot’s failure to maintain a stabilized approach and his subsequent incorrect brake application during the landing roll, which resulted in a nose-over.Mar 1, 2017 · N600XX · Substantial damageNTSB GAA17CA113Accident · No injuriesData collectionFinal reportAeronca 7AC · Compton, CAThe pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.Jan 15, 2017 · N1659E · Substantial damageNTSB WPR17LA042Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Willows, CAThe decision of the maintenance facility mechanic to conduct maintenance without reference to the applicable manufacturer’s guidance, which resulted in the improper reassembly and subsequent failure of the engine compressor bleed valve, which in turn…Dec 27, 2016 · N602L · Substantial damageNTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.Nov 22, 2016 · N169WT · Substantial damageNTSB GAA17CA071Accident · No injuriesData collectionFinal reportCessna 120 · Lincoln, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.Nov 14, 2016 · N120MD · Substantial damageNTSB WPR17LA018Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe pilot’s failure to ensure that sufficient fuel was available for the flight, which resulted in a total loss of engine power due to fuel exhaustion.Nov 10, 2016 · N9556U · Substantial damageNTSB GAA17CA010Accident · No injuriesData collectionFinal reportJoe Salomone Super CUB SQ2 · Boca Reservoir, CAThe pilot's decision to continue the taxi on unsuitable muddy terrain, which resulted in a nose-over.Oct 6, 2016 · N786AB · Substantial damageNTSB GAA16LA525Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Davis, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover. Contributing to the accident was the failure of the seatbelt anchor bracket.Sep 18, 2016 · N76284 · Substantial damageNTSB GAA16CA509Accident · Minor injuriesData collectionFinal reportGrumman G44 · Lakeport, CAThe pilot's failure to retract the landing gear, which resulted in a gear-down water landing and a nose over.Sep 17, 2016 · N111W · Substantial damageNTSB GAA16CA465Accident · No injuriesData collectionFinal reportCessna TR182 · South Lake Tahoe, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's failure to remove the carburetor heat during the attempted go-around in high…Sep 5, 2016 · N738GK · Substantial damageNTSB GAA16CA464Accident · No injuriesData collectionFinal reportNorth American SNJ · Perris, CAThe pilot's inability to compensate for a dust devil during an aborted landing, which resulted in the left wing contacting the ground, a runway excursion, and the airplane coming to rest in a nose-down attitude.Sep 3, 2016 · N7296C · Substantial damageNTSB GAA16CA425Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · San Diego, CAThe pilot's failure to maintain directional control during landing with a crosswind.Aug 10, 2016 · N35451 · Substantial damageNTSB GAA16CA416Accident · No injuriesData collectionFinal reportCessna 172 · Palm Springs, CAThe student pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a nose over in rough terrain.Aug 3, 2016 · N5203H · Substantial damageNTSB GAA16CA289Accident · No injuriesData collectionFinal reportAmerican AA 1A · Lone Pine, CAThe pilot's incorrect brake and power application during landing, which resulted in a runway overrun, collision with a dirt berm, nose gear collapse, and nose-over.Jun 5, 2016 · N6391L · Substantial damageNTSB GAA16CA249Accident · No injuriesData collectionFinal reportBoeing B75 · El Cajon, CAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and nose over.May 20, 2016 · N61445 · Substantial damageNTSB GAA16CA247Accident · No injuriesData collectionFinal reportCessna 182 · Redding, CAThe student pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and nose over.May 19, 2016 · N7610S · Substantial damageNTSB WPR16LA108Accident · Minor injuriesLimited investigationFinal reportCessna 180 · California City, CAA directional upset on landing due to a thermally induced atmospheric disturbance, which the pilot was unable to successfully counter due to improperly set rudder travel limits.May 13, 2016 · N9370C · Substantial damageNTSB WPR16LA107Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Acampo, CAA total loss of engine power due to a fatigue fracture of the fuel pressure line that connected the fuel control unit and the fuel flow transducer due to vibration as the result of a fatigue fracture of an associated support clamp. Contributing to the…May 12, 2016 · N1114A · Substantial damageNTSB WPR16LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Selma, CAThe total loss of engine power due to carburetor icing, which resulted from the flight instructor's failure to use carburetor heat during the descent.Apr 19, 2016 · N9909B · Substantial damageNTSB GAA16CA065Accident · Minor injuriesData collectionFinal reportCessna T210N · Avalon, CAThe pilot's delay in aborting the landing, resulting in a runway overrun and nose over.Nov 29, 2015 · N99210 · Substantial damageNTSB WPR16LA018Accident · No injuriesLimited investigationFinal reportCessna 120 · Lone Pine, CAThe fracture of the left main landing gear (MLG) wheel axle due to fatigue, which resulted in the separation of the left MLG wheel during takeoff from a dirt airstrip.Oct 24, 2015 · N3124N · Substantial damageNTSB WPR15LA262Accident · No injuriesLimited investigationFinal reportGraves Bryon S Vans RV-7A · Byron, CAImproper overhaul of the right magneto, which eliminated system redundancy, and resulted in a loss of engine power when the left magneto failed during aerobatic flight maneuvers.Sep 21, 2015 · N507RV · Substantial damageNTSB WPR15LA230Accident · No injuriesLimited investigationFinal reportGrumman G164 - B · Princeton, CAThe loss of engine power during an agricultural application flight due to a cylinder failure.Aug 4, 2015 · N48452 · Substantial damage