FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Accident 19990824013429ASnias AS350BA · Kahului, HISunshine helicopters air taxi (1993 aerospatiale AS-350 ba helicopter) landed hard and sustained substantial damage, no injuries were reported to the pilot and 4 pax, other circumstances are unknown. (.19) on August 24, 1999, at 1220 hours hawaiian standard…Accident 19990823044989ABbavia 7DC · Helena, AK(-23) Student pilot was manuevering for landing. Direction of flight was into sun. Student pilot struck tree that he didn't see.Accident 19990823042369ABlanca 1730A · Robbins, TN(.4)During cruise flight about 49 minutes after takeoff, the pilot declared a mayday and reported that the engine quit. Unable to land at the closest airport, he maneuvered the airplane for a forced landing to a field and collided with trees while descending.…Incident 19990823034599IMaule MXT7180A · Charlotte, NC(-23) Pilot departed clt to conduct a traffic reporting flight in the local area. Shortly after takeoff the pilot learned of incoming inclement weather in the intended reporting area. Pilot returned to clt and was cleared to land runway 23. On touch down the…Incident 19990823026039ICndair CL6002B19 · Orlando, FLDuring taxi to gate, comair inc. flight 5189, tallahassee to Orlando, the eicas "smoke cargo" red warning message illuminated, with aural warning and chimes. Crew executed qrh smoke cargo procedure discharging halon into the cargo area, but message remained.…Incident 19990823025589ICessna TU206G · Reno, NVFuel flow fluctuation and boost pump pressure out of adjustment, pressure adjusted i/a/w aircraft maintenance manual. Operational check satisfactory.Accident 19990823025569AGrob G103ATWIN2 · Llano, CA(.19) On August 23, 1999, at 1510 hours pacific daylight time, a burkhart Grob g 103 twin ii, N8013K, landed hard after encountering a dust devil at the Crystal gliderport in Llano, California. The glider, operated by great western soaring school, Llano, was…Incident 19990823025539IAmrgen AA5B · Dansville, NYOn Monday, August 23, 1999, a Grumman tiger AA-5B, on a trip from the philadelphia area to a private field in upstate new york made an emergency landing at Dansville, new york due to a rough running engine. The aircraft landed without incident. Maintenance at…Incident 19990823024769IPiper PA28181 · Matawan, NYApproximately 440 feet into the take-off roll on runway 27, the aircraft impacted a deer attempting to intersect the runway from the north. The aircraft sustained noticeable damage to one of the two fixed pitch propeller blades, the left under wing fuel tank…Incident 19990823024139IAmrgen AA5B · San Diego, CA(-23) At about 5 miles from myf, air traffic controller requested the pilot for best straight speed to the airport due to traffic. The aircraft speed was about 100 to 120 knots with the flaps up. The aircraft landed long on runway 28R. The aircraft came to a…Accident 19990823013379ACessna 172P · Hampton, GAAcft lost control on landing, struck rwy lights, the right main landing gear collapsed, and the acft skidded to a stop. (-23) see narrative #MIA99LA235Accident 19990823013349ABbavia 8GCBC · Wasilla, AKAcft crashed on take-off and sustained substantial damage, other circumstances are unknown. (.19) on August 23, 1999, about 1330 Alaska daylight time, a flight equipped Bellanca 8GCBC airplane, N5047Y, sustained substantial damage when it collided with trees…Accident 19990823013339AHughes 269B · Russellvile, AR1966 Hughes 269B helicopter experienced engine problems after take-off, came back down, and landed hard, the acft then spun around and came to rest on its side, other circumstances are unknown. (-23) at approx. 1130 local time N44KH impacted the earth. The…Accident 19990823013319AStolam RC3 · Chimacum, WAAcft crashed under unknown circumstances in discovery bay, the 2 POB suffered fatal injuries, the acft has unknown damage. (.4)the 1,100 hour pilot-in-command (PIC), who had just purchased the amphibious RC-3, had no amphibious/floatplane experience.…Accident 19990823013309ABeech D35 · Seminole, OKAcft was inbound to the arpt with an engine problem and attempted to clear high power lines, the acft went over the power lines, stalled, and crashed 50 yards from a fuel station, the pilot/sole ocupant suffered fatal injuries, the acft was destroyed by fire.…Accident 19990822044449ACessna 182J · Mc Call, ID(-23) The pilot landed long. His momentum carried him off the end of the runway and down an embankment. The a/c nose struck a dirt road below and became inverted.Accident 19990822043469ACessna 150K · Springdale, AR(-23) On August 22, 1999 at 08:50 CST a Cessna 150, N6015G, registered to lon hickman collided with an amateur homebuilt aircraft, which failed to yield the right of way. While taxiing north on the north/south taxi way visual meteorolical conditions prevailed…Accident 19990822043099APiper PA14 · Fairbanks, AK(-23) Pilot landed at a grass strip at private residence and sustained substantial damage due to a hard landing. Damage to right main gear. Stucture damage to fuselage attaching point and tail wheel area.Accident 19990822042919AN524MF · Springdale, AR(-23) On August 22, 1999, ay 8:50 an amateur/homebuilt, harris glastar-1 owned by floyd harris and piloted by gregory stanton a commercial pilot collided with a Cessna 150 operated by lon c. hickman when the pilot of the glastar failed to yield right of way…Accident 19990822041389ABeech C24R · Pickens, SC(.4) After having flown about 4 hours, the airplane was observed by two eyewitnesses at about 100 feet AGL, with no discernible engine sound, about 2 to 3 miles northeast of the destination airport. The pilot transmitted 'mayday' three times and said that he…Accident 19990822040329APiper PA14 · Grand Junction, TN(-23) Pilot was just prior to touching down when passenger in front seat activated the spoilers. This reduced the lift, causing the aircraft to land hard. At this point, the passenger released the spoiler control, allowing them to retract. The aircraft rose…Incident 19990822025819IDoug DC932 · Bloomington-Nor, ILOn 8/22/99, at approximately 1512 CDT, captain pete willis the appropriately rated pilot in command, started to taxi to the runway for takeoff. About 1/2 way to the runway the PIC did not think the aircraft felt right and about the same time another aircraft…Incident 19990822024959ICessna 172M · Waco, TXOn August 22, 1999, at 1945 a Cessna CE-172-M, registration number N64541, owned by dentex aviation, inc., and operated by justin miller was involved in an incident after landing on runway 19 after a solo flight. VFR flight conditions prevailed and no flight…Incident 19990822024889ICessna 402C · Nantucket, MAAircraft was performing ILS approach to runway 24 at Nantucket. Wind was blowing from 010 at 15 kt gusting to 19KT. Aircraft landed hard and nosewheel blew out and nose gear collapsed. One pilot, nine pax, one dog. No injuries. Aircraft evacuated on runway.Accident 19990822021729APiper PA28180 · Lapaz, IN(.4) The pilot reported the airplane would not slow down during the landing roll with the use of brakes. He reported that he did no retract the flaps and the grass was wet from the previous night's rain. He reported he initiated a turn to the right into…Incident 19990822019459ICessna 172N · Manassas, VA(-5)Student pilot landed 16L, wind 030 @ 10 knots. (Tower was in the process of switching the runways) student started drifting to right on landing, locked up brakes, blew tire, exited runway onto the grass on the right side.Incident 19990822019069IGulstm AA5 · Morgan Hill, CA(-5)Aircraft made a safe landing in a field after engine lost power and quit. Pilot stated that he attempted to change fuel tanks, but was unable to move fuel selector. After landing pilot switched fuel tanks and started engine. Inspection of aircraft…Accident 19990822013289ADoug MD11 · Hong Kong, CHChina airlines (flight #CAL642) acft crashed after reporting a camin fire and making an emergency landing at chek lap kok arpt, the acft reportedly came to rest inverted on the rwy and burst into flames, 2 POB suffered fatal injuries, 200 POB sustained…Incident 19990822013169IAmtr Acrosport · Lorain - Elyria, OHAcft veered off the rwy on landing, struck the VASI, and the landing gear collapsed. (-23) on August 22, 1999, at 1320 EDT, an experimental amateur built, richard e. hartzell, Acrosport, N38RH, lost directional control upon landing at Lorain County Regional…Accident 19990821047709APiper PA18150 · Granite City, IL(.4) The pilot said that during cruise flight the engine lost power. During the forced landing on rough and uneven terrain the airplane was substantially damaged. The pilot said he did not know the nature or origin of the loss of engine power. Subsequent to…Accident 19990821043579APiper PA25 · Salida, CO(-23)On August 21, 1999, at approx. 1100 MDT, a Piper PA-25, N6249Z, registered to jensen aircraft, inc. and piloted by james m. dickson , was substantially damaged when the aircraft stalled during an attempted go-around at Salida, Colorado. Mr. Dickson , a…Accident 19990821043119AN5465F · Cabot, AR(-23) On August 21, 1999 at 19:08 pm CDT, a single engine a/c, model Mooney A2A, alon-415-A2A, N5465F, operated and registered to criswell corporation. The pilot made an emergency landing short of a private grass strip 1 mile south of Cabot, AR. On hwy 89.…Accident 19990821043039ACessna 180A · Bozeman, MT(-23) Pilot stated that he was taxing a/c to parking and became distracted and taxied into a parked a/c tied down on the ramp.Incident 19990821034919IDoug DC931(-23) During takeoff roll, an abort was made at 100 knots due to the elevator being difficult to control. The rod end to the elevator boost cylinder was found pulled from the elevator attach point, jamming the left elevator to the full up position.Incident 19990821033529IAmtr Eracer · Chicago/Aurora, IL(-23) At approximately 4:20 CDT, the main landing gear collapsed on N345JM, an expermintal amateur built e-racer aircraft. At the time of the incident, the aircraft was landing on runway 09 at Aurora Municipal Airport (apr). The 14 CFR part 91 flight…Accident 19990821028499ACessna 172RG · Miami, FL(.19) On August 21, 1999, about 1059 eastern daylight time, a Cessna 172RG, N6231V, registered to sjg enterprises, inc., experienced a loss of directional control on landing at the kendall-Tamiami executive airport, Miami, Florida. Visual meteorological…Incident 19990821028029IPiper PA31350 · Cocoa, FL(-23) Right engine power loss in flight, precautionary landing was made at marrett Island airport. After landing during taxi to the ramp the right engine caught on fire. Passengers were evacuated, airport fire department put fire out with a hand fire…Incident 19990821027189IGrob G109 · Gordon, NE(-23) Pilot was on a ferry flight from clarksville, Ohio to eureka, California, stopped in rushville, Nebraska and picked up a relative and flew to Gordon, Nebraska to get fuel. After topping off the fuel tank with 16 gallons of fuel, the pilot attempted to…Incident 19990821024839ICessna 402B · Middletown, PAThis flight departed burlington, Vermont (btv) airport as an on demand FAR part 135 flight with one passenger. While on approach to Harrisburg, Pennsylvania, Middletown airport (MDT), the landing gear was lowered and the right main gear indicated unsafe. The…Incident 19990821024799ICessna U206GPilot was trying to taxi back to shore downwind, on lake iliamna, near iguigig, during high wind conditions (30-40 m.p.h.). Wind lifted tail up and over. Aircraft ended up floating on its back. The pilot in command, who was the only occupant, evacuated the…Accident 19990821024659APiper PA18 · Eagleville, CA(.19) On August 21, 1999, at 1900 hours pacific daylight time, a Piper PA-18-18, N3356B, collided with mountainous terrain after encountering what the pilot described as a downdraft near Eagleville, California. The aircraft was operated by jim & I aviators of…Accident 19990821013369ACessna U206G · Itkillik Lake, AKAcft crashed under unknown circumstances and sustained substantial damage. (-23) pilot was enroute from Itkillik Lake to bettles, Alaska. He became lost, disoriented, flew up wrong river bed into box canyon. Weather worsened with fog and rain showers. No room…Incident 19990821013279IAmtr THORPT18 · Limon, COAcft was taxiing after landing when the rudder pedal broke, and the acft ran off the rwy. (-23) on landing roll out, loss of control was induced by the pilot over-controlling the rudder pedals. There was minor damage to the right wing tip, the right gear…Accident 19990821013269APiper PA28180 · Weatherford, TXAcft took off, cleared a perimeter fence, lost altitude, crashed in a field, and struck a tree. (-23)on August 21, 1999, at 1055 a Piper PA-28-180, registration number N8981J, part owned by kenneth olson crahsed after takeoff at Parker County Airport during a…Accident 19990821013259ABbavia 7ECA · Livermore, CAAcft took off for local pattern work, lost power, and made an emergency landing off the approach end of rwy 25L. (-23)pilot reported normal takeoff and began a climb at 75 mph. At an estimated 400 to 500 feet AGL, the engine RPM dropped from 2600 to 1500 and…Accident 19990821013219ACessna 150F · Baton Rouge, LAAcft crashed under unknown circumstances and sustained substantial damage. (From .19) on August 21, 1999, at 2130 central daylight time, a Cessna 150F airplane, N6243R, struck a power line during a forced landing following a loss of engine power near zackary,…Accident 19990821013199ACessna TR182 · South Lake Taho, CAAcft crashed on landing rwy 18 after pilot failed to lower gear. (.19) on August 21, 1999, at 0905 hours pacific daylight time, a Cessna TR182, N4809R, landed gear up at the south Lake Tahoe Airport, Lake Tahoe, California. The airplane, operated by the pilot…Accident 19990821013179AAmtr CH701 · Mount Pleasant, NC(-23) See attached narrativeAccident 19990821013159ACessna 180 · Heber, UTAcft ground looped on landing. (-23) upon a 3 point landing at Heber Valley Airport, aircraft went out of control for the pilot when brakes were applied, resulting in a ground loop occuring. Investigation reveals that the right brake line failed, pulling…Accident 19990821013139AAmtr KOLBMK3 · Scott, OHAcft took off from a grass strip and struck the ground at a steep angle approximately 5-10 minutes later, the 2 POB suffered fatal injuries, the acft was destroyed, other circumstances are unknown. (.19) on August 21, 1999, about 1940 eastern daylight time, a…