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 DEN08CA063Accident · No injuriesData collectionFinal reportPiper PA-22 · Nickerson, KSthe pilot's failure to maintain directional control during the landing roll resulting in a departure from the runway environment. Contributing to the accident was the soft runway surface.Mar 10, 2008 · N1424A · Substantial damageNTSB LAX08CA072Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Tucson, AZThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.Mar 2, 2008 · N22TE · Substantial damageNTSB LAX08CA070Accident · No injuriesData collectionFinal reportCessna 170B · Truckee, CAThe pilot's continued operation with a known mechanical problem and failure to maintain directional control.Feb 29, 2008 · N2571D · Substantial damageNTSB MIA08CA067Accident · Minor injuriesData collectionFinal reportWaco CTO · Venice, FLThe pilot's improper use of brakes during the landing roll.Feb 25, 2008 · N845V · Substantial damageNTSB NYC08LA106Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Pahokee, FLThe pilot's decision to depart with a known deficiency with the engine, which resulted in a loss of engine power. Contributing to the accident was the loss of engine power due to the failure of the engine-driven fuel pump.Feb 20, 2008 · N36GJ · Substantial damageNTSB CHI08CA084Accident · No injuriesData collectionFinal reportCessna 150G · Viroqua, WIThe pilot not maintaining directional control during the landing and the ground loop the pilot encountered. A factor was the crosswind.Feb 16, 2008 · N10RH · Substantial damageNTSB NYC08CA101Accident · No injuriesData collectionFinal reportCessna 182K · Greenville, METhe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the snow covered runway and sun glare light conditions.Feb 15, 2008 · N3047Q · Substantial damageNTSB SEA08CA074Accident · No injuriesData collectionFinal reportMaule M-7-235 · Red Lodge, MTThe pilot's inadequate compensation for the crosswind and failure to maintain directional control during the landing roll.Feb 10, 2008 · N997RM · Substantial damageNTSB SEA08CA075Accident · No injuriesData collectionFinal reportCessna 140 · Logan, UTThe dual-student's excessive brake application, and the flight instructor's inadequate supervision of the flight.Feb 9, 2008 · N72957 · Substantial damageNTSB CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.Feb 6, 2008 · N9483L · Substantial damageNTSB DFW08LA058Accident · No injuriesLimited investigationFinal reportPiper PA32-301FT · Wiggins, MSThe failure of the fuel servo gasket and subsequent partial loss of engine power. Contributing to the accident was the none-suitable terrain for the forced landing.Jan 28, 2008 · N1053F · Substantial damageNTSB NYC08LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-R200 · York, SCLoss of engine power due to improper welding of the crankcase, which resulted in fatigue failure of the through-studs and a subsequent separation of the number two cylinder. Contributing to the accident was the unsuitable terrain for a forced landing.Jan 25, 2008 · N1939T · Substantial damageNTSB LAX08CA053Accident · Minor injuriesData collectionFinal reportCessna 172N · Beaver Marsh, ORThe pilot's inadequate in-flight planning/decision to land on a snow covered runway without first determining the depth of the snow.Jan 25, 2008 · N734KU · Substantial damageNTSB CHI08CA069Accident · No injuriesData collectionFinal reportCessna 172N · South St. Paul, MNThe student pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident were the snow-covered runway and the gusty wind conditions.Jan 22, 2008 · N738UE · Substantial damageNTSB LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.Jan 20, 2008 · N71730 · Substantial damageNTSB SEA08LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Centerville, WAA loss of engine power due to carburetor icing conditions and the failure of the pilot to use the correct amount of carburetor heat for the existing conditions.Jan 13, 2008 · N7243V · Substantial damageNTSB NYC08CA080Accident · No injuriesData collectionFinal reportCessna C-152 · Labelle, FLThe pilot's improper decision to takeoff from an inadequate field after a forced landing.Jan 11, 2008 · N48251 · Substantial damageNTSB NYC08CA079Accident · No injuriesData collectionFinal reportCessna 150G · Sarasota, FLThe pilot's improper preflight and in-flight planning which resulted in a loss of engine power due to fuel exhaustion.Jan 10, 2008 · N2490J · Substantial damageNTSB LAX08CA044Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Exeter, CAThe pilot's failure to maintain directional control.Jan 7, 2008 · N30WH · Substantial damage