NTSB investigations
3,567 cases where the first occurrence was “In flight encounter with weather”.
Cases, newest first
Query with SQL
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_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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240) 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_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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240) 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 LAX82FVG14Accident · 1 fatalFinal reportCessna 150M · Davis, CAThe non-instrument rated pilot had recently received a night checkout on 1/8/82 and was scheduled to have been on a practive night flight. The three nearest weather stations reported ceilings between 200 ft and 400 ft and visibilities from 3/4 to 1 1/2 miles…NTSB ATL82FA039Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Blairsville, GAThe aircraft departed atlanta, GA on a flight with no flight plan to an intended final destination of morristown, TN. However, during a weather briefing, the pilot had inquired about the tri-cities airport at bristol, TN. While en route, the aircraft crashed…NTSB ANC82DA014Accident · Minor injuriesFinal reportCessna 150 · Anchorage, AKDuring takeoff, the aircraft entered a fog bank near the end of the runway while the student was at the controls. The student released the yoke and thought the instructor had assumed control. The instructor reported that he was not paying close attention and…NTSB FTW82FA041Accident · 1 fatalField investigationFinal reportBell Helicopter 206L-1 · Houma, LAThe acft was enroute to the ship shoal area in the gulf of Mexico. Another plt who departed earlier advised the plt that he & another acft had turned around & was returning after encountering a low ceiling & reduced visibility. The surviving pax stated that…NTSB NYC82FA021Accident · Serious injuriesField investigationFinal reportSwearingen SA 226-TC · Jamaica, NYBefore N341PL started takeoff on runway 31L, a Boeing 747 was cleared to taxi southeast down the outer/parallel taxiway. The taxiway was 375 ft right of the runway centerline. The 747 stopped momentarily, then turned 90 deg left onto taxi- way kk. Meanwhile,…NTSB SEA82DA017Accident · No injuriesFinal reportPiper PA-31-350 · Spokane, WAAfter arriving in the Spokane area, a full ILS was commenced. It was terminated about 200 ft above the decision height with a missed approach. The aircraft was vectored for a second ILS. During the last 400 ft of this approach, about 3/4 to one inch of mixed…NTSB FTW82FPA10Accident · Serious injuriesFinal reportBeech P35 · Addison, TXThe aircraft was attempting to go around from an ILS approach when the pilot made visual contact with the runway. The pilot attempted to land, stalled the aircraft, and dropped to the runway. Ice had accumulated on the leading edge of the wings, the tail, and…NTSB DEN82FA017Accident · 4 fatalField investigationFinal reportCessna 210N · Riverton, WYThe acft impacted a hill immediately after taking off. The wreckage was located 8,000 ft beyond the departure end of rwy 28 & 1,800 ft left of the rwy centerline extended. The accident site was approximately 55 ft above the airport elevation. Witnesses…NTSB DEN82FTI10Accident · Serious injuriesFinal reportPiper PA-28-140 · Near Bozeman, MTThe pilot was on an early morning flight over mountainous terrain at 8500 feet. While inbound to his destination, he encountered an area of restricted visibility with snow. As he started a right turn to correct to his desired course, his passenger alerted him…NTSB ANC82DA013Accident · Minor injuriesFinal reportCessna U206 · Quinhagak, AKEnroute the center seat passenger unfastened his seat belt and crawled up between the two front seats. While approaching Quinhagak the pilot had difficulty making the passenger return to his seat. After finally getting the passenger settled down he turned…NTSB ATL82DA031Accident · No injuriesFinal reportBeech V35 · Westminister, MDThe pilot reported encountering severe downdrafts and turbulence at the runway threshold. He stated that he applied full throttle, but the aircraft touched down prematurely and was angled about 30 degrees right of the runway heading. The aircraft came to rest…NTSB MKC82DA016Accident · No injuriesFinal reportCessna 340 · Rolla, MOThe aircraft was certificated for flight into known icing conditions up to moderate icing. The pilot stated that the surface de-icers were operating during the preflight. During an instrument approach at the destination. The aircraft entered clouds at about…NTSB LAX82DVA10Accident · Serious injuriesFinal reportBoeing A75 · Near Bakersfiel, CAThe pilot was enroute to las vegas, Nevada for a banner towing operation. As he proceeded eastbound along highway 58, he encountered fog that was forming in the tehachapi foothills. He initiated a 180 degree turn to go back, but inadvertently entered IFR…NTSB SEA82FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Pleasant Hill, ORThe plane tookoff at 1505 PST on a local VFR pleasure flight with 4 occupants and about 48 gallons of fuel on board. The plane was estimated to be about 140 lbs over the maximum gross weight limit. At about 1622 PST, it was observed to break up in flight.…NTSB LAX82FA036Accident · 1 fatalField investigationFinal reportPiper PA-22 · Black Canyon Ci, AZThe wreckage was located at the 3,030 foot elevation on the south side of a plateau. The weather in the area of the accident would have approximated the reported conditions at prescott, AZ located approximately 40 mi nnw.NTSB CHI82FA019Accident · 2 fatalField investigationFinal reportCessna T337G · Fort Wayne, INOn 1/31/83 at 2134 CST, the acft departed grand island, NE on an IFR flt plan to toledo, OH, with appx 125 gal of fuel on board. While en route, the plt received updated wx for toledo. At that time, the toledo wx was indefinite 100 ft obscd, vis 1-1/2 mi with…NTSB FTW82FRA14Accident · 1 fatalFinal reportCessna R172K · Hearne, TXBefore the aircraft took off, fog was noted at the airport. Witnesses reported that the ceiling was about 100 to 200 ft and the visibility was about 1/2 mile. Reportedly, the pilot tried to contact the fss by telephone; however, only a pay telephone was…