Skip to content

NTSB investigations, 2008

22 cases where the sequence of events included Attempted remediation/recovery.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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" = '060' 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

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\" = '060' 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.

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" = '060' 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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN09FA099Accident · 1 fatalField investigationFinal reportPiper PA-32R · North Canton, OHThe pilot’s inappropriate control inputs as a result of spatial disorientation, which led to an aerodynamic stall and loss of control. Contributing to the accident were the pilot's decision to conduct flight into known icing conditions, ice accumulation that…Dec 19, 2008 · N9299N · Destroyed NTSB WPR09LA039Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Camas, WAA loss of engine power for undermined reasons. Contributing to the accident was the low altitude and airspeed, which precluded making a safe autorotation.Nov 17, 2008 · N2274U · Substantial damage NTSB CEN09TA060Accident · 1 fatalFinal reportBell OH-58C · Quitman, ARThe pilot’s failure to execute a proper autorotation during a forced landing after a loss of rotor rpm for undetermined reasons.Nov 16, 2008 · N153GF · Substantial damage NTSB WPR09CA023Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Temecula, CAThe certified flight instructor's failure to maintain adequate rotor rpm during a simulated approach to landing under variable wind, and high density altitude conditions.Oct 22, 2008 · N8356R · Substantial damage NTSB CEN09CA006Accident · Minor injuriesData collectionFinal reportBeech 23 · Chesaning, MIThe pilot's failure to adequately compensate for the gusting wind conditions during landing. Contributing to the accident were the gusting winds.Oct 9, 2008 · N317NF · Substantial damage NTSB SEA08CA215Accident · No injuriesData collectionFinal reportNorth American AT-6 · Arlington, WAThe front seated pilot's inadequate compensation for the right quartering tailwind and failure to maintain directional control. Also causal was the rear seated pilot's inadequate remedial action and failure to regain directional control.Oct 1, 2008 · N39313 · Substantial damage NTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.Sep 30, 2008 · N1012S · Substantial damage NTSB DFW08LA238Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Leadville, COThe flight instructor's failure to maintain control of the airplane while maneuvering at low altitude.Sep 29, 2008 · N736LN · Substantial damage NTSB MIA08CA202Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor's delayed remedial action during a simulated autorotation.Sep 25, 2008 · N1901M · Substantial damage NTSB DEN08IA160IncidentIncident investigationFinal reportRaytheon Cobra · Whetstone, AZA total off of engine power resulting from an overheated piston, and the pilot's subsequent failure to send a proper command to the UAS. Contributing to the accident was the operation of the engine at high power for an extended period with a lean fuel setting.Sep 24, 2008 · N602RN · Destroyed NTSB MIA08LA199Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Linden, NJThe flight instructor’s delayed remedial action (flight control inputs) during a practice autorotation/run-on landing resulting in fracture damage to the main rotor system Starflex.Sep 19, 2008 · N906BA · Substantial damage NTSB 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 damage NTSB CHI08LA273Accident · No injuriesLimited investigationFinal reportBeech C23 · Grayslake, ILThe inadequate flare by the student pilot and the inadequate supervision and delayed go-around performed by the flight instructor. Contributing to the accident were the student pilot's failure to attain/maintain a stabilized approach.Aug 28, 2008 · N6664N · Substantial damage NTSB SEA08TA188Accident · No injuriesFinal reportHughes 369D · Bonners Ferry, IDThe pilot's inadequate preflight planning for the takeoff and the helicopter loading that exceeded the lift performance capability of the helicopter.Aug 18, 2008 · N622PB · Substantial damage NTSB MIA08LA166Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Woodbine, NJThe student pilot's failure to maintain airspeed during a go-around. Contributing to the accident was the student pilot's degraded emotional/mental state due to stress.Aug 16, 2008 · N494ES · Substantial damage NTSB SEA08LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Big Creek, IDThe pilot's delayed decision to abort the landing and failure to achieve the proper touchdown point. Contributing to the accident was a high density altitude.Jul 7, 2008 · N5652Q · Substantial damage NTSB DFW08CA174Accident · No injuriesData collectionFinal reportCessna 177 · Baldwin City, KSThe pilot's loss of directional control resulting from a hard landing and failure to recover from a bounced landing. Contributing to the accident was the crosswind.Jun 28, 2008 · N3337T · Substantial damage NTSB DEN08LA113Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachutes Condor · Brookfield, MOthe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of familiarity and experience in the accident aircraft.Jun 20, 2008 · N3150U · Substantial damage NTSB CHI08IA152Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Chicago, ILThe airplane manufacturer's inadequate software design requirements of the engine's full authority digital electronic controls (FADEC) fault logic that resulted in a simultaneous unrecoverable loss of thrust control on both engines when the FADEC's input data…Jun 5, 2008 · N612KB · No damage NTSB LAX08FA092Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Benson, AZThe pilot's misjudged speed and altitude during approach that led to a long landing and his subsequent failure to maintain control during an attempted go-around. Contributing to the accident were the dark night, the pilot's low total night flight experience,…Apr 3, 2008 · N20480 · Substantial damage NTSB DFW08IA087Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Houston, TXThe flight crew's improper landing technique for an inoperative anti-skid system resulting in locked brakes and four blown main landing gear tires.Mar 27, 2008 · N23661 · Minor damage NTSB DFW08FA056Accident · 1 fatalField investigationFinal reportAero Commander 500B · Tulsa, OKThe pilot's loss of control due to spatial disorientation and the pilot exceeding the design/stress limits of the aircraft. Factors contributing to the accident were the pilot's reported gyro problem, the dark night conditions , and prevailing instrument…Jan 17, 2008 · N712AT · Substantial damage