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.

NTSB WPR09LA201Accident · No injuriesLimited investigationFinal reportBrinker / Garner BI-PLANE · Caldwell, IDLoss of control during the landing roll for undetermined reasons.Apr 17, 2009 · N375CB · Substantial damageNTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.Apr 16, 2009 · N7802F · Substantial damageNTSB ERA09CA243Accident · Minor injuriesData collectionFinal reportCessna 150 · Madison, MSThe pilot's improper flare and subsequent loss of directional control.Apr 15, 2009 · N3334J · Substantial damageNTSB 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.Apr 15, 2009 · N6DJ · Substantial damageNTSB WPR09CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions while landing.Apr 14, 2009 · N4816D · Substantial damageNTSB ERA09LA244Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Plattsburgh, NYThe pilot's improper application of brakes during the landing rollout.Apr 12, 2009 · N258PA · Substantial damageNTSB WPR09CA191Accident · Serious injuriesData collectionFinal reportRemos Gemini Remos · Jefferson, WAThe pilot's inadequate compensation for the gusty crosswinds conditions while approaching to land.Apr 9, 2009 · N249SW · Substantial damageNTSB CEN09CA237Accident · No injuriesData collectionFinal reportPiper PA-22-160 · North Little Rock, ARThe pilot's inadequate compensation for the wind conditions during takeoff.Apr 5, 2009 · N9600D · Substantial damageNTSB 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.Apr 4, 2009 · N6433A · Substantial damageNTSB ANC09CA029Accident · No injuriesData collectionFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's selection of an unsuitably rough and snow-covered landing area.Apr 4, 2009 · N40684 · Substantial damageNTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.Mar 29, 2009 · N736CL · Substantial damageNTSB 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…Mar 27, 2009 · N98FC · 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 CEN09CA219Accident · No injuriesData collectionFinal reportAeronca 7AC-CONV · Stanley, NDThe pilot's failure to maintain directional control during landing.Mar 15, 2009 · N82041 · 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 CEN09CA192Accident · Minor injuriesData collectionFinal reportChampion 7FC · Thomas, OKA partial loss of engine power for undetermined reasons.Mar 6, 2009 · N7681E · Substantial damageNTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.Mar 3, 2009 · N9166E · Substantial damageNTSB CEN09LA197Accident · No injuriesLimited investigationFinal reportNeland Richard L Daytona SU · Guymon, OKFailure of the left main landing gear shock/strut during takeoff for undetermined reasons.Feb 26, 2009 · N170DN · Substantial damageNTSB WPR09CA127Accident · No injuriesData collectionFinal reportCub Crafters PA-18-150 · Buckeye, AZThe pilot's failure to maintain directional control.Feb 23, 2009 · N324A · Substantial damageNTSB CEN09CA229Accident · No injuriesData collectionFinal reportCessna 172 · Manhattan, KSThe pilot's improper recovery from a bounced landing.Feb 22, 2009 · N733FR · Substantial damageNTSB ERA09CA172Accident · No injuriesData collectionFinal reportCessna 182S · Westminster, MDThe pilot's failure to stop the airplane within the available runway after touchdown.Feb 21, 2009 · N139RA · 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 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.Feb 7, 2009 · N2333D · Substantial damageNTSB 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.Feb 5, 2009 · N846BH · Substantial damageNTSB ERA09LA151Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Cameron, SCA loss of engine power for undetermined reasons.Feb 1, 2009 · N3066E · Substantial damageNTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.Feb 1, 2009 · N3628T · Substantial damageNTSB 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.Jan 25, 2009 · N759YH · Substantial damageNTSB 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.Jan 21, 2009 · N30740 · Substantial damageNTSB 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.Jan 19, 2009 · N35571 · Substantial damageNTSB 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.Jan 18, 2009 · N6566P · Substantial damageNTSB 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.Jan 15, 2009 · N3170C · 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 CEN09CA130Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Elrosa, MNThe pilot's inability to maintain control after touchdown on a snow-covered runway.Jan 10, 2009 · N2553S · Substantial damageNTSB 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.Jan 1, 2009 · N2228L · Substantial damage