# NTSB investigations: Circadian rhythms or jetlag

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR23FA257](https://openairdocs.org/ntsb/WPR23FA257.md): Cessna 550 · Murrieta, CA · Accident · 6 fatal · Class 3 · Field · Final report · Jul 8, 2023 · N819KR · Destroyed
  > The flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…
- [NTSB WPR21FA231](https://openairdocs.org/ntsb/WPR21FA231.md): Piper PA-28-140 · Rush Valley, UT · Accident · 2 fatal · Class 3 · Field · Final report · Jun 18, 2021 · N6323R · Substantial damage
  > The pilot’s misidentification of a mountain pass at night, which resulted in controlled flight into terrain. Contributing to the accident were the pilot’s overconfidence based on her previous aviation experience and fatigue due to both the time of the flight…
- [NTSB CEN19MA312](https://openairdocs.org/ntsb/CEN19MA312.md): Convair 440 · Monclova, OH · Accident · 2 fatal · Class 3 · Major · Final report · Sep 11, 2019 · N24DR · Destroyed
  > The flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.
- [NTSB DCA17IA148](https://openairdocs.org/ntsb/DCA17IA148.md): Airbus A320-211 · San Francisco, CA · Incident · No injuries · Class 1 · Incident · Final report · Jul 8, 2017 · C-FKCK · No damage
  > The flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…
- [NTSB CEN15FA190](https://openairdocs.org/ntsb/CEN15FA190.md): Cessna 414A · Bloomington, IL · Accident · 7 fatal · Field investigation · Final report · Apr 7, 2015 · N789UP · Substantial damage
  > The pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…
- [NTSB DCA13MA120](https://openairdocs.org/ntsb/DCA13MA120.md): Boeing 777-200ER · San Francisco, CA · Accident · 3 fatal · Class 1 · Major · Final report · Jul 6, 2013 · HL7742 · Destroyed
  > The flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…
- [NTSB ERA12FA572](https://openairdocs.org/ntsb/ERA12FA572.md): Cessna 172S · Land O'Lakes, FL · Accident · 1 fatal · Field investigation · Final report · Sep 22, 2012 · N21750 · Substantial damage
  > The pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.
- [NTSB WPR09FA146](https://openairdocs.org/ntsb/WPR09FA146.md): Diamond Aircraft Ind DA-40 · Arcata, CA · Accident · 2 fatal · Field investigation · Final report · Mar 2, 2009 · N521DS · Destroyed
  > The pilot's failure to maintain proper altitude and glidepath while executing a night instrument approach. Contributing to the accident was the pilot's fatigue.
- [NTSB CEN09MA142](https://openairdocs.org/ntsb/CEN09MA142.md): Aerospatiale Alenia ATR 42-320 · Lubbock, TX · Accident · Serious injuries · Class 1 · Major · Final report · Jan 27, 2009 · N902FX · Substantial damage
  > The flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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", '02013515'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02013515/cases

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
