NTSB investigations
2,248 cases where NTSB found Not determined, general.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 ERA22LA187Accident · No injuriesClass 3 · LimitedFinal reportLancair IV · Leicester, MAA separation of the window from the airframe for undetermined reasons.NTSB CEN22FA168Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Marlin, TXThe pilot’s failure to maintain control of the airplane during landing for reasons that could not be determined based on available information.NTSB ERA22LA168Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCVibration in the airframe and flight controls for reasons that could not be determined based on the available evidence.NTSB CEN22LA157Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Rayville, LAA loss of engine power for a reason that could not be determined based on available information.NTSB CEN22LA178Accident · Minor injuriesClass 3 · LimitedFinal reportCessna L-19E · Sunflower, MSThe total loss of engine power for reasons that could not be determined.NTSB CEN22LA156Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Springtown, TXA total loss of engine power for reasons that could not be determined.NTSB ERA22LA162Accident · 1 fatalClass 3 · LimitedFinal reportCzech Sport Piper Sport · Homestead, FLThe airplane’s collision with water for underdetermined reasons.NTSB CEN22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Englewood, COA total loss of engine power on short final for reasons that could not be determined based on the available evidence.NTSB ANC22LA020Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-18-135 · Wasilla, AKA partial loss of engine power for undetermined reasons.NTSB ERA22LA136Accident · Serious injuriesClass 3 · LimitedFinal reportFlightstar Flightstar II · Holly Hill, SCA loss of control during takeoff for reasons that could not be determined based on the available information, which resulted in a collision with a hangar and trees.NTSB CEN22LA128Accident · No injuriesClass 3 · LimitedFinal reportRyan L17 · Livingston, ILA total loss of engine power due to fuel injection system contamination from an unknown source.NTSB CEN22LA121Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Furlow, ARA loss of engine power for undetermined reasons.NTSB CEN22FA119Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Olathe, KSThe unknown emergency that warranted a return to the airport and the airspeed decay which resulted in an aerodynamic stall.NTSB CEN22LA103Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 120 · Sturtevant, WIThe pilot’s loss of directional control during the takeoff for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.NTSB ANC22LA014Accident · No injuriesClass 3 · LimitedFinal reportBell 205A-1 · El Cajon, CAA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA22FA105Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter Deutschland EC135 P2+ · Drexel Hill, PAAn inflight attitude upset for undetermined reasons that resulted in a rotor system overspeed, a reduction of power from both engines, and a subsequent hard landing.NTSB CEN22LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Youngstown, OHA loss of engine power for reasons that could not be determined based on available information, which resulted in a forced landing.NTSB CEN22LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Grand Forks, NDFailure of the landing gear to properly extend before landing for reasons that could not be determined.NTSB ERA22LA099Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20C · Southeast Arcadia, FLThe total loss of engine power for reasons that could not be determined based on the available evidence for this investigation.NTSB ANC22LA011Accident · No injuriesClass 3 · LimitedFinal reportLarry Bingham LB-1 · Haines, AKA partial loss of engine power for reasons that could not be determined based on available information, which resulted in a precautionary landing and impact with snow.NTSB CEN22LA072Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL18 · Abbeville, LAAn electrical fire for reasons that could not be determined.NTSB CEN22FA070Accident · 1 fatalClass 3 · FieldFinal reportCessna 310J · Inola, OKThe loss of airplane control for reasons that could not be determined based on the available evidence.NTSB WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.NTSB CEN22LA055Accident · Minor injuriesClass 4 · LimitedFinal reportRay Earl D Flightstar Iisc · Haskell, OKA sudden loss of engine power after takeoff for undetermined reasons based on the information available.NTSB CEN22FA053Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · Perry, OKA loss of lateral control during a hover that resulted in an impact with terrain. Based on the available evidence, the reason for the loss of lateral control could not be determined.NTSB WPR22LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Tooele, UTThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA22LA067Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Glens Falls, NYA total loss of engine power for reasons that could not be determined.NTSB WPR22LA034Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Molalla, ORThe loss of engine power for undetermined reasons.NTSB CEN22LA039Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36TC · Rockport, TXThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA22FA056Accident · 1 fatalClass 3 · FieldFinal reportZenith CH601 · Oak Hill, FLA loss of airplane control while maneuvering at low altitude.NTSB ERA22FA051Accident · 1 fatalClass 3 · FieldFinal reportIssitt Greg Sonex · Malone, FLAn in-flight collision with a tree for reasons that could not be determined.NTSB ERA22LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Newport Richie, FLA loss of directional control on landing for undetermined reasons.NTSB WPR22LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna R172K · Rexburg, IDA total loss of engine power for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical issue.NTSB ERA22LA039Accident · No injuriesClass 3 · LimitedFinal reportBell 47D1 · Zelienople, PAA total loss of engine power for reasons that could not be determined.NTSB ERA22LA029Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Westhampton Beach, NYA total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.NTSB ERA22LA017Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Fire Island, NYA total loss of engine power for undetermined reasons.NTSB ANC22LA002Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Chickaloon, AKA mid-air collision for reasons that could not be determined based on the available evidence.NTSB CEN22LA012Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Wildwood, ARA total loss of engine power for reasons that could not be determined.NTSB CEN22LA007Accident · Minor injuriesClass 3 · LimitedFinal reportSoneral L2 · Minot, NDThe pilot’s failure to maintain proper airspeed and exceedance of the airplane’s critical angle of attack on final landing approach, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the pilot’s inexperience with the…NTSB WPR22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportZenith CH750 · Oregon City, ORThe total loss of engine power for undetermined reasons.NTSB CEN22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B23 · Lamesa, TXThe loss of engine power for a reason that could not be determined.NTSB ERA21LA384Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Hobe Sound, FLA reported loss of engine performance for reasons that could not be determined.NTSB CEN21FA459Accident · 3 fatalClass 3 · FieldFinal reportRockwell International 690B · Hiles, WIThe pilot’s failure to maintain adequate airspeed, which caused the airplane to exceed its critical angle of attack and enter an inadvertent stall and spin.NTSB WPR21LA366Accident · No injuriesClass 4 · LimitedFinal reportSharp Ralph R Zenith Stol CH 701 · Bishop, CAA loss of airplane control for undetermined reasons.NTSB WPR21LA354Accident · No injuriesClass 3 · LimitedFinal reportHiller UH-12E · Bovill, IDA loss of helicopter control for undetermined reasons based on the available evidence for this accident.NTSB ANC21LA096Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-14 · Chickaloon, AKA total loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB WPR21LA350Accident · No injuriesClass 3 · LimitedFinal reportCessna 404 · Sheridan, WYThe pilot experiencing an episode of impaired behavior and incapacitation for reasons that could not be determined based on the available information.NTSB ERA21FA355Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8KCAB · Rhine, GAA collision with trees during a low-altitude aerobatic maneuver for unknown reasons.NTSB CEN21LA414Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · LaSalle, COA loss of engine power for undetermined reasons.NTSB ERA21LA350Accident · No injuriesClass 3 · LimitedFinal reportRaytheon 390 · Naples, FLThe pilot was unable to stop the airplane during the landing for reasons which could not be determined, resulting in a runway excursion.