NTSB investigations, 2008

119 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\") = 2008
    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 NYC08LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Surfside Beach, SCA loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.Jul 15, 2008 · N4287Z · Substantial damageNTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.Jul 12, 2008 · N1066M · Substantial damageNTSB NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.Jul 12, 2008 · N7395 · Substantial damageNTSB LAX08LA226Accident · No injuriesLimited investigationFinal reportJonsson Sonerai · Hood River, ORThe pilot's failure to maintain directional control during the emergency landing roll with a tailwind. Contributing was the partial separation of the left aileron that prompted the pilot to attempt the emergency landing.Jul 11, 2008 · N8050R · Substantial damageNTSB LAX08CA220Accident · Serious injuriesData collectionFinal reportDavid Jarrett Searey · Ennis Lake, MTThe pilot's failure to retract the landing gear prior to landing on the water.Jul 9, 2008 · N24YD · Substantial damageNTSB LAX08CA227Accident · Minor injuriesData collectionFinal reportBeech E17B · Hubbard, ORThe pilot's improper use of brakes during the landing rollout.Jul 8, 2008 · N233EB · Substantial damageNTSB CHI08CA184Accident · No injuriesData collectionFinal reportHuebner RV6-A · Jerseyville, ILThe muddy, unsuitable terrain encountered during the landing.Jul 8, 2008 · N653DF · Substantial damageNTSB NYC08CA240Accident · No injuriesData collectionFinal reportCessna C-195 · Johnstown, NYThe pilot's failure to maintain aircraft control during the landing roll.Jul 5, 2008 · N4380N · Substantial damageNTSB LAX08CA208Accident · No injuriesData collectionFinal reportPipistrel Virus 912 · Bend, ORThe pilot's improper flare, inadequate bounced landing recovery, and his failure to maintain directional control.Jul 1, 2008 · N126BF · Substantial damageNTSB ANC08CA084Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Anchorage, AKThe pilot's selection of an unsuitable landing area.Jun 30, 2008 · N87061 · Substantial damageNTSB ANC08CA080Accident · No injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's selection of an unsuitable landing area.Jun 30, 2008 · N2951M · Substantial damageNTSB NYC08CA232Accident · Minor injuriesData collectionFinal reportYowell Mallard II · Groveland, FLThe pilot's failure to use the checklist and his failure to retract the landing gear for a water landing. Contributing to the accident was the pilot's diverted attention.Jun 29, 2008 · N463AT · Substantial damageNTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.Jun 29, 2008 · N83056 · Substantial damageNTSB MIA08LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hollywood, FLThe pilot's failure to achieve the proper touchdown point on landing and improper use of brakes. Contributing to the accident was the failure of the throttle cable attachment tab due to preexisting cracks.Jun 28, 2008 · N3257B · Substantial damageNTSB LAX08LA201Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Rainier, ORThe inadvertent extension of the left float's landing gear to near the down position due to a failure of the gear's rear hydraulic seal.Jun 28, 2008 · N5403E · Substantial damageNTSB DFW08CA175Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Pueblo, COThe pilot's failure to maintain directional control during landing. Contributing to the accident were the wind gust and tailwind.Jun 28, 2008 · N2879T · Substantial damageNTSB DEN08LA110Accident · No injuriesLimited investigationFinal reportCessna R172K · Goldsby, OKThe pilot's delay in initiating rejected takeoff procedures, resulting in the airplane going off the end of the runway and nosing over.Jun 21, 2008 · N1439V · Substantial damageNTSB ANC08LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKA partial loss of engine power during an aborted landing for an undetermined reason, which resulted in a collision with terrain and subsequent nose over.Jun 21, 2008 · N91256 · Substantial damageNTSB LAX08LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wilder, IDThe loss of engine power as a result of failure of the supercharger. Contributing to the accident was the lack of suitable terrain for the forced landing.Jun 13, 2008 · N48571 · Substantial damageNTSB LAX08CA174Accident · Minor injuriesData collectionFinal reportCessna 182 · Cottage Grove, ORThe pilot's misjudged landing flare.Jun 10, 2008 · N182RA · Substantial damageNTSB LAX08CA167Accident · No injuriesData collectionFinal reportCessna 182 · Moab, UTThe pilot's inadequate compensation for the tailwind condition, and improper use of additional power while taxiing. Contributing to the accident was soft ground and a gusting tailwind.Jun 7, 2008 · N2375G · Substantial damageNTSB CHI08CA155Accident · No injuriesData collectionFinal reportCessna 180 · Eveleth, MNThe pilot elected to land on a grass airstrip that was unsuitable for landing due to the wet, soft runway conditions. The wet, soft runway were factors.Jun 7, 2008 · N4701U · Substantial damageNTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.Jun 4, 2008 · N1437Y · Substantial damageNTSB NYC08CA203Accident · No injuriesData collectionFinal reportCessna 180 · Kutztown, PAThe pilot's failure to maintain aircraft control.May 29, 2008 · N511MH · Substantial damageNTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.May 25, 2008 · N312DC · Substantial damageNTSB LAX08FA144Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 MK I · Stehekin, WAThe pilot's failure to retract the landing gear wheels prior to performing a water landing. Contributing to the accident were the pilot's disabling of the landing gear warning/advisory system and possible fatigue due to his work schedule.May 17, 2008 · N9558Q · Substantial damageNTSB LAX08CA143Accident · No injuriesData collectionFinal reportMason RV-9A · Pacific City, ORThe pilot's inadequate flare and failure to maintain control following a hard landing. Contributing to the accident was a temporary partial loss of power due to carburetor icing conditions.May 17, 2008 · N486EM · Substantial damageNTSB CHI08CA130Accident · No injuriesData collectionFinal reportCessna 150 · Pulaski, WIThe student pilot's failure to take remedial action in response to a porpoise/pilot-induced oscillation during landing. Factors were the porpoise, the pilot's lack of experience, and the separation of the nose landing gear.May 14, 2008 · N22997 · Substantial damageNTSB ANC08CA066Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's inadvertent activation of the main landing gear brakes during the recovery from a bounced landing.May 11, 2008 · N323KT · Substantial damageNTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…May 10, 2008 · N610RD · Substantial damageNTSB LAX08LA135Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Oljato, UTThe pilot's failure to achieve a normal touchdown location and loss of directional control during landing roll out. Contributing to the accident were the runway's soft surface and short length.May 9, 2008 · N9030E · Substantial damageNTSB LAX08LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Butte City, CAA total loss of engine power during takeoff due to fuel exhaustion as a result of the pilot's failure to verify the fuel quantity prior to flight.May 6, 2008 · N703Y · Substantial damageNTSB MIA08LA101Accident · No injuriesLimited investigationFinal reportHigher Class Sport Hornet · Appling, GAThe interruption of fuel flow for undetermined reasons, resulting in a loss of engine power during flight.May 4, 2008 · N104HC · Substantial damageNTSB LAX08CA129Accident · No injuriesData collectionFinal reportCessna A185F · Mexican Hat, UTThe pilot's failure to maintain directional control.May 3, 2008 · N185KH · Substantial damageNTSB SEA08CA118Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Libby, MTThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during the landing rollout.May 2, 2008 · N1083 · Substantial damageNTSB CHI08CA118Accident · No injuriesData collectionFinal reportLuscombe 8A · Remus, MIThe loss of engine power during approach due to fuel contamination. Contributing to the accident were the unsuitable terrain and a tree.Apr 30, 2008 · N28403 · Substantial damageNTSB SEA08CA111Accident · Minor injuriesData collectionFinal reportAviat A-1C-200 · Bluff, UTThe pilot's inadequate short-field landing procedure and excessive airspeed that resulted in a landing overrun. Contributing to the accident were gusting unfavorable winds, the short runway, and rocks off the departure end of the strip.Apr 24, 2008 · N134DD · Substantial damageNTSB ANC08CA056Accident · No injuriesData collectionFinal reportAeronca 15AC · Anchorage, AKThe pilot's excessive use of brakes during the landing roll. A factor was an excessive taxispeed.Apr 24, 2008 · N1452H · Substantial damageNTSB CHI08LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Fairfax, IAFuel exhaustion as a result of the pilot's inadequate preflight inspection and inaccurate fuel calculations.Apr 21, 2008 · N9832G · Substantial damageNTSB NYC08CA161Accident · Minor injuriesData collectionFinal reportCessna 152K · Okeechobee, FLThe loss of engine power during cruise flight due to fuel contamination, and the pilot's inadequate preflight inspection.Apr 14, 2008 · N67334 · Substantial damageNTSB LAX08CA106Accident · No injuriesData collectionFinal reportMaule M-5-235C · Monroe, WAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing rollout.Apr 12, 2008 · N9277E · Substantial damageNTSB LAX08CA100Accident · Minor injuriesData collectionFinal reportQuestair Venture · Salt Lake City, UTThe failure of the left side master brake cylinder that led to a loss of braking capability during landing rollout. A contributing factor was the presence of a ditch next to the runway's end.Apr 12, 2008 · N36V · Substantial damageNTSB MIA08CA088Accident · Serious injuriesData collectionFinal reportWilliam E. Furr SeaRey · Winter Springs, FLThe pilot's inadequate preflight inspection of the airplane.Apr 10, 2008 · N815Z · Substantial damageNTSB NYC08CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Lincoln, METhe pilot-rated-passenger's failure to maintain directional control during takeoff.Apr 6, 2008 · N2209K · Substantial damageNTSB ANC08LA047Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ugashik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over. A factor contributing to the accident was water on the surface of the ice-covered lake.Apr 1, 2008 · N5840Z · Substantial damageNTSB CHI08CA094Accident · No injuriesData collectionFinal reportCessna 182 · Traverse City, MIThe unstabalized approach performed by the student pilot and the go-around not performed by the student pilot. Additional causes were the inadequate recovery from a bounced landing and the directional control not obtained by the student pilot. Contributing…Mar 26, 2008 · N5338B · Substantial damageNTSB LAX08LA083Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Genesee, IDThe in-flight failure of the rudder attachment point due to severe corrosion, which made directional control of the airplane not possible during landing.Mar 22, 2008 · N8148K · Substantial damageNTSB DEN08LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Glenwood Spring, COThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was the strong left quartering tailwind and gust.Mar 18, 2008 · N67WW · Substantial damageNTSB ANC08CA043Accident · Minor injuriesData collectionFinal reportStinson 108 · Chugiak, AKThe reversal of the aileron control cables by maintenance personnel, and the pilot's inadequate preflight inspection.Mar 14, 2008 · N6827M · Substantial damageNTSB LAX08CA074Accident · Minor injuriesData collectionFinal reportCessna 172M · Richfield, UTThe pilot's improper use of the flight controls and failure to maintain directional control.Mar 11, 2008 · N80318 · Substantial damage