NTSB investigations, 2013

124 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\") = 2013
    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 CEN13LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Bowling Green, MOThe failure of the engine supercharger's rear bearing, which resulted in the loss of engine power.Apr 24, 2013 · N23416 · Substantial damageNTSB ANC13CA046Accident · No injuriesData collectionFinal reportCessna U206G · Nenana, AKIce accretion in the right main landing gear wheel brake during departure, which prevented the right main landing gear from rotating on landing and resulted in a runway excursion and subsequent impact with a snow bank.Apr 24, 2013 · N756DJ · Substantial damageNTSB CEN13CA234Accident · No injuriesData collectionFinal reportCessna 175A · Albuquerque, NMThe pilot’s inability to maintain airplane control during taxi due to an inadvertent encounter with a dust devil.Apr 20, 2013 · N6955E · Substantial damageNTSB ERA13CA206Accident · Minor injuriesData collectionFinal reportPoole Robert C JR Van's · Salisbury, NCThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent decision to exit the paved runway onto the soft terrain.Apr 17, 2013 · N439RP · Substantial damageNTSB ERA13CA207Accident · No injuriesData collectionFinal reportCessna A185F · Palatka, FLThe pilot’s failure to retract the landing gear after takeoff from a runway, and his subsequent water landing with the wheels extended.Apr 16, 2013 · N812F · Substantial damageNTSB WPR13CA192Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Moose Creek Ranger Station, IDThe pilot's use of excessive braking after landing with a tailwind and after an extended touchdown to avoid deer on the runway.Apr 9, 2013 · N3505P · Substantial damageNTSB CEN13CA222Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot’s failure to maintain airplane control while taking off in gusting wind conditions.Apr 8, 2013 · N7825T · Substantial damageNTSB ERA13CA181Accident · No injuriesData collectionFinal reportCessna 172 · Tistusville, FLThe pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.Mar 24, 2013 · N7113G · Substantial damageNTSB CEN13CA224Accident · No injuriesData collectionFinal reportAeronca 65C · Grand Rapids, MNThe student pilot’s failure to adequately lock the primer before takeoff and the flight instructor's failure to verify that the primer was adequately locked.Mar 23, 2013 · N21301 · Substantial damageNTSB CEN13CA203Accident · No injuriesData collectionFinal reportAviat A-1B · Dumas, TXThe pilot’s failure to maintain control of the airplane while taking off in gusty crosswind conditions. Contributing to the accident was the pilot’s decision to takeoff instead of waiting to ensure that the wind velocity had decreased.Mar 21, 2013 · N132AA · Substantial damageNTSB ANC13CA034Accident · No injuriesData collectionFinal reportPiper PA-16 · Big Lake, AKThe pilot's decision to land on unsuitable terrain.Mar 17, 2013 · N5942H · Substantial damageNTSB WPR13CA166Accident · No injuriesData collectionFinal reportBellanca 7ECA · Sonoma, CAThe student pilot’s failure to maintain directional control during the touchdown and landing roll.Mar 16, 2013 · N8564V · Substantial damageNTSB ERA13CA164Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Groveland, FLThe pilot's failure to maintain the proper airspeed during a tailwind approach, his improper decision to continue a fast approach with a tailwind rather than go around, and his improper use of the wheel brakes during the landing roll.Mar 13, 2013 · N7329Z · Substantial damageNTSB ERA13LA159Accident · Minor injuriesLimited investigationFinal report781569 FX 210 · Punta Gorda, FLA total loss of engine power for reasons that could not be determined from the available evidence.Mar 9, 2013 · N524VT · Substantial damageNTSB ANC13LA032Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe overstress fracture and failure of the right wheel/ski arm while taxiing in snow and water-overflow terrain conditions, which resulted in a noseover.Mar 8, 2013 · N185FK · Substantial damageNTSB ERA13LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Naples, METhe student pilot’s improper decision to land on a frozen lake.Mar 2, 2013 · N3438J · Substantial damageNTSB ERA13CA137Accident · Minor injuriesData collectionFinal reportCessna 172N · Okeechobee, FLThe pilot’s failure to maintain directional control during takeoff.Feb 18, 2013 · N6249D · Substantial damageNTSB CEN13CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · Elcho, WIThe pilot's inadequate preflight and in-flight fuel management, which led to a total loss of engine power due to fuel exhaustion.Feb 17, 2013 · N30227 · Substantial damageNTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.Feb 2, 2013 · N1421V · Substantial damageNTSB WPR13LA108Accident · No injuriesLimited investigationFinal reportCessna 175B · Wellsville, UTA loss of engine power during cruise flight due to carburetor ice.Feb 2, 2013 · N8125T · Substantial damageNTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.Jan 24, 2013 · N18690 · Substantial damageNTSB WPR13CA097Accident · No injuriesData collectionFinal reportCessna 140 · Tucson, AZThe pilot’s failure to maintain directional control during the landing roll and his excessive application of brakes, which resulted in a noseover.Jan 21, 2013 · N223PE · Substantial damageNTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.Jan 20, 2013 · N2323D · Substantial damageNTSB WPR13CA088Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Rialto, CAThe pilot's failure to maintain airplane control while taxiing in gusting wind conditions.Jan 8, 2013 · N1254E · Substantial damage