NTSB investigations, 2008

62 cases where the sequence of events included Miscellaneous/other.

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\" = '900' 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 LAX08LA097Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Denio, NVThe pilot's inadvertent hard landing induced by a perceived loss of power and a main transmission anomaly while maneuvering at low altitude.Apr 11, 2008 · N24SD · Substantial damageNTSB NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.Apr 3, 2008 · N1755T · Substantial damageNTSB SEA08IA096Incident · No injuriesIncident investigationFinal reportRaytheon 1900D · Page, AZThe flight crew’s unprofessional behavior and deviation from standard operating procedures which resulted in an in-flight emergency.Mar 26, 2008 · N261GL · Minor damageNTSB MIA08CA072Accident · No injuriesData collectionFinal reportEurocopter France AS350B1 · Linden, NJThe pilot's improper preflight preparation and his failure to maintain control of the helicopter.Mar 4, 2008 · N152TA · Substantial damageNTSB MIA08CA065Accident · Serious injuriesData collectionFinal reportEmbraer EMB-145LR · Covington, KYThe flight attendant's inadvertent slip on the galley's contaminated floor and falling during climb to cruise.Feb 15, 2008 · N569RP · No damageNTSB SEA08IA080Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Hilo, HIThe captain and first officer inadvertently falling asleep during the cruise phase of flight. Contributing to the incident were the captain's undiagnosed obstructive sleep apnea and the flight crew’s recent work schedules, which included several consecutive…Feb 13, 2008 · N651BR · No damageNTSB SEA08LA072Accident · 3 fatalLimited investigationFinal reportWooters Lancair ES · Albany, ORThe pilot-in-command's failure to maintain aircraft control while in cruise flight. Contributing to the accident were inadequate planning/decision, icing conditions, and continued flight into known icing conditions.Feb 8, 2008 · N329BW · Substantial damageNTSB DFW08CA064Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Houston, TXThe student pilot's improper use of the collective and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.Feb 8, 2008 · N2364B · Substantial damageNTSB OPS08IA006Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · St. Augustine, FLThe pilot's failure to adhere to the controller's takeoff instruction. Contributing to the incident was the controller's failure to properly monitor the flight, and the controller's decision to perform lesser duty priorities during the takeoff roll.Feb 7, 2008 · N140FT · Minor damageNTSB DFW08CA071Incident · No injuriesData collectionFinal reportCessna 172S · Austin, TXThe pilot's failure to maintain control of the airplane while parked on the ramp with the engine running.Feb 6, 2008 · N53564 · Minor damageNTSB MIA08CA049Accident · Serious injuriesData collectionFinal reportAirborne Redback · Jefferson, GAThe failure of the pilot-in-command to maintain control of the airplane and his poor weather evaluation before attempting to taxi the airplane. A factor in the accident was the failure of airport personnel to correct the inaccurate wind information reported…Jan 30, 2008 · N1847 · Substantial damageNTSB ANC08IA033Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Dutch Harbor, AKThe disengagement of the rudder control cable and loose rudder cable retaining pins. A factor contributing to the accident was a wind gust.Jan 18, 2008 · N41NE · No damage