NTSB investigations, 2009
136 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 year(c.\"eventDate\") = 2009
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 year(c."eventDate") = 2009 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 WPR09LA201Accident · No injuriesLimited investigationFinal reportBrinker / Garner BI-PLANE · Caldwell, IDLoss of control during the landing roll for undetermined reasons.NTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.NTSB ERA09CA243Accident · Minor injuriesData collectionFinal reportCessna 150 · Madison, MSThe pilot's improper flare and subsequent loss of directional control.NTSB CEN09LA250Accident · Minor injuriesLimited investigationFinal reportJordan Don R Vans RV-6A · Arlington, TXA total loss of engine power due to the failure of both magnetos. Contributing to the accident was the lack of preventative maintenance/inspection of the magnetos.NTSB WPR09CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions while landing.NTSB ERA09LA244Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Plattsburgh, NYThe pilot's improper application of brakes during the landing rollout.NTSB WPR09CA191Accident · Serious injuriesData collectionFinal reportRemos Gemini Remos · Jefferson, WAThe pilot's inadequate compensation for the gusty crosswinds conditions while approaching to land.NTSB CEN09CA237Accident · No injuriesData collectionFinal reportPiper PA-22-160 · North Little Rock, ARThe pilot's inadequate compensation for the wind conditions during takeoff.NTSB WPR09LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Kalispell, MTA partial loss of engine power during a go-around for undetermined reasons. Contributing to the accident was a fatigue failure of the right main landing gear spring.NTSB ANC09CA029Accident · No injuriesData collectionFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's selection of an unsuitably rough and snow-covered landing area.NTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB WPR09LA167Accident · No injuriesLimited investigationFinal reportCessna 180G · Wendover, UTA loss of directional control during landing as a result of the binding in one main landing gear brake assembly due to incorrect maintenance procedures. Contributing to the accident was the pilot's failure to correctly reconfigure the airplane during an…NTSB WPR09CA183Accident · No injuriesData collectionFinal reportDenny Aerocraft Kitfox III · Oakdale, CAThe pilot's inadequate compensation for the crosswind conditions.NTSB CEN09CA219Accident · No injuriesData collectionFinal reportAeronca 7AC-CONV · Stanley, NDThe pilot's failure to maintain directional control during landing.NTSB WPR09CA147Accident · No injuriesData collectionFinal reportRobert Frisbey RV4 · Santa Rosa, CAThe pilot's inadequate recovery from a bounced landing.NTSB CEN09CA192Accident · Minor injuriesData collectionFinal reportChampion 7FC · Thomas, OKA partial loss of engine power for undetermined reasons.NTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.NTSB CEN09LA197Accident · No injuriesLimited investigationFinal reportNeland Richard L Daytona SU · Guymon, OKFailure of the left main landing gear shock/strut during takeoff for undetermined reasons.NTSB WPR09CA127Accident · No injuriesData collectionFinal reportCub Crafters PA-18-150 · Buckeye, AZThe pilot's failure to maintain directional control.NTSB CEN09CA229Accident · No injuriesData collectionFinal reportCessna 172 · Manhattan, KSThe pilot's improper recovery from a bounced landing.NTSB ERA09CA172Accident · No injuriesData collectionFinal reportCessna 182S · Westminster, MDThe pilot's failure to stop the airplane within the available runway after touchdown.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 CEN09CA158Accident · Minor injuriesData collectionFinal reportCessna 170 · Cottonwood Falls, KSThe decision of the pilot to attempt operations outside the forward center of gravity limit. Contributing to the accident was the pilot's selection of an inadequate runway for the conditions.NTSB WPR09CA109Accident · No injuriesData collectionFinal reportSeher Bearhawk · Reno, NVThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during takeoff. Contributing to the accident were a crosswind and the pilot's delayed decision to abort the takeoff.NTSB ERA09LA151Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Cameron, SCA loss of engine power for undetermined reasons.NTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.NTSB CEN09CA191Accident · No injuriesData collectionFinal reportCessna 182Q · Clinton, ARThe pilot's improper flare, resulting in a hard landing. Contributing to the accident was the gust of wind as reported by the pilot.NTSB WPR09LA097Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Honolulu, HIAn oil starvation induced catastrophic engine failure due to the fracture and separation of the propeller governor oil line, which was a result of inadequate inspection by maintenance personnel.NTSB CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.NTSB ERA09LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Wauchula, FLA loss of engine power due to failure of the Number 3 connecting rod due to oil contamination. Contributing to the accident was the insufficient oil change time intervals performed by company personnel.NTSB WPR09LA085Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Beaver, UTA loss of engine power while maneuvering due to a sheared propeller blade's pitch change link. Contributing to the accident was lack of suitable terrain for 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 CEN09CA130Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Elrosa, MNThe pilot's inability to maintain control after touchdown on a snow-covered runway.NTSB ERA09CA119Accident · No injuriesData collectionFinal reportCessna 172SP · Lancaster, NYThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was the student pilot's lack of solo flight experience and the snow bank located off the left side of the runway.