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.
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
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 ANC13CA069Accident · No injuriesData collectionFinal reportCessna A185E · Kotzebue, AKThe pilot's lack of situational awareness and failure to maintain adequate clearance from terrain during takeoff. Factors contributing to the accident was the check airmen’s inadequate supervision.NTSB CEN13CA449Accident · No injuriesData collectionFinal reportDean David E Kitfox Classic 4 · Grinnell, IAThe pilot did not maintain control of the airplane while landing with a crosswind.NTSB CEN13CA434Accident · No injuriesData collectionFinal reportDavid W Oakes RV-7A · Charlottesville, INThe improper landing attitude which damaged the nosewheel and a resulted in a hard landing.NTSB ANC13LA089Accident · No injuriesLimited investigationFinal reportHoward M. Shepherd Supercub · Hoonah, AKThe pilot’s selection of an unsuitable off-airport landing site and his subsequent landing at too high of an airspeed, which resulted in his excessive use of brakes during the landing roll and resulted in a nose-over.NTSB CEN13CA423Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe pilot did not obtain adequate airspeed and clearance from obstructions during a grass field takeoff.NTSB ERA13CA345Accident · Serious injuriesData collectionFinal reportJim Braddock Just Aircraft Highla · Limestone, TNThe pilot’s improper recovery from a bounced landing.NTSB ERA13LA329Accident · Serious injuriesLimited investigationFinal reportKrips Jack E JR Kolb MK III · Fowler, NYThe pilot’s improper landing flare, which resulted in a nose-down collision with water.NTSB CEN13LA417Accident · No injuriesLimited investigationFinal reportPiper PA-22-125 · Mapleton, MNThe total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing to unsuitable terrain.NTSB ANC13CA064Accident · No injuriesData collectionFinal reportCessna A185F · Kenai, AKThe pilot's loss of control of the airplane while landing in variable wind conditions.NTSB CEN13CA400Accident · No injuriesData collectionFinal reportCessna 120 · Lakeville, MNThe student pilot's excessive application of the brakes during the landing roll and the flight instructor's delayed remedial action, which resulted in a nose-over.NTSB ANC13CA062Accident · No injuriesData collectionFinal reportAeronca 11AC · Kodiak, AKThe loss of engine power due to carburetor icing and the pilot's failure to continue the use of carburetor heat after experiencing carburetor ice.NTSB WPR13CA324Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Canby, ORThe pilot's failure to maintain directional control during the landing rollout in gusting wind conditions.NTSB WPR13LA318Accident · Serious injuriesLimited investigationFinal reportChicco Quicksilver Sport II · Newbury Park, CAThe partial loss of engine power while maneuvering due to the blockage of the exhaust system by broken internal engine baffles that had shifted during the flight, which resulted in a forced landing and subsequent impact with terrain.NTSB ANC13LA059Accident · No injuriesLimited investigationFinal reportCessna 175 · Skwentna, AKThe partial loss of engine power for reasons that could not be determined because the postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation. .NTSB CEN13LA375Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colome, SDThe loss of engine power for reasons that could not be determined because a postaccident engine run revealed no anomalies that would have precluded normal operation.NTSB CEN13CA372Accident · Serious injuriesData collectionFinal reportKubicek BB70Z · Windsor, COThe pilots’ encounter with increased wind, which resulted in a hard and fast landing.NTSB WPR13CA279Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Cashmere, WAThe pilot’s improper application of the brakes during the landing ground roll, which resulted in a nose over.NTSB ERA13CA298Accident · No injuriesData collectionFinal reportBellanca 7KCAB · East Aurora, NYThe pilot's failure to maintain aircraft control during a rejected takeoff on a soft turf runway with a gusty wind, resulting in the airplane nosing over.NTSB ERA13LA288Accident · Serious injuriesLimited investigationFinal reportHagerty RV-7A · Altoona, PAThe pilot's improper recovery from an encounter with a wind gust during landing, which resulted in a hard landing on, and displacement of, the nose landing gear and a subsequent runway excursion and noseover.NTSB ERA13CA286Accident · No injuriesData collectionFinal reportLuscombe 8A · Orangeburg, SCThe inadvertent slippage of the pilot's foot off the right rudder pedal, resulting in a loss of directional control on the ground, and the pilot's overly aggressive application of wheel brakes, resulting in a nose over.NTSB CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.NTSB CEN13CA335Accident · No injuriesData collectionFinal reportCessna 172S · Ann Arbor, MIThe pilot’s failure to make a go-around in a timely manner and his loss of control during landing.NTSB ERA13LA269Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Elkton, KYThe pilot's failure to use carburetor heat during the approach to landing, which resulted in carburetor icing and a partial loss of engine power during a subsequent initial climb.NTSB CEN13CA317Accident · No injuriesData collectionFinal reportStinson 108 · Lebanon, INThe pilot did not maintain control of the airplane during the landing roll.NTSB CEN13CA316Accident · No injuriesData collectionFinal reportSheldrick John H RV-6 · Brookfield, WIThe pilot's failure to maintain runway alignment and his failure to recognize that the airplane had drifted away from the runway prior to landing.NTSB ERA13LA268Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Fredericksburg, PAA total loss of engine power due to the fatigue failure of the No. 4 cylinder piston pin.NTSB CEN13LA330Accident · No injuriesLimited investigationFinal reportCessna TP206B · Sturgeon Bay, WIThe pilot’s improper reselection of the left fuel tank, which had an obstructed vent system and resulted in a total loss of engine power during the approach for landing.NTSB ANC13CA052Accident · No injuriesData collectionFinal reportCessna U206A · Fairbanks, AKThe pilot’s inadequate flare, which resulted in a nose-low impact with glassy water and a subsequent nose-over.NTSB WPR13CA259Accident · No injuriesData collectionFinal reportDressen Escape LS · Fruitland, IDThe pilot’s failure to maintain airplane control during the landing roll as a result of the parking brake lever not being positioned in the full off position.NTSB WPR13CA242Accident · No injuriesData collectionFinal reportCessna 182R · Alpine, WYThe pilot’s inadequate flare and loss of aircraft control during landing.NTSB WPR13CA241Accident · No injuriesData collectionFinal reportCessna 172M · Truckee, CAThe pilot’s failure to maintain directional control during the landing roll which resulted in a collision with a tree.NTSB ERA13LA257Accident · No injuriesLimited investigationFinal reportCessna 180J · Greenwood, MSA partial loss of engine power due to carburetor icing.NTSB CEN13LA305Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Beaumont, TXThe lack of a forward clamp on the carburetor heat box rubber boot, which allowed the boot to be ingested into the inlet of the carburetor heat box, restricting the airflow and leading to a subsequent partial loss of engine power.NTSB CEN13CA292Accident · No injuriesData collectionFinal reportCessna 162 · Erie, COThe pilot’s total lack of experience in aircraft make/model, and his failure to maintain directional control during landing. Contributing to the accident was the operator’s lack of oversight is allowing the airplane to be rented to the pilot.NTSB ANC13LA049Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Big Lake, AKThe pilot’s execution of a hard landing, which resulted in the overstress fracture of the right main axle housing and the subsequent nosedown.NTSB CEN13LA286Accident · No injuriesLimited investigationFinal reportCessna 182C · Fremont, MIThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion while in the traffic pattern.NTSB ERA13LA241Accident · No injuriesLimited investigationFinal reportCessna 182E · Southwick, MAThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any malfunctions or failures that would have precluded normal operation.NTSB ERA13CA244Accident · No injuriesData collectionFinal reportCessna 170B · Roxboro, NCThe pilot’s excessive use of wheel brakes while turning off the runway after landing resulting in a noseover.NTSB CEN13CA290Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Pella, IAThe pilot's failure to maintain directional control during landing.NTSB CEN13CA277Accident · No injuriesData collectionFinal reportCessna 140 · Groesbeck, TXThe pilot's failure to maintain control of the airplane during an aborted takeoff.NTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB CEN13CA272Accident · No injuriesData collectionFinal reportCessna 172M · Thief River Falls, MNThe pilot’s failure to maintain clearance from the power line while on approach to landing.NTSB ERA13CA233Accident · Minor injuriesData collectionFinal reportHughes Charles R Zodiac 601XL · Meriden, CTThe pilot's decision to land with a tailwind and his failure to maintain aircraft control during landing.NTSB CEN13CA266Accident · No injuriesData collectionFinal reportCessna 140 · Glenwood Springs, COThe pilot's failure to maintain airplane control during the landing roll and his excessive use of right brake, which resulted in a noseover.NTSB ANC13CA044Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.NTSB ERA13FA225Accident · 1 fatalField investigationFinal reportGrumman G-44 · Catskill, NYThe pilot’s misjudgment of the airplane’s altitude above the water and early flare for a landing on water with a glassy condition, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN13CA251Accident · No injuriesData collectionFinal reportAlexander Duane A RV-8 · Cortland, OHThe pilot’s failure to maintain control of the airplane after encountering an unexpected soft spot in the runway during landing.NTSB CEN13LA243Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Albuquerque, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC13CA039Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Seward, AKThe pilot’s decision to land on an unsuitable landing surface, which resulted in a nose over.NTSB WPR13CA207Accident · No injuriesData collectionFinal reportWaco YKS-7 · Rialto, CAThe pilot’s failure to maintain directional control and his improper brake usage during the landing roll in a crosswind condition.