NTSB investigations

671 cases where NTSB found Light condition.

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\", '030360'))
  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 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 damageNTSB ANC08LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Koliganek, AKThe pilot's VFR flight into adverse weather conditions that resulted in a collision with snow-covered terrain during a turn to reverse direction. Factors contributing to the accident were low ceilings, flat lighting conditions, and the snow-covered terrain.Apr 1, 2008 · N8327S · Substantial damageNTSB SEA08LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridger, MTThe pilot failed to maintain situational awareness during the flight. Contributing to the accident were the dark night, the pilot's failure to follow approved navigational procedures for the flight, and the pilot's over reliance on the avionics in the…Mar 26, 2008 · N432RM · Substantial damageNTSB LAX08CA085Accident · No injuriesData collectionFinal reportAyres S2R-600 · Blythe, CAThe pilot's failure to maintain terrain clearance. Contributing factors were the dusk light condition and the pressure the pilot felt to accomplish the flight.Mar 25, 2008 · N5674X · Substantial damageNTSB MIA08FA080Accident · 2 fatalField investigationFinal reportCessna 182B · Wildwood, FLThe noninstrument rated pilot's failure to maintain terrain clearance at night in marginal visual flight conditions. Contributing to the accident was the dark night, and low cloud ceilings.Mar 16, 2008 · C-FFBC · No damageNTSB NYC08FA138Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Front Royal, VAThe pilot's failure to maintain clearance from rising mountainous terrain, and his failure to turn toward his assigned course during initial climb. Contributing to the accident were the low ceiling, reduced visibility, dark night conditions, and rising…Mar 15, 2008 · N141SR · DestroyedNTSB NYC08FA109Accident · 2 fatalField investigationFinal reportBeech A36 · Cumberland, MDThe pilot's failure to maintain the proper approach course for undetermined reasons.Feb 22, 2008 · N3815T · Substantial damageNTSB SEA08CA081Accident · Minor injuriesData collectionFinal reportSteven Hardie AIR CAM · Duncan Mills, CAThe pilot's failure to maintain clearance with power lines while maneuvering at a low altitude. Contributing factors included the pilot's decision to fly at low altitude and the sun glare condition.Feb 16, 2008 · N30581 · Substantial damageNTSB NYC08CA101Accident · No injuriesData collectionFinal reportCessna 182K · Greenville, METhe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the snow covered runway and sun glare light conditions.Feb 15, 2008 · N3047Q · Substantial damageNTSB SEA08LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Piru, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and dark night conditions.Feb 9, 2008 · N2922X · Substantial damageNTSB CHI08CA078Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Cahokia, ILThe flight instructor's failure to correct for proper runway alignment during final approach and his failure to maintain aircraft control during his subsequent go-around. Contributing to the accident was the dual-student's failure to properly align with the…Feb 8, 2008 · N554PC · Substantial damageNTSB DFW08FA062Accident · 3 fatalField investigationFinal reportEurocopter France AS350B2 · S. Padre Island, TXThe pilot's failure to maintain aircraft control resulting in the helicopter impacting the water. Factors contributing to the accident were the pilot's inadvertent flight into instrument meteorological conditions, the low ceiling, dark night conditions, and…Feb 6, 2008 · N911VA · Substantial damageNTSB NYC08CA092Accident · Minor injuriesData collectionFinal reportKral Series 5 Kitfox · Fruitland Park, FLThe pilot's failure to maintain adequate clearance from obstructions during the landing approach. Contributing to the accident was the reduced visibility due to sunglare and haze.Feb 3, 2008 · N97GK · DestroyedNTSB LAX08CA054Accident · No injuriesData collectionFinal reportBell OH-58A · Brawley, CAThe pilot's failure to maintain clearance from obstacles. A factor in the accident was the dark night conditions.Jan 30, 2008 · N902SF · Substantial damageNTSB LAX08FA052Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Los Angeles, CAThe pilot's failure to maintain an adequate obstacle clearance altitude from transmission wires during cruise flight. Contributing to the accident was the dark night conditions.Jan 26, 2008 · N705JJ · DestroyedNTSB 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 damageNTSB CHI08FA066Accident · 1 fatalField investigationFinal reportHawker Beechcraft 58 · Cleveland, OHThe pilot experienced spatial disorientation during the inital climb causing him to lose control of the airplane.Jan 17, 2008 · N3217L · Substantial damageNTSB ANC08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's selection of unsuitable terrain for landing. Contributing to the accident were snow-covered terrain, blowing snow and flat lighting conditions.Jan 15, 2008 · N454SF · Substantial damageNTSB SEA08LA061Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · San Francisco, CAThe company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…Jan 14, 2008 · N705SK · 2 aircraft · Substantial 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 · DestroyedNTSB DFW08LA055Accident · 1 fatalLimited investigationFinal reportPilatus PC-12/45 · Oklahoma City, OKThe line technician's failure to remain clear of the propeller. A factor was the night lighting conditions.Jan 3, 2008 · N398J · No damage