NTSB investigations

114 cases where NTSB found Task environment.

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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0304'))
  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 WPR09CA114Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAA loss of engine power due to the number four cylinder base nuts becoming loose, allowing the cylinder to detach from the engine case. Contributing to the accident was the pilot's impaired visibility due to smoke during the forced landing.Feb 12, 2009 · N3626T · Substantial damageNTSB ERA09CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lexington, KYThe pilot's failure to maintain control of the helicopter during takeoff. Contributing to this accident was the interference of the flight controls by the heavy coat and boots the pilot was wearing.Feb 1, 2009 · N2620C · Substantial damageNTSB CEN09CA136Accident · No injuriesData collectionFinal reportBeech 19 · Lafayette, INThe pilot's inadvertent encounter with icing conditions during initial climb. Contributing to the accident were the lack of visibility during the landing due to an ice covered windscreen, and the structural ice that adversely affected the flight…Jan 18, 2009 · N6509T · Substantial damageNTSB DCA09MA026Accident · Serious injuriesClass 1 · MajorFinal reportAirbus A320 · Weehawken, NJThe ingestion of large birds into each engine, which resulted in an almost total loss of thrust in both engines and the subsequent ditching on the Hudson River. Contributing to the fuselage damage and resulting unavailability of the aft slide/rafts were (1)…Jan 15, 2009 · N106US · Substantial damageNTSB WPR09CA051Accident · No injuriesData collectionFinal reportBeech B60 · Rock River, WYThe pilot's failure to maintain clearance from a power line due to the lack of forward visibility because of an ice-covered windshield. Contributing to the accident was the flight's encounter with icing weather conditions.Nov 29, 2008 · N6693A · Substantial damageNTSB WPR09LA024Accident · No injuriesLimited investigationFinal reportHolm Michael J Kitfox IV 1200 · Glendale, AZThe Kitfox's pilot's failure to ascertain if the intersection he approached was clear of conflicting traffic and the controller's failure to provide pertinent traffic advisories to both pilots. Contributing to the accident was the reduced visibility from the…Oct 24, 2008 · N427ET · 2 aircraft · Minor damageNTSB MIA08LA180Accident · No injuriesLimited investigationFinal reportCessna 182A · Elizabethtown, KYA loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.Aug 30, 2008 · N5927B · Substantial damageNTSB LAX08CA248Accident · No injuriesData collectionFinal reportBristol Titan Tornado II · Green River, UTThe encounter with rough terrain during an off-field precautionary landing.Jul 30, 2008 · N25JT · Substantial damageNTSB DEN08LA109Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Von Ormy, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing to the accident were a proper touchdown point was not possible and the inadequate display of the fuel quantity indicator.Jun 21, 2008 · N460CT · Substantial damageNTSB CHI08LA169Accident · No injuriesLimited investigationFinal reportMorrison E-Racer · Aurora, ILAn undetermined failure in the high-pressure fuel system, and the subsequent loss of engine power and in-flight fire. Contributing to the accident were the pilot's restricted visibility due to the smoke in the cockpit, failure of the aileron control during…Jun 21, 2008 · N345JM · DestroyedNTSB MIA08CA126Accident · Minor injuriesData collectionFinal reportTaylorcraft F19 · Montgomery, ALThe pilot's improper loading of personal belongings which resulted in rudder pedal interference.Jun 20, 2008 · N3681T · Substantial damageNTSB DFW08LA118Accident · No injuriesLimited investigationFinal reportVickers Spitfire · Galveston, TXThe Hurricane pilot's failure to maintain directional control during roll-out. Contributing factors were the restricted forward visibility of the tail-wheel equipped Spitfire, the lack of communication to the other aircraft following the Hurricane, and the…Apr 26, 2008 · N308WK · 2 aircraft · 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 SEA08FA062Accident · 1 fatalField investigationFinal reportHawker Beechcraft 1900C · Lihue, HIThe pilot's spatial disorientation and loss of situational awareness. Contributing to the accident were the dark night and the task requirements of simultaneously monitoring the cockpit instruments and the other airplane.Jan 14, 2008 · N410UB · Destroyed