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 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 ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.Jul 23, 2009 · N595Z · Substantial damageNTSB CEN09CA450Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Waring, TXThe pilot's failure to maintain directional control during landing roll-out. Contributing to the accident was the worn left main landing gear brake.Jul 18, 2009 · N2991D · Substantial damageNTSB ERA09LA407Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Morristown, TNThe partial loss of engine power for undetermined reasons.Jul 16, 2009 · N7227E · Substantial damageNTSB CEN09CA436Accident · No injuriesData collectionFinal reportTaylorcraft BC-D · Joplin, MOThe pilot's failure to maintain directional control during the landing roll.Jul 14, 2009 · N96660 · Substantial damageNTSB ERA09LA397Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Auburn, MEA loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance inspection of the airplane and engine's fuel system.Jul 11, 2009 · N2871E · Substantial damageNTSB WPR09CA346Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Sulphur Creek, IDThe pilot's failure to maintain directional control during the landing roll.Jul 10, 2009 · N199CT · Substantial damageNTSB CEN09LA451Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beaman, IAThe loss of engine power during initial climb for undetermined reasons.Jul 10, 2009 · N6683K · Substantial damageNTSB WPR09CA335Accident · No injuriesData collectionFinal reportCessna 180 · La Grande, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.Jul 5, 2009 · N3198D · Substantial damageNTSB CEN09CA407Accident · No injuriesData collectionFinal reportRemos G-3/6000 · Oshkosh, WIA total loss of total engine power due to fuel exhaustion as a result of the instructor pilot's inadequate preflight inspection. Contributing to the accident was the creased fuel quantity tube.Jul 1, 2009 · N261RA · Substantial damageNTSB ANC09CA059Accident · No injuriesData collectionFinal reportCessna 170A · Kasigluk, AKThe student pilot's failure to maintain directional control during the landing roll in a crosswind.Jun 28, 2009 · N5490C · Substantial damageNTSB ERA09CA553Accident · No injuriesData collectionFinal reportChampion 7GCAA · Ware, MAThe pilot's failure to maintain control of the airplane during landing.Jun 27, 2009 · N1879G · Substantial damageNTSB CEN09LA384Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Llano, TXThe pilot's inability to maintain aircraft control due to the failure of the left main landing gear wheel, which resulted in the separation of the wheel from the aircraft.Jun 24, 2009 · N6939M · Substantial damageNTSB WPR09CA306Accident · No injuriesData collectionFinal reportJenkins Jack Glastar SP · Coupeville, WAThe pilot’s improper landing flare that resulted in a hard landing on soft/grassy terrain.Jun 22, 2009 · N5617 · Substantial damageNTSB CEN09CA373Accident · Serious injuriesData collectionFinal reportCessna 172N · Marysville, OHThe pilot's inability to maintain directional control of the airplane during the landing roll for undetermined reasons.Jun 22, 2009 · N734EN · Substantial damageNTSB WPR09CA295Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Dixie, IDThe pilot's excessive braking during the landing roll.Jun 18, 2009 · N4155U · Substantial damageNTSB WPR09CA285Accident · No injuriesData collectionFinal reportCessna 175A · Polacca, AZThe pilot’s failure to adequately estimate the required distance to avoid obstructions while taking off from a road.Jun 12, 2009 · N7979T · Substantial damageNTSB CEN09CA354Accident · Serious injuriesData collectionFinal reportThrockmorton Matthew E F1-EVO · Mitchell, INA total loss of engine power due to the disconnection of an oil line and the subsequent loss of engine oil.Jun 12, 2009 · N540MT · Substantial damageNTSB ANC09LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe flight instructor's decision to land with a tailwind, and his failure to maintain directional control during landing, resulting in a ground-loop and nose-over.Jun 11, 2009 · N2783D · Substantial damageNTSB ERA09CA333Accident · No injuriesData collectionFinal reportChatham Robert M RV6-A · Gilbert, SCThe pilot’s failure to maintain directional control of the airplane during landing roll. Contributing to the accident was the airspeed indicator that became inoperative during the landing approach.Jun 9, 2009 · N55EC · Substantial damageNTSB ERA09CA334Accident · No injuriesData collectionFinal reportPiper J3C-65 · Alamana, FLThe pilot's selection of unsuitable terrain for landing.Jun 6, 2009 · N42351 · Substantial damageNTSB WPR09CA276Accident · No injuriesData collectionFinal reportCessna A185F · Wenatchee, WAThe pilot's misjudged approach and failure to attain the proper touchdown point.Jun 2, 2009 · N1015F · Substantial damageNTSB WPR09CA275Accident · No injuriesData collectionFinal reportCessna 172S · Tooele, UTThe pilot's failure to maintain directional control during landing.Jun 2, 2009 · N5262Y · Substantial damageNTSB CEN09LA335Accident · No injuriesLimited investigationFinal reportCessna 140 · St. Louis, MOThe improper installation of the wing fairing during recent maintenance, which resulted in the partial separation of the fairing shortly after takeoff.Jun 2, 2009 · N76456 · Substantial damageNTSB ANC09CA049Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Nome, AKThe pilot's selection of an unsuitable landing/takeoff area.Jun 1, 2009 · N94995 · Substantial damageNTSB ERA09CA314Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Aurora, WVThe pilot’s inadequate preflight planning and preparation which resulted in a low fuel condition requiring an off-airport landing.May 31, 2009 · N4824A · Substantial damageNTSB CEN09CA326Accident · Minor injuriesData collectionFinal reportAeropro CZ Eurofox · Bloomfield, INThe pilot's selection of an unsuitable landing area.May 30, 2009 · N817R · Substantial damageNTSB WPR09CA260Accident · No injuriesData collectionFinal reportStinson SR-8B · Tacoma, WAThe application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.May 24, 2009 · N17119 · Substantial damageNTSB CEN09CA315Accident · No injuriesData collectionFinal reportHolsclaw Francis E Starduster · Ranger, TXThe pilot's inability to maintain directional control due to the buckling of the right landing gear as a result of corrosion.May 23, 2009 · N42WT · Substantial damageNTSB ERA09CA301Accident · No injuriesData collectionFinal reportCessna 172N · Tunkhannock, PAThe pilot's failure to attain the proper touchdown point while landing with a tailwind.May 21, 2009 · N9492E · Substantial damageNTSB WPR09CA252Accident · No injuriesData collectionFinal reportCessna 185E · Tacoma, WAThe pilot's failure to maintain directional control while landing with a crosswind.May 18, 2009 · N70083 · Substantial damageNTSB WPR09CA259Accident · Minor injuriesData collectionFinal reportVenus Trike · Kuna, IDThe complete loss of engine power for undetermined reasons, and the overload failure of the nose landing gear strut during the roll out over soft/rough terrain.May 17, 2009 · UNREG · Substantial damageNTSB ANC09CA046Accident · Minor injuriesData collectionFinal reportWinship Kent S Dogger Craft · Palmer, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a nose over and substantial damage to the airplane.May 16, 2009 · N530KW · Substantial damageNTSB CEN09CA316Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Charleston, MOThe pilot's failure to abort the takeoff resulting in a runway overrun and impact with terrain.May 15, 2009 · N85115 · 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 CEN09CA293Accident · No injuriesData collectionFinal reportCessna 170B · Roswell, NMThe pilot's failure to maintain directional control while landing.May 13, 2009 · N3210A · Substantial damageNTSB CEN09CA304Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · San Antonio, TXThe instructor pilot’s improper landing flare.May 10, 2009 · N169PA · Substantial damageNTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.May 8, 2009 · N172SV · 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 ANC09CA037Accident · No injuriesData collectionFinal reportCessna 140 · Haines, AKThe pilot's decision to practice takeoff and landings on unsuitable terrain, which resulted in a nose-over on takeoff.May 5, 2009 · N1685V · Substantial damageNTSB CEN09CA272Accident · Minor injuriesData collectionFinal reportCessna A185F · Patterson, LAThe pilot's failure to maintain adequate airspeed in a turn while attempting to return to land, which resulted in an aerodynamic stall. Contributing to the accident was the reported loss of engine power for undetermined reasons.Apr 29, 2009 · N4603E · Substantial damageNTSB ERA09CA274Accident · No injuriesData collectionFinal reportCessna 150K · Waycross, GAThe student pilot's failure to maintain aircraft control during approach in gusty conditions. Contributing to the accident was the student pilot's misunderstanding of the airspeed indicator.Apr 27, 2009 · N6213G · Substantial damageNTSB ANC09LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe non-certificated pilot’s decision to attempt to "ski" atop a water-covered tidal area in an airplane equipped with over-sized main landing gear tires, resulting in a loss of control and a nose over.Apr 26, 2009 · N3256B · 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 CEN09CA261Accident · No injuriesData collectionFinal reportAmerican Legend AL-3C · McKinney, TXTHe pilot's failure to maintain control of the airplane during landing. Contributing to the accident were gusty crosswinds.Apr 20, 2009 · N273MS · Substantial damageNTSB ERA09CA254Accident · Minor injuriesData collectionFinal reportAmerican Longevity Searey · Littleton, NCThe pilot's failure to ensure the landing gear was properly configured for the water landing.Apr 19, 2009 · N915TR · Substantial damageNTSB ERA09CA252Accident · No injuriesData collectionFinal reportCessna/Air Repair 305F · Embden, METhe pilot's failure to obtain the proper touchdown point while landing.Apr 18, 2009 · N60537 · Substantial damageNTSB ERA09CA251Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Southbridge, MAThe pilot's inadequate compensation for the gusting wind conditions.Apr 18, 2009 · N96552 · Substantial damage