# NTSB investigations: Piccard AX-6: Hard landing

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 FTW90LA122](https://openairdocs.org/ntsb/FTW90LA122.md): Piccard P-80 · Peaster, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 1990 · N99US · Destroyed
  > An excessive rate of descent during the approach.
- [NTSB FTW83LA155](https://openairdocs.org/ntsb/FTW83LA155.md): Piccard AX-6 · Springtown, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 1983 · N99US · No damage
  > The balloon was on a 'hare & hound' competition flight with a commercial plt & student plt on board. After the competition portion was completed, the pilot-in-command told the student to take control & continue flying, then land at her discretion. After about…
- [NTSB LAX83LA093](https://openairdocs.org/ntsb/LAX83LA093.md): Piccard AX-6 · Arroyo Grande, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 1, 1983 · N84US · No damage
  > The plt reported that he experienced a downdraft when he was on an apch to land near power lines, and was forced to 'rip out early.' The balloon landed landed relatively hard, but was not damaged. However, the plt's legs were crossed when the balloon touched…

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7001218')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7001218&occurrence=200

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