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.
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
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 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.NTSB 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.NTSB WPR10CA101Accident · Minor injuriesData collectionFinal reportCessna 195B · Palm Springs, CAThe pilot's improper use of brakes during landing.NTSB WPR10CA098Accident · Minor injuriesData collectionFinal reportCessna 172R · Ramona, CAThe pilot's failure to maintain directional control during a touch-and-go landing.NTSB 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.NTSB WPR10CA071Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot’s inadequate compensation for a crosswind condition.NTSB 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.NTSB WPR10CA031Accident · No injuriesData collectionFinal reportPiper J4 · El Cajon, CAThe left-seat pilot's failure to maintain directional control during the landing roll.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB WPR09CA243Accident · No injuriesData collectionFinal reportART Lee Delano CH701 · Oakdale, CAThe pilot's inadequate compensation for the gusty crosswind conditions while landing.NTSB WPR09LA230Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Santa Rosa, CAA total loss of engine power on final approach for undetermined reasons.NTSB WPR09LA215Accident · No injuriesLimited investigationFinal reportStanton Glastar · Redding, CAA loss of engine power during cruise for undetermined reasons.NTSB WPR09CA183Accident · No injuriesData collectionFinal reportDenny Aerocraft Kitfox III · Oakdale, CAThe pilot's inadequate compensation for the crosswind conditions.NTSB WPR09CA147Accident · No injuriesData collectionFinal reportRobert Frisbey RV4 · Santa Rosa, CAThe pilot's inadequate recovery from a bounced landing.NTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB SEA08LA195Accident · Minor injuriesLimited investigationFinal reportLancair Propjet · Camarillo, CAThe loss of engine power due to air within the fuel system.NTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.NTSB SEA08CA165Accident · No injuriesData collectionFinal reportAntares - Balaban MA33 · Byron, CAThe pilot's failure to maintain an adequate airspeed, which resulted in a stall/mush.NTSB 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.NTSB LAX08CA070Accident · No injuriesData collectionFinal reportCessna 170B · Truckee, CAThe pilot's continued operation with a known mechanical problem and failure to maintain directional control.NTSB LAX08CA044Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Exeter, CAThe pilot's failure to maintain directional control.