NTSB investigations, 2008

753 cases where the sequence of events included Collision with terr/obj (non-CFIT).

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\" = '470' 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 ERA09LA043Accident · 1 fatalLimited investigationFinal reportMiller J Kirtley RV-6 · Martinsville, VAThe pilot's failure to maintain aircraft control during the initial climb after an aborted landing. Contributing to the accident was the pilot's impairment from an over-the-counter sedating antihistamine.Nov 7, 2008 · N8LK · Substantial damageNTSB CEN09LA051Accident · Serious injuriesLimited investigationFinal reportJohnson Leonard G Cozy MK-IV · Osceola, MOA total loss of engine power due to an obstruction of airflow as a result of the pilot's inadvertent actuation of the landing brake.Nov 5, 2008 · N637PS · Substantial damageNTSB CEN09RA052Accident · 1 fatalForeign investigationBeech 200 · Punta Chivato, MexicoOn November 3, 2008 at approximately 1800 pacific standard time (PST) a twin-engine turbo prop, Beechcraft BE200, N200JL, was destroyed when it impacted terrain shortly after takeoff from Punta Chivato Airstrip, located near Punto Chivato, Baja California…Nov 4, 2008 · N200JL · DestroyedNTSB ERA09FA036Accident · 1 fatalField investigationFinal reportRobinson R-44 · Gallatin, TNThe pilot's inadvertent descent into water as a result of the dark night and limited outside visual references.Nov 3, 2008 · N300FX · Substantial damageNTSB ANC09LA009Accident · Minor injuriesLimited investigationFinal reportConstrucciones Aeronauticas CASA-212 · Toksook Bay, AKThe flight crew’s inability to adjust/increase power to the right engine during the landing approach due to an in-flight disconnect of the engine power control linkage, resulting in a loss of control of the airplane. Contributing to the accident was the…Nov 2, 2008 · N437RA · Substantial damageNTSB ERA09CA046Accident · No injuriesData collectionFinal reportHilderson Oswald Aventura HP · Weirwood, VAThe pilot's failure to maintain control of the airplane following an in-flight encounter with turbulence during approach, which led to a loss of engine power due to fuel starvation, and subsequent forced landing into trees.Oct 31, 2008 · N1932H · Substantial damageNTSB ERA09LA031Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Carroll Township, PAA total loss of engine power due to the improper assembly of the compressor discharge tubes to the combustion liner.Oct 30, 2008 · N606AS · Substantial damageNTSB CEN09FA043Accident · 1 fatalField investigationFinal reportCessna 175 · Mt. Dora, NMThe pilot's failure to maintain clearance from rising terrain for undetermined reasons.Oct 29, 2008 · N175JG · DestroyedNTSB WPR09LA026Accident · 2 fatalLimited investigationFinal reportSilfvast Starduster TOO · Cedar Fort, UTThe pilot's failure to maintain an adequate airspeed and/or angle of attack to avoid a stall/spin during an aerobatic maneuver.Oct 28, 2008 · N78DS · DestroyedNTSB WPR09LA025Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Rialto, CAA total loss of engine power during initial climb due to an interruption in fuel flow through an improperly assembled carburetor.Oct 26, 2008 · N44848 · Substantial damageNTSB CEN09CA037Accident · Serious injuriesData collectionFinal reportCessna R172E · Palo Pinto, TXThe pilot's intentional low-level flight and failure to maintain a visual lookout.Oct 26, 2008 · N42FG · DestroyedNTSB CEN09CA041Accident · No injuriesData collectionFinal reportCessna 172 · Monticello, INThe pilot stalled the airplane during a go-around. Contributing to the accident included the pilot's improper in-flight decision, the tailwind landing, and the pilot's failure to put the carburetor Heat to "OFF" during the go-around.Oct 25, 2008 · N54971 · Substantial damageNTSB ERA09FA029Accident · 2 fatalField investigationFinal reportPiper PA-24 · Red Hill, VAThe pilot's failure to maintain aircraft control due to an improper repair to the stabilator, which resulted in an in-flight failure of the stabilator. Contributing to the accident was the descent in turbulence, at airspeeds above the maximum structural…Oct 24, 2008 · N8820P · DestroyedNTSB ERA09FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Selmer, TNThe pilot's failure to avoid terrain during night instrument meteorological conditions.Oct 24, 2008 · N7510Y · Substantial damageNTSB CEN09LA035Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Broomfield, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall, during a landing attempt. Contributing to the accident was the gusty crosswinds.Oct 24, 2008 · N64055 · DestroyedNTSB ANC09LA007Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Wasilla, AKA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate fuel management.Oct 24, 2008 · N1392H · Substantial damageNTSB WPR09LA022Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Concrete, WAThe loss of engine power during initial climb due to the pilot's improper exhaust system maintenance, which resulted in restriction of the carburetor's air intake.Oct 23, 2008 · N97946 · Substantial damageNTSB ERA09LA026Accident · Serious injuriesLimited investigationFinal reportCessna 175A · Foley, ALThe pilot’s failure to maintain adequate airspeed during initial climb, resulting in a stall and collision with terrain. Contributing to the accident was the pilot’s lack of recent experience.Oct 22, 2008 · N7919T · Substantial damageNTSB CEN09LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Whitewater, COBoth pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.Oct 22, 2008 · N3389D · 2 aircraft · Substantial damageNTSB WPR09FA019Accident · 3 fatalField investigationFinal reportMooney M20J · Avalon, CAThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons. Contributing to the accident was the pilot's failure to abort the takeoff while sufficient runway remained to stop.Oct 20, 2008 · N201EN · DestroyedNTSB WPR09CA018Accident · Minor injuriesData collectionFinal reportBeech F33A · Big Bear, CAThe pilot's failure to maintain directional control of the airplane during landing.Oct 19, 2008 · N65HP · Substantial damageNTSB CEN09LA024Accident · No injuriesLimited investigationFinal reportCessna A185F · Angleton, TXThe loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the pilot to execute the forced landing.Oct 19, 2008 · N93291 · Substantial damageNTSB ERA09CA024Accident · Minor injuriesData collectionFinal reportLange Flugzeugbau E1 Antares · Winter Haven, FLThe failure of the pilot of the other airplane to announce his intentions prior to takeoff, resulting in a runway incursion. Contributing to the accident was the limited forward visibility due to the runway slope.Oct 18, 2008 · N4929R · Substantial damageNTSB WPR09FA015Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Markleeville, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to choose a suitable landing area.Oct 16, 2008 · N9581C · Substantial damageNTSB CEN09MA019Accident · 4 fatalMajor investigationFinal reportBell 222 · Aurora, ILThe pilot's failure to maintain clearance from the 734-foot-tall lighted tower during the visual night flight due to inadequate preflight planning, insufficient altitude, and a flight route too low to clear the tower. Contributing to the accident was the air…Oct 16, 2008 · N992AA · DestroyedNTSB ERA09LA021Accident · No injuriesLimited investigationFinal reportSteele John J Acro Sport · Madison, NHThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heatOct 15, 2008 · N896JC · Substantial damageNTSB ERA09CA018Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Repton, ALFuel exhaustion due to the pilot's inadequate preflight planning.Oct 14, 2008 · N7314J · Substantial damageNTSB CEN09FA012Accident · 2 fatalField investigationFinal reportBell 206 · Conroe, TXA loss of control for undetermined reasons.Oct 13, 2008 · N6ZV · DestroyedNTSB ERA09LA015Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kissimmee, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during initial climb due to fuel contamination. Contributing to the accident was a fuel tank cap that did not seal properly.Oct 12, 2008 · N734BL · Substantial damageNTSB ERA09LA013Accident · 1 fatalLimited investigationFinal reportSabre Tukan · Mohawk, TNThe pilot's loss of control in flight due to a lack of flight experience or instruction. Contributing to the accident was the pilot's impairment due to the recent use of marijuana and a prescription painkiller.Oct 12, 2008 · N75604 · Substantial damageNTSB ERA09CA014Accident · Serious injuriesData collectionFinal reportPiper J3C-50 · Epping, NHThe pilot's improper preflight inspection and his decision to fly an unairworthy airplane.Oct 12, 2008 · N23267 · Substantial damageNTSB CEN09FA015Accident · 1 fatalField investigationFinal reportCessna 150G · Cedar Lake, MIThe student pilot's failure to maintain adequate clearance after takeoff. Contributing to the accident was the pilot's overall lack of flight experience.Oct 11, 2008 · N3623J · Substantial damageNTSB CEN09FA010Accident · 2 fatalField investigationFinal reportMaule MXT-7-180A · Santa Teresa, NMThe pilot's decision to takeoff and fly into a thunderstorm.Oct 11, 2008 · N4257C · DestroyedNTSB CEN09CA020Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lufkin, TXThe student pilot's improper decision to takeoff with a known brake problem. Contributing to the accident were the malfunctioning brake and the rough terrain in the excursion area.Oct 11, 2008 · N764C · Substantial damageNTSB ERA09CA012Accident · Minor injuriesData collectionFinal reportCessna 177 · Bluffton, SCThe pilot's inadequate planning and preflight inspection.Oct 10, 2008 · N3495T · Substantial damageNTSB WPR09CA007Accident · No injuriesData collectionFinal reportCessna T206H · Henderson, NVThe pilot's inadequate compensation for the crosswind conditions.Oct 9, 2008 · N206TT · Substantial damageNTSB WPR09CA006Accident · No injuriesData collectionFinal reportCessna 210-5(205) · Payson, UTThe total loss of engine power during cruise flight for undetermined reasons. Contributing to the accident were a dark night and a cherry orchard at the location where the pilot executed the forced landing.Oct 9, 2008 · N8374Z · Substantial damageNTSB 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 damageNTSB WPR09FA005Accident · 1 fatalField investigationFinal reportIniziative Industriali Italian SKY Arrow 600 · Malibu, CAThe pilot's failure to maintain aircraft control during a low-altitude maneuver. Contributing to the accident was the pilot's decision to perform a maneuver at a low altitude that was insufficient to allow him to recover from the loss of control. Contributing…Oct 8, 2008 · N454SA · Substantial damageNTSB CEN09CA021Accident · Serious injuriesData collectionFinal reportCessna 150M · Iowa City, IAFuel exhaustion due to the pilot's failure to visually verify that sufficient fuel was on-board prior to flight.Oct 7, 2008 · N533JR · Substantial damageNTSB CEN09WA016Accident · 2 fatalForeign investigationCessna 421 · Oaxaca, MexicoOn October 6, 008 at approximately 1332 central daylight time (CDT) a Cessna 421C, Mexican Registration XB-KWB was destroyed while attempting to return to Xoxocotlan International Airport (OAX,) Oaxaca, Mexico to land . Both aircraft occupants sustained fatal…Oct 6, 2008 · XB-KWG · DestroyedNTSB CEN09CA025Accident · Serious injuriesData collectionFinal reportHolmes William E Predator · Branson, MOThe pilot's failure to maintain directional control. Contributing to the accident was the wing's failure to open all cells for undetermined reasons and the trees near the runway.Oct 6, 2008 · N868S · Substantial damageNTSB CEN09CA005Accident · No injuriesData collectionFinal reportCessna 180A · St. Louis, MOThe flight instructor's failure to maintain directional control during the landing.Oct 6, 2008 · N6180 · Substantial damageNTSB WPR09LA004Accident · 1 fatalLimited investigationFinal reportBonde TF-51D · Sandy Valley, NVThe pilot's failure to maintain adequate airspeed while maneuvering to land, resulting in an aerodynamic stall. Contributing to the accident was the pilot's diverted attention while attempting to extend the landing gear.Oct 5, 2008 · N267B · Substantial damageNTSB ERA09FA005Accident · Minor injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Swainsboro, GAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Oct 5, 2008 · N742EA · Substantial damageNTSB WPR09CA003Accident · No injuriesData collectionFinal reportBeech 76 · Eloy, AZThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident were the crosswind wind conditions and terrain induced turbulence.Oct 4, 2008 · N6013X · Substantial damageNTSB WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.Oct 3, 2008 · N2146M · Substantial damageNTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.Oct 3, 2008 · N5172J · Substantial damageNTSB ANC09FA003Accident · 1 fatalField investigationFinal reportAntonovich Anton B Challenger II · Chugiak, AKThe pilot’s failure to maintain control of the airplane while maneuvering, resulting in an in-flight collision with trees. Contributing to the accident was the pilot's lack of experience.Oct 3, 2008 · N7511J · Substantial damageNTSB LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before takeoff.Oct 1, 2008 · N2190W · Substantial damage