NTSB investigations, 2018

141 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\") = 2018
    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 GAA18CA465Accident · No injuriesData collectionFinal reportBellanca 8GCBC · El Dorado, ARThe pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jul 27, 2018 · N391KM · Substantial damageNTSB GAA18CA455Accident · No injuriesData collectionFinal reportCessna 140 · Healdsburg, CAThe pilot's improper brake application during the landing roll, which resulted in a nose-over.Jul 26, 2018 · N1902V · Substantial damageNTSB ERA18LA202Accident · No injuriesLimited investigationFinal reportCessna 150 · Matthews, NCThe student pilot's improper decision to conduct a solo flight without an endorsement to do so and to perform an off-airport landing based on a perceived performance issue with the airplane. Contributing to the accident was the pilot's lack of training and…Jul 26, 2018 · N1193Y · Substantial damageNTSB CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.Jul 24, 2018 · N20342 · Substantial damageNTSB GAA18CA444Accident · No injuriesData collectionFinal reportCessna 195 · Hood River, ORThe pilot’s failure to maintain directional control during landing.Jul 21, 2018 · N195N · Substantial damageNTSB CEN18LA284Accident · No injuriesLimited investigationFinal reportToomey Quickie · Zanesville, OHThe failure of the exhaust manifold and a loose mixture screw, which resulted in a partial loss of engine power.Jul 19, 2018 · N23JH · Substantial damageNTSB GAA18CA422Accident · No injuriesData collectionFinal reportPiper PA18S · Palmer, AKThe pilot's failure to maintain pitch control during the landing roll.Jul 16, 2018 · N3982Z · Substantial damageNTSB WPR18LA189Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164B · Colusa, CATotal loss of engine power for reasons that could not be determined based on the available information.Jul 9, 2018 · N6696K · Substantial damageNTSB GAA18CA398Accident · No injuriesData collectionFinal reportAeronca 7CCM · Palmer, AKThe pilot's improper landing flare, which resulted in a hard landing, an attempted go-around, and a subsequent nose-over.Jul 7, 2018 · N81768 · Substantial damageNTSB GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.Jul 5, 2018 · N75SY · Substantial damageNTSB GAA18CA393Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · San Saba, TXThe pilot’s improper landing flare during the aborted takeoff, which resulted in a hard landing and a nose-over.Jul 4, 2018 · N127VV · Substantial damageNTSB GAA18CA388Accident · Minor injuriesData collectionFinal reportCessna A185 · Miami, FLThe pilot’s failure to retract the wheels of the amphibious airplane on takeoff, which resulted in a nose-over when the airplane landed on water with the wheels extended. Contributing to the accident was the pilot’s failure to use appropriate checklists.Jul 1, 2018 · N14ED · Substantial damageNTSB GAA18CA419Accident · No injuriesData collectionFinal reportCessna 152 · Panama City, FLThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jun 30, 2018 · N89887 · Substantial damageNTSB GAA18CA385Accident · No injuriesData collectionFinal reportPiper PA18 · Anchorage, AKThe pilot’s overapplication of the brakes during landing, which resulted in a nose-over.Jun 28, 2018 · N4714Y · Substantial damageNTSB CEN18LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT502 · Tappen, NDThe partial loss of engine power for reasons that could not be determined based on the available evidence.Jun 28, 2018 · N502S · Substantial damageNTSB CEN18LA241Accident · No injuriesLimited investigationFinal reportCessna T210 · Pocahontas, ARThe pilot's excessive use of wheel brakes while landing, which resulted in both brakes locking up, a loss of directional control, a runway excursion, and a nose over.Jun 28, 2018 · N6386C · Substantial damageNTSB ERA18TA179Accident · Minor injuriesFinal reportStearman B75 · Lexington, NCThe pilot’s overapplication of the wheel brakes during landing, which resulted in a nose-over.Jun 25, 2018 · N52584 · Substantial damageNTSB GAA18CA372Accident · Minor injuriesData collectionFinal reportBeech D17 · Hamilton, MTThe pilot’s failure to maintain directional control during the landing roll and his subsequent inability to recover due to his foot being stuck.Jun 22, 2018 · N61862 · Substantial damageNTSB GAA18CA373Accident · No injuriesData collectionFinal reportCessna 180 · Kent, WAThe pilot’s use of excessive braking during the landing roll, which resulted in the airplane coming to rest nose down.Jun 20, 2018 · N9130T · Substantial damageNTSB GAA18CA371Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Hutchinson, MNThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.Jun 20, 2018 · N3169D · Substantial damageNTSB GAA18CA369Accident · No injuriesData collectionFinal reportCessna 172 · Bruington, VAThe pilot’s improper decision to abort the takeoff with insufficient runway remaining to safely stop the airplane.Jun 20, 2018 · N8090X · Substantial damageNTSB CEN18TA233Accident · Serious injuriesFinal reportCessna 150F · Ferdinand, INThe pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.Jun 19, 2018 · N3002X · Substantial damageNTSB GAA18CA364Accident · No injuriesData collectionFinal reportCessna 182T · Sebring, FLThe pilot’s failure to maintain directional control during landing with a crosswind.Jun 17, 2018 · N6284X · Substantial damageNTSB GAA18CA355Accident · No injuriesData collectionFinal reportPiper PA18 · Salcha, AKThe pilot’s overapplication of the brakes during landing, which resulted in a nose-over.Jun 17, 2018 · N9098D · Substantial damageNTSB CEN18LA229Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Desdemona, TXThe total loss of engine power due to the fuel pump’s fuel flow setting being set too high, which resulted in an excessive fuel flow to the engine.Jun 17, 2018 · N6107R · Substantial damageNTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.Jun 15, 2018 · N8273C · Substantial damageNTSB GAA18CA351Accident · No injuriesData collectionFinal reportCessna 185 · Big Lake, AKThe pilot’s inability to maintain directional control during the landing roll due to a flat tire.Jun 15, 2018 · N9964X · Substantial damageNTSB GAA18CA338Accident · No injuriesData collectionFinal reportLuscombe 8 · Phoenix, AZThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.Jun 12, 2018 · N2094B · Substantial damageNTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.Jun 9, 2018 · N363CK · Substantial damageNTSB GAA18CA328Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Arlington, WAThe pilot’s overapplication of the brakes during the landing roll, which resulted in a nose-over.Jun 7, 2018 · N3202H · Substantial damageNTSB GAA18CA362Accident · No injuriesData collectionFinal reportPiper PA18 · Healy, AKThe pilot’s overapplication of the brakes during the landing roll, which resulted in a nose-over.Jun 4, 2018 · N57787 · Substantial damageNTSB GAA18CA337Accident · No injuriesData collectionFinal reportCessna 180 · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll.Jun 3, 2018 · N67WW · Substantial damageNTSB GAA18CA320Accident · No injuriesData collectionFinal reportPiper PA 12 · Nulato, AKThe pilot’s improper landing flare, which resulted in a hard landing on upsloping terrain, and his subsequent failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in…Jun 2, 2018 · N3937M · Substantial damageNTSB CEN18LA209Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Longview, TXThe pilot's failure to use carburetor heat for takeoff, which resulted in an interruption of continuous fuel flow to the engine and a loss of engine power during climb. Also causal was the lack of required placarding warning of the need to use full carburetor…Jun 1, 2018 · N72066 · Substantial damageNTSB GAA18CA330Accident · No injuriesData collectionFinal reportSorensen Danny S BF9 2 · Evanston, WYThe pilot’s failure to fuel the biplane’s main fuel tank before the flight and his inadequate preflight inspection, during which he did not verify the fuel quantity, which resulted in fuel exhaustionMay 31, 2018 · N81973 · Substantial damageNTSB GAA18CA311Accident · Minor injuriesData collectionFinal reportMaule M5 · Lewiston, IDThe pilot’s failure to maintain the runway centerline and his subsequent decision to not perform a go-around, which resulted in the main landing gear contacting tall wheat and a subsequent loss of control.May 28, 2018 · N5634Y · Substantial damageNTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.May 28, 2018 · N2004U · Substantial damageNTSB ANC18LA039Accident · No injuriesLimited investigationFinal reportCessna T182T · Yerington, NVLoss of directional control during landing for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.May 28, 2018 · N68AX · Substantial damageNTSB WPR18LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Aberdeen, IDThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and nose-over.May 27, 2018 · N5700B · Substantial damageNTSB GAA18CA301Accident · No injuriesData collectionFinal reportEldridge George Skystar Kitfox SER 7 · Weippe, IDThe pilot’s failure to maintain a proper approach altitude, which resulted in a collision with a fence.May 27, 2018 · N103GE · Substantial damageNTSB WPR18LA148Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Hillsboro, ORThe partial loss of engine power during a go-around due to the loose copper electrode finger inside the left magneto.May 26, 2018 · N152GB · Substantial damageNTSB GAA18CA298Accident · No injuriesData collectionFinal reportGarcia Benigno Baby ACE D · St. Johns, AZThe pilot’s failure to maintain directional control during landing in gusting, quartering tailwind conditions.May 23, 2018 · N4207D · Substantial damageNTSB GAA18CA297Accident · Minor injuriesData collectionFinal reportPiper PA22 · Start, LAThe pilot’s improper landing flare, which resulted in a bounced landing.May 23, 2018 · N4913Z · Substantial damageNTSB GAA18CA477Accident · Minor injuriesData collectionFinal reportDavidson, Ronald A. Avid · Moab, UTThe pilot's excessive brake application and delayed remedial action, which resulted in a nose over.May 19, 2018 · N833RD · Substantial damageNTSB CEN18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7A · Hanover Park, ILA partial loss of engine power shortly after takeoff due to water contamination of the fuel system.May 19, 2018 · N667AZ · Substantial damageNTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.May 18, 2018 · N7265K · Substantial damageNTSB CEN18LA178Accident · Minor injuriesClass 3 · LimitedFinal reportPeet Charles Zenith CH 701 · Jackson, WYA total loss of engine power for undetermined reasons, and the pilot’s failure to maintain proper control of the airplane, which led to a hard, bounced landing.May 16, 2018 · N44CP · Substantial damageNTSB GAA18CA266Accident · Minor injuriesData collectionFinal reportDiven Robert Nieuport 17 · Las Cruces, NMThe pilot’s failure to attain a positive climb rate after takeoff in high-density altitude conditions, which resulted in a collision with terrain.May 8, 2018 · N315BD · Substantial damageNTSB GAA18CA262Accident · No injuriesData collectionFinal reportCessna 182 · Albuquerque, NMThe pilot’s decision to continue flight in mountainous terrain with downdraft conditions, which necessitated a precautionary landing on unsuitable terrain.May 7, 2018 · N632EP · Substantial damageNTSB CEN18LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Broomfield, COThe overstress fracture of the upper link of the nose landing gear torque link assembly, which resulted in the pilot’s inability to maintain directional control during landing.May 7, 2018 · N3292Y · Substantial damage