NTSB investigations

448 cases where NTSB found Dark.

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\", '03036020'))
  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 ERA13FA115Accident · 1 fatalField investigationFinal reportPilatus PC-12/45 · Burlington, NCThe pilot's failure to maintain airplane control due to spatial disorientation during the initial climb after takeoff in night instrument flight rules conditions.Jan 16, 2013 · N68PK · Substantial damageNTSB CEN13FA135Accident · 1 fatalField investigationFinal reportCessna 208B · Pellston, MIThe pilot's inadvertent controlled descent into terrain due to spatial disorientation. Contributing to the accident was lack of visual reference due to night conditions.Jan 16, 2013 · N1120N · DestroyedNTSB WPR13FA080Accident · 1 fatalField investigationFinal reportBell 206 · Delano, CAThe pilot's failure to maintain helicopter control due to spatial disorientation while maneuvering in low visibility, dark night conditions.Jan 2, 2013 · N828AC · DestroyedNTSB WPR13FA073Accident · 2 fatalField investigationFinal reportBeech B100 · Libby, MTThe noncertificated pilot’s failure to maintain clearance from terrain while maneuvering to land in dark night conditions likely due to his geographic disorientation (lost). Contributing to the accident was the pilot’s improper decision to fly at night with a…Dec 19, 2012 · N499SW · DestroyedNTSB WPR13FA072Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Payson, AZThe airplane’s inadvertent encounter, in night instrument meteorological conditions, with unforecast strong up- and downdrafts and possibly severe airframe icing conditions (which likely included supercooled large droplets that the airplane was not…Dec 19, 2012 · N62959 · Substantial damageNTSB ERA13FA083Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Lake Park, GAThe noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.Dec 11, 2012 · N840DS · Substantial damageNTSB CEN13LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rochester, MNThe pilot’s spatial disorientation during the instrument approach in night, instrument meteorological conditions, which resulted in the airplane descending below decision height and impacting terrain outside the lateral limits of the localizer. Contributing…Dec 3, 2012 · N9853Q · Substantial damageNTSB WPR13LA062Accident · 1 fatalLimited investigationFinal reportCessna 172S · Kahului, HIThe noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.Dec 2, 2012 · N3554Y · Substantial damageNTSB CEN13FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-350P · Greensburg, INThe pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.Dec 2, 2012 · N92315 · DestroyedNTSB ERA13FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Canton, CTThe pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.Nov 19, 2012 · N8826J · Substantial damageNTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.Nov 18, 2012 · N78304 · Substantial damageNTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…Nov 11, 2012 · N700EM · Substantial damageNTSB ERA13FA026Accident · 1 fatalField investigationFinal reportAerospatiale AS 355 · Erwinna, PAThe pilot’s decision to depart under visual flight rules in dark night instrument meteorological conditions, which resulted in subsequent spatial disorientation, uncontrolled descent, and impact with trees and terrain.Oct 17, 2012 · C-FXGM · Substantial damageNTSB WPR13FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Marana, AZThe pilot’s flight in dark night conditions with no visual reference and his subsequent spatial disorientation.Oct 15, 2012 · N151SV · Substantial damageNTSB CEN13FA012Accident · 1 fatalField investigationFinal reportCessna 172R · Simpson, LAThe pilot’s loss of airplane control while maneuvering between areas of precipitation during a night cross-country flight.Oct 15, 2012 · N2126R · Substantial damageNTSB ERA13LA019Accident · 3 fatalLimited investigationFinal reportPiper PA-23-250 · Charlotte AmalieThe pilot's attempted visual flight rules (VFR) flight into marginal VFR conditions on a dark night over water and his failure to maintain sufficient altitude, which resulted in the airplane’s controlled flight into water. Contributing to the accident was the…Oct 13, 2012 · N5553Y · Substantial damageNTSB ERA13FA014Accident · 2 fatalField investigationFinal reportBell 407 · Coolbaugh Township, PAThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions due to self-imposed pressure to complete the trip, which resulted in impact with trees and terrain.Oct 10, 2012 · N108MF · Substantial damageNTSB WPR13FA001Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Beatty, NVThe pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.Oct 3, 2012 · N7895W · Substantial damageNTSB CEN12LA645Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Branson, MOThe pilot's failure to maintain airplane control during an attempted go-around in dark night conditions.Sep 20, 2012 · N34722 · Substantial damageNTSB CEN12FA633Accident · 5 fatalField investigationFinal reportCirrus Design SR22 · Willard, MOThe pilot's loss of airplane control as a result of spatial disorientation experienced in night instrument meteorological conditions.Sep 15, 2012 · N436KS · Substantial damageNTSB WPR12FA369Accident · 5 fatalField investigationFinal reportPiper PA-32-301T · South Lake Tahoe, CAA partial loss of engine power for reasons that could not be determined because examinations revealed no evidence of mechanical anomalies with the airframe or engine that would have precluded normal operation and the pilots’ decision to continue the departure…Aug 26, 2012 · N588ET · Substantial damageNTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…Aug 25, 2012 · N407N · Substantial damageNTSB CEN12IA518Incident · No injuriesIncident investigationFinal reportBell 407 · San Antonio, TXThe pilot’s failure to maintain clearance from a tower guy wire during the approach to a helipad at night.Aug 5, 2012 · N429PH · Minor damageNTSB WPR12FA230Accident · 4 fatalField investigationFinal reportCessna 172S · St. George, UTThe pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…May 26, 2012 · N953SP · Substantial damageNTSB WPR12FA139Accident · 1 fatalField investigationFinal reportBeech B36 · Panoche, CAThe pilot’s lack of situational awareness regarding the surrounding terrain while descending during dark night conditions, which resulted in controlled flight into terrain.Mar 15, 2012 · N364AB · Substantial damageNTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.Feb 24, 2012 · N53589 · Substantial damageNTSB ANC12CA023Accident · No injuriesData collectionFinal reportCessna 182A · Anchorage, AKThe pilot's inadvertent landing on a frozen lake in dark night conditions.Feb 20, 2012 · N6147B · Substantial damageNTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.Feb 15, 2012 · N665SP · Substantial damageNTSB ERA12CA185Accident · No injuriesData collectionFinal reportCessna 172S · Eufaula, ALAn inadvertent collision with a deer during a night landing.Feb 14, 2012 · N6194V · Substantial damageNTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…Jan 23, 2012 · N73JK · Substantial damageNTSB CEN12LA125Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · McKinney, TXThe passenger's inadvertent contact with a rotating propeller after exiting the parked airplane. Contributing to the accident were the dark night conditions and the deplaning of the passenger while the propeller was turning.Dec 4, 2011 · N62WY · No damageNTSB CEN12FA097Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot’s decision to initiate visual flight in instrument meteorological conditions and subsequent failure to maintain adequate altitude.Dec 4, 2011 · N33315 · Substantial damageNTSB ERA12CA094Accident · No injuriesData collectionFinal reportNuse George F1H Rocket · Caroleen, NCThe pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.Dec 2, 2011 · N295JS · Substantial damageNTSB WPR12LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Hailey, IDThe pilot's failure to maintain course heading and terrain clearance because he was distracted by efforts to engage the autopilot shortly after takeoff on a dark night in mountainous terrain.Nov 30, 2011 · N36824 · Substantial damageNTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…Nov 24, 2011 · N690SM · DestroyedNTSB ERA12CA080Accident · Serious injuriesData collectionFinal reportBeech V35 · Lusby, MDThe pilot did not maintain clearance from trees during a night approach.Nov 20, 2011 · N9569Q · Substantial damageNTSB CEN12LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Eau Claire, WIThe pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.Nov 12, 2011 · N3606C · Substantial damageNTSB CEN12CA065Accident · No injuriesData collectionFinal reportCessna 182J · Alexandria, MNThe pilot's failure to maintain directional control during the night landing.Nov 12, 2011 · N3051F · Substantial damageNTSB WPR12FA031Accident · 3 fatalField investigationFinal reportCessna 182Q · Lake Havasu City, AZThe pilot's continued cruise flight into cloudy conditions at night, which resulted in a loss of airplane control due to spatial disorientation.Nov 7, 2011 · N4701N · Substantial damageNTSB ANC12LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kwigillingok, AKThe pilot's failure to abort the takeoff when he realized the airplane could not attain sufficient takeoff and climb performance and his improper decision to depart from an airport where night operations were prohibited.Nov 7, 2011 · N6314H · Substantial damageNTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.Oct 27, 2011 · N6545E · Substantial damageNTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.Oct 12, 2011 · N64MG · Substantial damageNTSB WPR11FA448Accident · 2 fatalField investigationFinal reportCessna 182H · Stanley, IDThe pilot's failure to maintain airplane control due to spatial disorientation while executing a turn to reverse his course in dark night and low-visibility conditions. Contributing to the accident was the pilot's decision to initiate the flight into an area…Sep 13, 2011 · N2404X · Substantial damageNTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.Aug 8, 2011 · N2286P · Substantial damageNTSB WPR11FA354Accident · 2 fatalField investigationFinal reportCirrus SR20 · Fredonia, AZThe non-instrument-rated pilots’ loss of situational awareness during a dark night flight over a remote area, which resulted in their failure to maintain an altitude sufficient to ensure adequate terrain clearnance. Contributing to the accident was the…Jul 30, 2011 · N365DP · Substantial damageNTSB ERA11FA412Accident · 2 fatalField investigationFinal reportCessna 182S · Erwin, NCThe pilot’s loss of control due to spatial disorientation while maneuvering in dark night conditions.Jul 21, 2011 · N23739 · Substantial damageNTSB OPS11IA686Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-83(MD-83) · Apache Junction, AZThe failure of the pilots of both airplanes to see and avoid each other and to maneuver as advised by the air traffic controller in time to prevent the conflict that resulted in the reported near midair collision.Jun 27, 2011 · N416NV · No damageNTSB ERA11FA287Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Spring Hill, FLThe pilot's inadvertent application of control inputs that resulted in rapid, right-rolling, negative g-forces during night cruise flight and his subsequent ejection from the airplane. Contributing to the accident was the pilot's decision to fly at night in…May 7, 2011 · N420PS · Substantial damageNTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.Apr 23, 2011 · N3963Y · Substantial damageNTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.Apr 10, 2011 · N100TK · Substantial damage