# NTSB investigations: Knowledge, general

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 DCA23LA060](https://openairdocs.org/ntsb/DCA23LA060.md): Airbus A319 · New Orleans, LA · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 3, 2022 · N519NK · No damage
  > The captain’s pitch up input to avoid an overspeed condition, which resulted in a flight attendant falling and fracturing her ankle. Contributing was the airplane’s excessive airspeed during the transition to the automation-managed descent profile.
- [NTSB DCA22LA069](https://openairdocs.org/ntsb/DCA22LA069.md): Airbus A320-232 · Hayden, CO · Accident · No injuries · Class 4 · Limited · Final report · Jan 22, 2022 · N760JB · Substantial damage
  > The captain’s rotation of the airplane pitch before the rotation speed on takeoff due to his surprise about encountering head on landing traffic, which resulted in an exceedance of the airplane’s pitch limit and a subsequent tail strike. Contributing to the…
- [NTSB CEN21FA130](https://openairdocs.org/ntsb/CEN21FA130.md): Velocity Vtwin · Janesville, WI · Accident · 2 fatal · Class 3 · Field · Final report · Feb 16, 2021 · N13VT · Substantial damage
  > The exceedance of the maximum airspeed for flight with the landing gear extended, which resulted in a separation of the right main landing gear door that subsequently impacted the right propeller and resulted in a total loss of right engine power.…
- [NTSB CEN17LA156](https://openairdocs.org/ntsb/CEN17LA156.md): Loomis Xenon 4 · Knoxville, IA · Accident · No injuries · Limited investigation · Final report · Apr 17, 2017 · N912XV · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.
- [NTSB LAX08PA259](https://openairdocs.org/ntsb/LAX08PA259.md): Sikorsky S-61N · Weaverville, CA · Accident · 9 fatal · Class 1 · Final report · Aug 6, 2008 · N612AZ · Destroyed
  > The following actions by Carson Helicopters: 1) the intentional understatement of the helicopter's empty weight, 2) the alteration of the power available chart to exaggerate the helicopter's lift capability, and 3) the practice of using unapproved…

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

This list as a web page: https://openairdocs.org/ntsb-findings/02032000/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.