# NTSB investigations, LA: Undershoot

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 FTW02LA246](https://openairdocs.org/ntsb/FTW02LA246.md): Cessna 182-Q · New Roads, LA · Accident · No injuries · Limited investigation · Final report · Aug 31, 2002 · N96725 · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in a stall.
- [NTSB FTW93LA089](https://openairdocs.org/ntsb/FTW93LA089.md): Grumman G-164B · Indian Village, LA · Accident · No injuries · Limited investigation · Final report · Feb 22, 1993 · N48455 · Substantial damage
  > Landing performed short of the runway threshold. Factor was wet grassy terrain
- [NTSB FTW87FA213](https://openairdocs.org/ntsb/FTW87FA213.md): Partenavia P68C · New Orleans, LA · Accident · Serious injuries · Field investigation · Final report · Sep 11, 1987 · N1352W · Destroyed
  > The plt began an ILS rwy 18R apch at ngt to the lakefront arpt. He rprtd that after the acft broke out of the clouds at 1700', he transitioned to a visual apch. He stated that as he contd, the apch seemed normal, except the VASI lights seemed too FAR down the…
- [NTSB FTW85LA164](https://openairdocs.org/ntsb/FTW85LA164.md): Cessna 172M · Angola, LA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N73616 · Substantial damage
  > The acft touched down short of the rwy following an approach to land after the plt had accomplished a x-country flt with a pass'g on board. The plt stated that he became momentarily disoriented due to haze & bright sunlight during the approach. During this…
- [NTSB FTW85LA021](https://openairdocs.org/ntsb/FTW85LA021.md): Cessna 152 · Bogalusa, LA · Accident · No injuries · Limited investigation · Final report · Oct 21, 1984 · N5097H · Substantial damage
  > The solo student plt landed 8 to 10 ft short of the rwy and rolled into the asphalt lip of the prepared surface. Touchdown occurred in an area of construction lengthening the rwy.
- [NTSB FTW84LA350](https://openairdocs.org/ntsb/FTW84LA350.md): Piper PA-32-260 · Minden, LA · Accident · No injuries · Limited investigation · Final report · Aug 17, 1984 · N3962W · Substantial damage
  > During a night instructional flt on landing approach, the instructor pilot reported that the student over corrected for a high approach by closing the throttle. The acft hit the ground before he could establish control of the resulting high rate of sink.
- [NTSB FTW83LA153](https://openairdocs.org/ntsb/FTW83LA153.md): Beech 23 · Athens, LA · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 1983 · N2389Q · Substantial damage
  > Just prior to the flt, a mechanic performed some minor upkeep functions on the acft & knew of no mechanical problems. He was unaware that the owner was not a rated plt. The mechanic accompanied the owner on a local flt. Subsequently, the acft crashed on the…

## 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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 390)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=390&state=LA

---
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.