NTSB investigations, 2008, IN

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

Cases per year

20082026
NTSB investigations, 2008, IN per year, 2008–2026: 156 cases
200812
200913
201012
201111
201211
201310
20148
201512
201613
201712
201813
20198
20204
20214
20222
20234
20246
20261

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\" = 'IN' 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\" = '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 CEN09CA080Accident · No injuriesData collectionFinal reportBeech E35 · Bloomington, INA partial loss of engine power due to a failure of the number one cylinder exhaust valve, and the associated secondary damage to the intake valve and piston.Nov 20, 2008 · N3213C · Substantial damageNTSB 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 CHI08FA269Accident · 3 fatalField investigationFinal reportBell 206L-1 · Greensburg, INThe in-flight separation of a main rotor blade due to a fatigue failure of the blade spar, rendering the helicopter uncontrollable, and the manufacturer's production of main rotor blades with latent manufacturing defects, which precipitated the fatigue…Aug 31, 2008 · N37AE · DestroyedNTSB CHI08CA256Accident · Minor injuriesData collectionFinal reportCessna 172N · Huntington, INThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot's inadvertent use of the toe brake.Aug 16, 2008 · N733KC · Substantial damageNTSB CHI08CA217Accident · No injuriesData collectionFinal reportGrumman G-164A · Veedersburg, INThe oil filler cap not reinstalled by the pilot prior to the aerial application flight and the total loss of engine oil during an aerial application. Additional causes were the low altitude of the operation and the unsuitable terrain encountered by the pilot…Jul 28, 2008 · N9892 · Substantial damageNTSB CHI08CA223Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Ambia, INThe altitude/clearance not obtained/maintained by the pilot while maneuvering over an agricultural field during an aerial application. Contributing factors were the sunglare in the direction of flight, the low altitude of the operation, and the upslope of the…Jul 26, 2008 · N3169R · Substantial damageNTSB CHI08CA210Accident · No injuriesData collectionFinal reportBell 47G-3B-2 · Lafetyette, INThe loss of engine power during an aerial application flight due to a fatigue fracture of the carburetor heat control valve spring and the inadequate maintenance inspection by the pilot/mechanic. An additional cause was the low altitude of the operation.Jul 24, 2008 · N4029G · Substantial damageNTSB CHI08CA168Accident · No injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INThe pilot/builder's failure to manufacture the airplane with an appropriate engine thrust angle. Contributing to the accident was the pilot/builder's adjustment of the horizontal stabilizer which rendered the airplane uncontrollable.Jun 23, 2008 · N93725 · Substantial damageNTSB CHI08CA149Accident · Serious injuriesData collectionFinal reportMischanko Buckeye Breeze · Walkerton, INThe directional control of the parachute not obtained/maintained by the pilot during the takeoff roll. A contributing factor was separation of the nose landing gear.May 27, 2008 · N623EM · Minor damageNTSB CHI08CA148Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Delphi, INThe pilot's inadequate compensation for the gusting crosswind during landing rollout. Contributing to the accident was the gusting crosswind condition.May 17, 2008 · N1601P · Substantial damageNTSB CHI08CA117Accident · No injuriesData collectionFinal reportCessna 182D · Madison, INThe inadequate preflight inspection of the landing gear tires by the pilot, which did not identify a worn tire and resulted in a flat tire during landing touchdown. An additional cause was the directional control not possible during the landing rollout, and…Apr 27, 2008 · N9111X · Substantial damageNTSB CHI08CA072Accident · No injuriesData collectionFinal reportAvid MK-IV · Boswell, INThe pilot's inadequate compensation for the crosswind condition which resulted in a loss of directional control during a bounced landing. Factors associated with the accident were the improper flare, the crosswind, and the trees which the airplane contacted.Jan 27, 2008 · N610K · Substantial damage