NTSB investigations, 2008, TX

14 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2008, TX per year, 2008–2026: 303 cases
200814
200917
201019
201121
201215
201315
201421
201516
201619
201711
201825
201920
202021
202111
202213
202311
202415
202514
20265

Latest cases

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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' 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 CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.Dec 12, 2008 · N5495B · Minor damageNTSB CEN09LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nacogdoches, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Nov 8, 2008 · N8485R · 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 CEN09LA014Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe total loss of engine power due to a fracture in the oil filter adapter housing. Contributing to the accident was the lack of suitable terrain for the forced landing.Oct 8, 2008 · N703KP · DestroyedNTSB DEN08LA158Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US N-77 · Plano, TXThe pilot's improper fuel management, resulting in fuel exhaustion and the subsequent hard landing.Sep 21, 2008 · N4003P · Minor damageNTSB DFW08LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Orange Grove, TXA total loss of engine power due to an improperly installed intake manifold tube.Sep 5, 2008 · N8979X · Substantial damageNTSB DFW08CA211Accident · No injuriesData collectionFinal reportMurray Frank H DA5B · Odessa, TXFailure of the intake manifold when the flexible connectors disconnected from the carburetor after a turbulence encounter. Contributing to the accident was insuitable terrain for a forced landing.Aug 21, 2008 · N1002W · Substantial damageNTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.Aug 20, 2008 · N92780 · Substantial damageNTSB DFW08CA198Accident · No injuriesData collectionFinal reportRobinson R22 · Rosharon, TXThe pilot's failure to maintain terrain clearance while maneuvering. Contributing to the accident was the low altitude.Jul 25, 2008 · N2330Y · Substantial damageNTSB DFW08CA192Accident · No injuriesData collectionFinal reportGrumman G-164A · Bovina, TXLoss of engine power for undetermined reasons.Jul 18, 2008 · N7832 · Substantial damageNTSB DFW08CA184Accident · No injuriesData collectionFinal reportWright Avid Flyer MK IV · Lake Jackson, TXThe loss of engine power due to a connecting rod failure.Jul 12, 2008 · N583AF · Substantial damageNTSB DFW08CA183Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Denton, TXThe pilot's inadequate fuel management, which resulted in fuel starvation and the subsequent loss of engine power.Jul 11, 2008 · N9678U · Substantial damageNTSB DEN08LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Garwood, TXA loss of engine power due to the total failure of the number 2 cylinder.Jun 19, 2008 · N3166H · DestroyedNTSB DFW08LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Spring, TXFailure of the pilot to ensure that the fuel system was purged of water prior to flight. Contributing to the severity of injuries was the lack of shoulder restraints.Feb 10, 2008 · N9047W · Substantial damage