NTSB investigations, MO

72 cases where the sequence of events included Runway excursion.

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 c.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' 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 CEN12LA642Accident · No injuriesLimited investigationFinal reportAeropro CZ A240 · Greenfield, MOThe pilot's failure to attain a proper takeoff speed or pitch attitude during takeoff, which resulted in the airplane settling on the runway and impacting trees.Aug 19, 2012 · N812S · Substantial damageNTSB CEN12CA450Accident · No injuriesData collectionFinal reportCessna 195B · Camdenton, MOThe pilot's loss of directional control on landing, which resulted in a runway excursion.Jul 14, 2012 · N3092B · Substantial damageNTSB CEN12CA399Accident · No injuriesData collectionFinal reportEdson Robert W Pietenpol AIR Camper · Point Lookout, MOThe pilot's failure to maintain directional control during landing, resulting in a ground-loop.Jun 21, 2012 · N53WE · Substantial damageNTSB CEN12CA361Accident · No injuriesData collectionFinal reportCessna 172H · Moscow Mills, MOThe pilot's failure to maintain control of the airplane during takeoff in a gusty crosswind, which resulted in a runway excursion.Jun 10, 2012 · N3736R · Substantial damageNTSB CEN12CA293Accident · No injuriesData collectionFinal reportCessna 152 · Lee's Summit, MOThe student pilot’s loss of directional control while landing.Apr 9, 2012 · N25212 · Substantial damageNTSB CEN12CA193Accident · No injuriesData collectionFinal reportBellanca 17-30A · Branson, MOThe pilot did not maintain directional control of the airplane while landing with a gusting crosswind.Mar 17, 2012 · N801RC · Substantial damageNTSB CEN12LA147Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Kansas City, MOThe failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.Feb 2, 2012 · N6564V · Substantial damageNTSB CEN11CA675Accident · No injuriesData collectionFinal reportCessna T210R · Lamar, MOThe pilot's inadequate compensation for the wind condition, resulting in a runway excursion.Sep 29, 2011 · N84MC · Substantial damageNTSB CEN11LA542Accident · No injuriesLimited investigationFinal reportT&T Falcon LS · Lee's Summit, MOA binding condition in the left rudder cable which resulted in a loss of directional control during landing.Aug 1, 2011 · N785TT · Substantial damageNTSB CEN11LA494Accident · No injuriesLimited investigationFinal reportCessna T210L · Columbia, MOThe collapse of the right main landing gear during landing due to a lack of component lubrication, which resulted in the failure of the landing gear to lock once extended.Jul 20, 2011 · N2056S · Substantial damageNTSB CEN10CA481Accident · Serious injuriesData collectionFinal reportOliver A Bruce RV6-A · Trenton, MOThe canopy opening shortly after takeoff due to an inadequate repair and subsequent failure of the canopy latch, resulting in a emergency landing. Contributing to the accident was the lack of available runway remaining for the forced landing.Aug 15, 2010 · N50BU · Substantial damageNTSB CEN10CA258Accident · No injuriesData collectionFinal reportCalcote Clarence E Glasair RG · Lee's Summit, MOThe failure of the landing gear to fully extend and lock in the down position for unknown reasons.May 18, 2010 · N236CC · Substantial damageNTSB CEN10CA116Accident · No injuriesData collectionFinal reportPiper PA-31T · Columbia, MOThe pilot's failure to verify that the landing gear was fully extended prior to landing.Feb 4, 2010 · N723JP · 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 CEN09LA389Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · St. Louis, MOThe pilot’s failure to establish and maintain a stabilized final approach which resulted in a hard landing and runway overrun.Jun 25, 2009 · N701PT · 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 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 CEN09CA259Accident · No injuriesData collectionFinal reportZenith CH-250 · Hollister, MOThe pilot's failure to maintain directional control during landing.Apr 20, 2009 · N931CE · Substantial damageNTSB CEN09LA100Accident · No injuriesLimited investigationFinal reportBeechcraft 390 · Lewistown, MOThe pilot's loss of directional control during landing on an ice-contaminated runway.Dec 23, 2008 · N20NL · Substantial damageNTSB CEN09CA066Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Bowling Green, MOFailure of the pilot to maintain aircraft control during the landing sequence. A contributing factor was the sudden gusty crosswind.Nov 14, 2008 · N5432Z · Substantial damageNTSB CEN09CA076Accident · No injuriesData collectionFinal reportCessna 170A · Butler, MOThe pilot's failure to maintain directional control and his failure to compensate for wind conditions which resulted in a ground loop.Oct 24, 2008 · N5773C · Substantial damageNTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.Aug 5, 2008 · N411EV · Substantial damage