Skip to content

NTSB investigations · 25

Matched to the registry by N-number and event date, newest first.

Query with 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('7001218') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('7001218')
  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.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('7001218')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW90LA122Accident · Serious injuriesLimited investigationFinal reportPiccard P-80 · Peaster, TXAn excessive rate of descent during the approach.Jun 23, 1990 · N99US · Destroyed NTSB FTW89FA136Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Houston, TXThe pilot's failure to abort the attempt to clear the obstacle. Factors in the accident were: the poor condition of the balloon envelope and the pilot's lack of experience as pilot in command of balloon operations.Jul 16, 1989 · N85DP · Destroyed NTSB DEN89LA003Accident · Minor injuriesLimited investigationFinal reportPiccard AX-6 · Albuquerque, NMThe commercial plt was competing in a balloon fiesta, with 2 pax. The plt selected a landing field with power lines and a street running east and west across it. The balloon was drifting south and the plt selected the south end of the field for landing,…Oct 3, 1988 · N99US · Substantial damage NTSB DEN85LA005Accident · Serious injuriesLimited investigationFinal reportPiccard AX6W · Albuquerque, NMPlt stated he observed the wire about 3 secs before collision. Electrical short circuit severed load cables to basket, which fell to the ground, causing personnel injuries. Balloon envelope drifted away, finally coming to rest 150 mi from accident site.Oct 8, 1984 · N47DP · Minor damage NTSB ATL83LA325Accident · No injuriesLimited investigationFinal reportPiccard AX-6 · Louisvile, KYThe plt received a wx briefing at 0600 EDT & noted nothing significant that would be a hazard to flt. He proceeded to long run park, aprx 20 mi east of louisville, KY, to launch the ballon. There was a 654 foot tower in the vicinity, but the plt believed the…Aug 13, 1983 · N16JF · Substantial damage NTSB FTW83FA324Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Azle, TXDuring a landing in light wind conditions, the balloon touched down beside a power line. After touchdown, the balloon envelope collapsed over the power line which carried 7200 volts. The voltage traveled to the basket/gondola which overturned on the grass…Jul 11, 1983 · N99US · Substantial damage NTSB FTW83LA155Accident · Serious injuriesLimited investigationFinal reportPiccard AX-6 · Springtown, TXThe 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…Mar 12, 1983 · N99US · No damage NTSB LAX83LA093Accident · Serious injuriesLimited investigationFinal reportPiccard AX-6 · Arroyo Grande, CAThe 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…Jan 1, 1983 · N84US · No damage NTSB CHI80DEC29Accident · Serious injuriesClosedPiccard AX-6 · Pontiac, MIAug 9, 1980 · N2482Z · No damage NTSB CHI79FEP46Accident · Serious injuriesClosedPiccard AX-6 · Middleton, WIMay 20, 1979 · N87DP · No damage NTSB NYC79DGT11Accident · No injuriesClosedPiccard AX6 · Huntsdale, PAMar 17, 1979 · N62US · Destroyed NTSB NYC78DGT04Accident · Serious injuriesClosedPickard AX-1 · New Holland, PAFeb 12, 1978 · N76JW · No damage NTSB CHI77DEX47Accident · Serious injuriesClosedPiccard AX6 · Wanamaker, INSep 10, 1977 · N3191 · Minor damage NTSB LAX77DUG34Accident · Serious injuriesClosedPiccard AX-6W · Perris, CAMar 6, 1977 · N19DP · No damage NTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXDec 30, 1976 · N53DP · Destroyed NTSB OAK76DXQ48Accident · Minor injuriesClosedPiccard AX-6W · Quincy, CAMay 31, 1976 · N69US · Substantial damage NTSB MIA76FKG65Accident · 1 fatalClosedPiccard AX-6 · Toccoa, GAMay 18, 1976 · N61US · Substantial damage NTSB LAX76DUG18Accident · No injuriesClosedPiccard AX-6 · Perris, CAOct 12, 1975 · N94DP · Destroyed NTSB OAK75DXQ51Accident · Serious injuriesClosedPiccard AX-6 · Incline Vlg, NVJun 29, 1975 · N27DP · Minor damage NTSB CHI75DEE25Accident · Serious injuriesClosedPiccard AX-6 · Harvard, ILOct 12, 1974 · N88US · No damage NTSB OAK75AP012Accident · 2 fatalClosedPiccard AX-6 · Tracy, CASep 21, 1974 · N53US · Substantial damage NTSB DEN73DQA36Accident · Serious injuriesClosedPiccard AX-6 · Albuquerque, NMMay 5, 1973 · N28US · No damage NTSB ANC73FAG85Accident · No injuriesClosedPiccard AX-6 · Wasilla, AKApr 29, 1973 · N56US · Destroyed NTSB CHI73FEG02Accident · Serious injuriesClosedPiccard AX6 · Xenia, OHAug 5, 1972 · N1695 · Destroyed NTSB NYC69F0179Accident · 2 fatalClosedPiccard AX6-PT · Penndel, PASep 19, 1968 · N3191 · Substantial damage

Back to Piccard AX-6