NTSB investigations, 2008

263 cases where the sequence of events included Loss of control on ground.

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\") = 2008
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' 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 SEA08CA214Accident · No injuriesData collectionFinal reportLaird LC-1B-300 · Spokane, WAThe pilot’s misjudged landing flare that resulted in a hard landing. A contributing factor was the impact related failure of the tail wheel spring attachment bolts due to overload, which resulted in a ground loop.Sep 30, 2008 · N10402 · Substantial damageNTSB CHI08CA295Accident · Minor injuriesData collectionFinal reportNorth American Harvard MK · Dayton, OHImproper maintenance on the tail wheel anti-shimmy mechanism and the pilot's decision to continue operating the airplane with a known shimmy in the tail wheel.Sep 28, 2008 · N9272C · Substantial damageNTSB SEA08CA212Accident · No injuriesData collectionFinal reportSport Flight International Astra · Spokane, WAThe pilot's excessive use of brakes and failure to maintain directional control during the landing roll.Sep 27, 2008 · N3115C · Substantial damageNTSB CHI08LA286Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Delaware, OHThe student pilot's failure to maintain directional control during landing.Sep 24, 2008 · N63DH · Substantial damageNTSB CHI08LA297Accident · Serious injuriesLimited investigationFinal reportPowrachute Pegasus · New London, WIThe pilot's loss of directional control during landing due to failure of the nose wheel support as a result of an inadequate weld.Sep 20, 2008 · N7084L · Minor damageNTSB CHI08CA289Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Crookston, MNThe pilot's failure to maintain directional control during landing and the flight instructor's delayed remedial action.Sep 19, 2008 · N18ND · Substantial damageNTSB SEA08CA204Accident · No injuriesData collectionFinal reportGoetz RAF 2000 · Mulino, ORThe pilot's failure to maintain directional control during landing.Sep 18, 2008 · N554BG · Substantial damageNTSB DEN08CA156Accident · No injuriesData collectionFinal reportCessna 177RG · Ellsworth, KSThe student pilot's failure to maintain directional control during the landing roll.Sep 18, 2008 · N8276G · Substantial damageNTSB SEA08CA201Accident · No injuriesData collectionFinal reportStinson 108-1 · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing.Sep 16, 2008 · N8963K · Substantial damageNTSB ANC08CA124Accident · No injuriesData collectionFinal reportPiper PA-12 · Slana, AKThe pilot's excessive application of the brakes during the landing roll, resulting in a nose over and substantial damage.Sep 14, 2008 · N3348M · Substantial damageNTSB SEA08CA198Accident · No injuriesData collectionFinal reportCessna 152 · Columbia, CAThe student pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot's improper use of the throttle control.Sep 13, 2008 · N24342 · Substantial damageNTSB MIA08LA195Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Clearwater, FLThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the pilot's improper use of a supplemental cockpit lighting during approach.Sep 12, 2008 · N4757V · Substantial damageNTSB DFW08LA231Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Roanoke, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's lack of flight experience in the make and model of airplane.Sep 12, 2008 · N901LA · Substantial damageNTSB NYC08CA313Accident · No injuriesData collectionFinal reportDiamond Aircraft Industry DA 20-C1 · Stevensville, MDThe student pilot's failure to maintain directional control during takeoff.Sep 11, 2008 · N644DC · Substantial damageNTSB LAX08CA293Accident · No injuriesData collectionFinal reportBrubaker F1 · Truckee, CAThe failure of the bolts securing the tail wheel to its attach point that resulted in a loss of directional control.Sep 11, 2008 · N954CB · Substantial damageNTSB DEN08CA154Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Leadville, COThe pilot's failure to maintain aircraft control during takeoff.Sep 5, 2008 · N9813C · Substantial damageNTSB ANC08CA118Accident · No injuriesData collectionFinal reportDiehl William A S-4 · Galena, AKThe pilot's failure to maintain pitch control of the airplane during takeoff, and the pilot's inadequate preflight inspection of the airplane.Sep 5, 2008 · N4BZ · Substantial damageNTSB SEA08CA197Accident · No injuriesData collectionFinal reportCessna A185F · Lakeview, ORThe pilot's failure to maintain directional control. A contributing factor was the rough terrain.Sep 4, 2008 · N185ZZ · Substantial damageNTSB DFW08CA221Accident · No injuriesData collectionFinal reportCessna 560 · Telluride, COThe pilot's failure to maintain control during landing. A factor was the reported wind shear.Sep 1, 2008 · N839QS · Substantial damageNTSB DEN08CA147Accident · No injuriesData collectionFinal reportPiper PA-22 · Star City, ARThe pilot failed to maintain directional control during landing. Contributing to the accident were the crosswinds and the rough terrain near the runway.Sep 1, 2008 · N7253D · Substantial damageNTSB LAX08CA287Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Dillon, MTThe pilot-certificated passenger's failure to maintain directional control during landing and the pilot's delayed remedial action and inadequate supervision.Aug 31, 2008 · N4143D · Substantial damageNTSB CHI08LA288Accident · No injuriesLimited investigationFinal reportFantasy Air Sro Allegro 20 · Walworth, WIThe pilot's failure to maintain directional control during landing.Aug 31, 2008 · N1005W · Substantial damageNTSB MIA08CA184Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Pantego, NCThe pilot's failure to maintain directional control on the landing roll out.Aug 29, 2008 · N8137K · Substantial damageNTSB LAX08CA285Accident · No injuriesData collectionFinal reportMason Falconar F-11 · Creswell, ORThe pilot's failure to maintain a stabilized approach, inadequate recovery from a bounced landing, and failure to maintain directional control.Aug 28, 2008 · N65017 · Substantial damageNTSB DEN08CA146Accident · No injuriesData collectionFinal reportHelie RV-6 · Denver, COThe pilot failed to maintain directional control during landing. Contributing to the accident was the crosswind.Aug 28, 2008 · N190RV · Substantial damageNTSB LAX08CA280Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Wasco, ORThe pilot's failure to maintain directional control while landing.Aug 23, 2008 · N2870D · Substantial damageNTSB CHI08CA262Accident · No injuriesData collectionFinal reportSchweizer G-164B · Nielsville, MNThe pilot's failure to maintain directional control of the airplane during the crosswind landing. Factors associated with the accident were the crosswind and the rough terrain.Aug 23, 2008 · N773D · Substantial damageNTSB NYC08LA291Accident · No injuriesLimited investigationFinal reportCessna 441 · Baltimore, MDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the pilot's attempted takeoff with a propeller start lock inadvertently engaged.Aug 20, 2008 · N441VB · Substantial damageNTSB LAX08CA270Accident · No injuriesData collectionFinal reportCessna 182Q · Mesa, AZThe pilot's failure to maintain directional control during landing.Aug 20, 2008 · N95841 · Substantial damageNTSB ANC08TA107Accident · No injuriesFinal reportPiper PA-18-150 · Slana, AKThe pilot's failure to maintain directional control during an aborted takeoff.Aug 19, 2008 · N4151T · Substantial damageNTSB SEA08CA181Accident · No injuriesData collectionFinal reportEberle Pitts S1S · Show Low, AZThe pilot failed to maintain directional control during landing. Contributing to the accident was the pilot's limited experience in the airplane.Aug 17, 2008 · N39124 · Substantial damageNTSB SEA08CA186Accident · No injuriesData collectionFinal reportCessna 140A · Lowman, IDThe pilot's failure to maintain directional control during the landing roll.Aug 16, 2008 · N1161D · Substantial damageNTSB CHI08CA256Accident · Minor injuriesData collectionFinal reportCessna 172N · Huntington, INThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot's inadvertent use of the toe brake.Aug 16, 2008 · N733KC · Substantial damageNTSB NYC08CA283Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Cleveland, GAThe pilot's improper decision to land with a tailwind, and his failure to maintain aircraft control during the landing. Contributing to the accident was the tailwind.Aug 15, 2008 · N8906D · Substantial damageNTSB ANC08CA105Accident · Minor injuriesData collectionFinal reportWalker AK Bush Flyer · Deadhorse, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor contributing to the accident was a tailwind.Aug 14, 2008 · N799CC · Substantial damageNTSB DEN08CA142Accident · No injuriesData collectionFinal reportAerotek Pitts Special S-1S · Crawford, COthe pilot's failure to maintain directional control during takeoff. Contributing to the accident were wind gusts and rough terrain.Aug 13, 2008 · N362JW · Substantial damageNTSB DEN08CA136Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Dexter, NMThe pilot's failure to maintain directional control of the airplane.Aug 9, 2008 · N4555Y · Substantial damageNTSB CHI08CA249Accident · No injuriesData collectionFinal reportMorane-Saulnier MS-760/B · St Paul, MNRestriction of the elevator controls due to the presence of the seat belt buckled around the co-pilot control stick. An additional cause was the failure of the pilot to verify that the flight controls were unobstructed before flight. Contributing factors were…Aug 9, 2008 · N69X · Substantial damageNTSB CHI08CA247Accident · No injuriesData collectionFinal reportBellanca 17-30A · Waukegan, ILThe pilot's inability to maintain directional control of the airplane following a failure of the right brake.Aug 9, 2008 · N1289R · Substantial damageNTSB ANC08CA102Accident · No injuriesData collectionFinal reportCessna 182 · Cantwell, AKThe pilot's misjudged distance while step-taxiing after landing. Factors in the accident were rain showers, wind, and spray from the airplane's propeller.Aug 9, 2008 · N82Y · Substantial damageNTSB ANC08LA101Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's excessive speed and excessive application of brakes during the landing roll on soft, sandy terrain.Aug 7, 2008 · N82057 · Substantial damageNTSB ANC08TA099Accident · No injuriesFinal reportPiper PA-18 · Nome, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll.Aug 6, 2008 · N7055 · 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 damageNTSB SEA08CA171Accident · No injuriesData collectionFinal reportde Havilland Beaver DHC-2 MK.1 · Kenmore, WAThe pilot's failure to maintain aircraft control while water taxiing. Contributing to the accident were the pilot's failure to compensate for the wind condition and a tailwind.Aug 4, 2008 · N53BV · Substantial damageNTSB NYC08CA269Accident · Minor injuriesData collectionFinal reportCessna 172M · Jefferson, NCA loss of directional control during the takeoff roll for undetermined reasons. Contributing to the severity of the event was the descending embankment adjacent to the runway.Aug 3, 2008 · N73594 · Substantial damageNTSB LAX08CA255Accident · No injuriesData collectionFinal reportPiper PA-20 · Grass Valley, CAThe pilot's failure to maintain directional control due to his foot slipping off one rudder pedal while braking.Aug 3, 2008 · N7635K · Substantial damageNTSB ANC08LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain directional control during the landing flare/touchdown, which resulted in a runway excursion and collapse of the nose gear.Aug 2, 2008 · N2357U · Substantial damageNTSB DFW08CA202Accident · No injuriesData collectionFinal reportNorth American P-51D · Tulsa, OKThe pilot's failure to maintain aircraft control during takeoff.Jul 29, 2008 · N551W · Substantial damageNTSB ANC08LA093Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKThe pilot's failure to maintain directional control during an aborted landing.Jul 29, 2008 · N9952M · Substantial damageNTSB LAX08CA257Accident · No injuriesData collectionFinal reportCessna 150M · Phoenix, AZThe student pilot's failure to maintain directional control during a touch-and-go landing.Jul 28, 2008 · N704JD · Substantial damage